CR VS 2010. Working with huge volume of data.

[Former Member]

Hi!

I would like to take suggestions.

How is the best way to work huge volume of data.

For ex.: my db table contains about 6 000 000 records.

How do I need to implement paging in Crystal Reports?

Are there any options in ASP .NET Crystal Report View Control?

Thanks.

[former_member184995]

Other than filtering the data so that you dont have 6 million rows...

Make sure you connect directly to the database...do not use datasets or xml...at all..

Put the report into httpsession and set it to the viewers reportsource so that when you page you dont rerun the report every time.

Jason

[Former Member]

Hi!

I do so.

Could Crystal Reports .NET Runtime loads data partailly from DB?

[former_member184995]

Nope, pretty much all or nothing.

There is no way to only grab parts of the data as needed that I know of.

[Former Member]

Hello,

You can use a stored procedure and then a stored procedure parameter will do the filtering on the database side.

Sincerely,

Dan Kelleher

[former_member11696]

Other than using the Record Selection formula to do the filtering and running the report in blocks of data, this does hit the DB each time.

Another option is to use the CrystalDecisions.ReportAppServer.Controllers.FilterController SavedDataFilterController { get; }

Member of CrystalDecisions.ReportAppServer.Controllers.ISCRDataDefController.

You can add filtering on the fly with a report with saved data, not sure about performance with that amount of data though but depends.

I don't have any sample code, I do somewhere buts it's been a few years since I played with this function. I'll see if I can find it.

Don

[Former Member]

Thanks for various answers.

But why Crystal didn't use .NET DataReaders like Microsoft Management Reporter?

From my point of view, it is pretty good for memory economy.

[former_member11696]

From my point of view who will ever use 6 million rows of data? CR is free, if MS Reporting is free then use it.

Crystal is not a database archiving tool, filter your data into small enough info that will actually be of use to someone.

If you are summing or grouping then do it all server side using a stored procedure, DB servers are designed for this functionality. Use Crystal to format the results in a readable fashion.

Don

[Former Member]

Hi!

For example, I use Crystal Report which contains only cross-table.

1) Why Crystal .NET Runtime does not generate grouping SQL query to ask sql only total values?

2) Could I handle generation from Crystal Report?

[former_member11696]

Hello,

I moved your post to the Report Design forum. Get this working in CR first then it should work in your application.

Don