Crosstabs versus subreports... which are better in a group footer

I need to do some summarizing in my crystal reports group footer.   I know that you shouldn't use "subreports"  in the detail or  group footer because to  the overhead, but are crosstabs any better?  Would a crosstab be more efficent and less overhead in this situation?
Mike JohnsonBusiness Inteligence DeveloperAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
I agree, a crosstab should be better.  It should work so long as the summarizing you are doing is over the full recordset for the group.

mlmcc
0
 
vastoCommented:
Subreports should not be used in the details section because it is a separate report with a separate call to the database. Pacing it in the details section means that a new report will be started for each record in the details section of the main report. Crosstab is a calculation inside the same report and even if there will be some additional processing , it should be not so bad as the subreport. I would try the crosstab.
0
 
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
Thanks
0
 
Mike JohnsonBusiness Inteligence DeveloperAuthor Commented:
Just curious... I'm assuming the "crossTabs" use the main report query, as were with the subreports have their own query.  Thus the increaased I/O with the subreports?
0
 
mlmccCommented:
Yes, that is in general true.

Sometimes the subreport effect is negligible other times it is very noticeable.

mlmcc
0
All Courses

From novice to tech pro — start learning today.