Cross-Tab & Grouping on Server

[ChuckVanT]

Is there a way to get these two features to work in concert?

I have several million rows that summarize down to something in the 10's of thousands.

Bringing back the whole year's data is, obviously, impractical.

The Cross-Tab option fits the report well, and I don't want to re-invent the wheel, by doing a manual Cross-Tab if I don't have to.

Any tips???

Thanks in advance, again!

Chuck

 

[IdoMillet]

Use a query, Command (Crystal 9), View, or Stored Procedure as the data source fot your report.

The SQL syntax should include a "Group By" for the lowest level of detail you need in the CrossTab.

Cheers,
- Ido



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

http://www.MilletSoftware.com