Crystal Reports Using Universe (Perform Goruping on Server )

[sachin1610]

HI,

Perform Grouping on Server is not enable while I am trying create report from universe.
Crystal Reports does not allow using Universe Hierarchy.

Does anyone know about it?


Thanks in Advance!

sachin

 

[skrandel]

Crystal does not use universes very well.

What sort of Grouping are you talking about?

Steve Krandel
Intuit

 

[sachin1610]

Thank you for time!

I am doing drill down on report on Grouping and crystal generates thousand rows.
Report has few groups for those thousand rows. I want to use PERFORM GROUPING ON SERVER which generates few rows instead of thousand.
You can find PERFORM GROUPING ON SERVER under Database.


Thanks Again!

sachin

 

[skrandel]

When universes are used, the Group By statement is created automatically if you have built your measure objects correctly. I suspect you haven't

EVERY measure in a universe should have SQL aggregation on it.

eg. Amount should look like Sum(table.amount).

Steve Krandel
Intuit