Generating a Report from Multiple Data Sources in Crystal Reports

Can you please tell me which name space or DLL i have to add in my project to find 'DynamicReport' class. i m using CR 10, and current i m using these three namespaces in my project.  

using CrystalDecisions.Shared;
using CrystalDecisions.Web;
using CrystalDecisions.CrystalReports.Engine;

but when i try to use your code i can't find 'DynamicReport' what you use in your Code.

i am using VS 2003 and i could not find the property called

Subreports.Item

I am using VS 2003 also but also have CR 10 installed.

VS 2003 uses CR 9.0 by default and it is possible Report class does not have that property but there should be something similar.

Crystal Reports section has more example. Click on Crystal Reports in the left side menu or go from Technologies menu.

Do you need any specific sample?

Hi Mahesh,

follow line doesn't work in VS2005(C#.Net).

report.Subreports.Item("SubReport1").SetDataSource(ds.Tables("Customers"))

Could You tell me what is the equal command in VS2005

thanks and regards

Srini

Srini,
Make sure your report has a sub report called "SubReport1" and your DataSet should also have a DataTable named "Customers". If you are getting data from the database and filling it direct, use "ds.Tables(0)" instead, which will return first table no matter what the table name is.

I face following problem

(1)report.Subreports after that I am not getting "Item" keyword

Yes Report had SubReports name "SubReport1"

marshall_martin@bcbstx.com

I use this and I can set the sub report datasource but the problem it says that it cannot find my parameters in my sub reports.

 crLtr_New.Subreports.Item("ltrIneligiblewithSum.rpt").SetDataSource(Me.DsAll1.Tables("dbo_usp_WS_RACI_Summary_Reports"))
        'crLtr_New.SetParameterValue("prmRACI", Me.DsAll1.Tables("dbo_get_ineligible_with_sum").Rows(0)("group_raci"))
        'crLtr_New.SetParameterValue("prmAddr_Ln1", Me.DsAll1.Tables("dbo_get_ineligible_with_sum").Rows(0)("addr_ln_1"))
        'crLtr_New.SetParameterValue("prmAddr_Ln2", Me.DsAll1.Tables("dbo_get_ineligible_with_sum").Rows(0)("addr_ln_2"))

Hope it helps,
MECCA

Yes you can generate a report from two DataSets. The simplest way for this would be you Merge two DataSets in your code and to the report you actually be passing only a single DataSet object.

Check out DataSet.Merge method.

i am using VS 2003 and i could not find the property called

Subreports.Item

Could You tell me what is the equal command

thanks and regards,

Jeya.

Have you created an instance of your report class you added using VS 2003? Say your report is, JeyReport.rpt, you have to do something like this:

JeyReport jr = new JeyReport();

Then you can access SubReports property using jr.SubReports

The error has nothing to do with the number of subreports. It seems like problem is in your connection. If you are using hardcoded SQL Server connection in your report, check that out. There is nothing much I can tell you.

Thanks for ur advice.

It's because of some connection problem.

Now it's working well.

follow line doesn't work in VS2003 using VB.NET report.Subreports.Item("SubReport1").SetDataSource(ds.Tables("Customers")) Could You tell me how i can use it?

I have created object of report like below but still same problem

JeyReport jr = new JeyReport();

thanks and regards Santosh

Hi.

Even I was facing the same problem. I did it this way to overcome the issue.

ReportDocument rpt = new ReportDocument();

rpt.Load(strApplicationPath + @"\rptMultiple.rpt");

rpt.Subreports["rptMultiple_1.rpt"].SetDataSource(ds.Tables[0]);

rpt.Subreports["rptMultiple_2.rpt"].SetDataSource(ds.Tables[1]);

where rptMultiple.rpt is the main report and rptMultiple_1.rpt and rptMultiple_2.rpt are two subreports. You can even use the index of the subreport as follows:

rpt.Subreports[0].SetDataSource(ds.Tables[0]);

Now, run the main form, you will be able to view the report, but if you click on the data, it will drildown to the subreports. In order to overcome that, go to the windows/web form, change the crystalreportviewer's 'EnableDrilDown' property to False.

Hope someone will find this useful.

Regards,

Leo.

Hi Mahesh,

When the page loads for the first time it works fine and then when I click the next page it gives the error "The communication channel has not been created" while assigning the datasource for the subreport. (myReportDoc.Subreports[0].SetDataSource(dataSet.Tables[1])). Any idea?

I am using Crystal Reports which comes with VS 2005.

Thanks Chocks

Hi Mahesh,
I have same requirement accept that I do the same thing in Asp.net 2.0 with the XSD file. I fill the XSD file with the dataset and XSD is bind with the crystal report. I requires three page header section as in First section I required to write company name and its address and other details and then the two page header sections for the two sub reports.
And after that i required to show two sub reports with their individual totals which I am doing in the same individual sub report and after that I required the grand total. I try the solution which you discuss in this articles but unfortunately It gives error "The page size was not large enough to format the contents of an object in the report. Error in File C:\DOCUME~1\kapil\LOCALS~1\Temp\PolicyStatusreport {0E96C854-3FDE-4C82-8A01-C15F9A7138C7}.rpt: Page header or footer longer than a page".
My requirement is some what like.

Report Header
  - Page Header 1
      Static Data
  - Page Header 2
      Sub Report 2
  - Page Header 3
      Sub Report 3
      Detail Section (Hide it)
-------------------------------------------------> After data I required the "Grand Total" which is the sum of the total of the two individual reports.
  - Page Footer
Report Footer

Please give me some suggestions to sort out this error.