Group on a Dimension from sub report

[TheRDTGuy]

In BusinessObjects it is possible to group on a dimension from a sub-report. Can some confirm that this is not possible in Crystal.

 

[synapsevampire]

It is not possible to group on subreported data, however you can use SQL Expressions to return data to the main report.

In general a subreport is a bad idea, especially so if you intend to group on it's data.

If you want architectural ideas, you should at the least post the version of your software, and include specifics.

-k

 

[TheRDTGuy]

Thanks for the info. You are right sql is a better approach. However, some times with large data volumes or if the dimension data is in a spread sheet having this capabiltiy is powerful.