Reusing a dataset for multiple reports 1

[SpankySpanky]

I'm only starting out with CR. What I want to do it use a single dataset containing a large number of records, and use it to supply a number of subreports with different views into the data.

I wanted to avoid reloading more or less the same dataset for each subreport, if I could get away with using the same dataset, similar to the way different dataviews see different views of a dataset. I understand this is possible in VB2005 but not in VS2003 (I use 2003).

1) Is this possible somehow?

2) Alternatively, could I load the dataset and destroy it after generating each subreport and have the subreports retain the data without the underlying dataset still being live?

Thanks for any comments.

 

[Madawc]

A subreport does its own read of its datasets: that's what it is.

Have you looked at crosstabs? They let you show the same data in different ways in the same report.

Also which version of Crystal?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[SpankySpanky]

Thanks for the advice. That got my head on straight.

 

[IdoMillet]

If CrossTabs are not a full solution for you, you can export one report to a table (using ODBC as the export format). Then, use the resulting table in other reports. There are tools that can automate this process.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com