By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,660 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,660 IT Pros & Developers. It's quick & easy.

Crystal Report from multiple tables

P: n/a
RAF
i'm trying to make report using dataset having two tables

in viewer page iam doing

rpt.SetDataSource(ds.Tables(0))
rpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = rpt

but it is not working

please tell the right way.

thanx in adv
RAF

Nov 22 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Crystal Reports does not read tables into the record
source. The only way to set the source is by using
multiple datasets.

rpt.SetDataSource(ds1.Tables(0))
rpt.SetDataSource(ds2.Tables(0))

Crazy I know, but that's what you have to do.

Shawn
-----Original Message-----
i'm trying to make report using dataset having two tables

in viewer page iam doing

rpt.SetDataSource(ds.Tables(0))
rpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = rpt

but it is not working

please tell the right way.

thanx in adv
RAF

.

Nov 22 '05 #2

P: n/a
RAF
hi

It is still not working it generates following error
"
Logon failed.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details:
CrystalDecisions.CrystalReports.Engine.LogOnExcept ion:
Logon failed.
"
regards RAF
-----Original Message-----
Crystal Reports does not read tables into the record
source. The only way to set the source is by using
multiple datasets.

rpt.SetDataSource(ds1.Tables(0))
rpt.SetDataSource(ds2.Tables(0))

Crazy I know, but that's what you have to do.

Shawn
-----Original Message-----
i'm trying to make report using dataset having two tables

in viewer page iam doing

rpt.SetDataSource(ds.Tables(0))
rpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = rpt

but it is not working

please tell the right way.

thanx in adv
RAF

.

.

Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.