Dataset in Crystal Report

[Guest]

Hello everyone,

I'm working with a web application now and we're finding a way to improve
the speed of viewing a report (Crystal report).

We used a dataset instead of connecting the crystal report directly to the
SQL Server that we are using. We thought that this time, we will only have
one connection to the SQL Server and that is when filling the dataset.
However, during our test of the report, we found out that the Stored
procedure that we used in the dataset is being executed everytime the report
form changes.

Does this mean that the dataset refreshes it self everytime the Crystal
report uses its data? We thought that we only have to fill the dataset once
and that there will be no other connection to the SQL Server that will be
created (by the Crystal report, i guess) everytime we changes a report page.

Your ideas will be higly appreciated.

Thank you.

 

[Sahil Malik]

Nonoy,

Chances are the reconnection to the d/b is due to the code you have around
your crystal report, not IN the crystal report cs code. You can completely
disconnect the dataset and then bind it to the crystal report - so in short,
the database need not be hit again, provided you have enough information in
the dataset already to render the crystal report properly.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik