Yes the Sub-Report option is better since in crystal reports when we add tables the Link Expert tries to link them.
Here are my recommendations. 1) Use Sub-Reports 2) In each sub-report when you add the Data Source use the Typed DataSets as your DataSource. Don't link the report directly with Database. 3) In this way you can create different DataSets for each report. 4) To render each sub-report on different page, put them in different sub-sections and in Section Expert use "New Page After" property. On Thu, Jan 20, 2011 at 12:26 AM, GoLive <[email protected]> wrote: > Hi, > > I am trying to create a report using crystal report 11 and asp.net > 2.0(C#) and Oracle10g. > > My requirement is to create a report in a single click(from user's > end) such that a report contains 6 pages with each pages different and > is connected to different dataTable. I pass three parameter > (1)USER_ID, (II)YEAR and (III)TYPE. Based on these parament i'd like > to construct a report with different layout on different pages with > different datasource. > > Can i do it in single .rpt file or do i need to nested with sub > reports. I am trying to create 6 subreports with their own datasource > and put it in one parent report to display data, but not able to do > it. > > Please suggest me your valuable comments. > > > > Thanks. >
