[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 306
  • Last Modified:

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?
0
Mike Johnson
Asked:
Mike Johnson
  • 2
  • 2
1 Solution
 
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
 
mlmccCommented:
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
 
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now