Grouping in report footer
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13739
Printed Date: 26 Apr 2024 at 7:36pm
Topic: Grouping in report footer
Posted By: wh0dathunk
Subject: Grouping in report footer
Date Posted: 13 Jul 2011 at 3:16am
|
Hi, Im very new to Crystal reports.
I'm not quite sure how to add grouping in the report footer.
The report needs me to group the table data according to one column (say 'product')and inturn show the count of 'varieties' within that 'product'.
something like :
product A variety 1 count of variety 1
variety 2 count of variety 2
variety 3 count of variety 3 ***********************************************
product B variety 1 count of variety 1
variety 2 count of variety 2
variety 3 count of variety 3
where 'variety 1,2 ,3' are just labels. this needs to get displayed at the report footer.
Any help would be greatly appreciated.
 |
Replies:
Posted By: lockwelle
Date Posted: 13 Jul 2011 at 3:42am
|
if you are printing out more than 1 line in the report footer, you are probably looking at a subreport, which would be the easiest, but adds at least 1 hit to the database. The other option that comes to mind is using 'shared numbervar array', which I don't think is going to be simple, but would save the hit to the database. probably, the subreport is truly the easiest and fastest to develop, and won't impact performance too badly as it is probably only 1 more hit, not hundreds. HTH
|
Posted By: IdoMillet
Date Posted: 13 Jul 2011 at 4:16am
|
Simplest solution is to insert a CrossTab in the report footer. No need for a subreport. ------------- view, e-mail, export, burst, distribute, and schedule Crystal Reports. www.MilletSoftware.com |
Posted By: lockwelle
Date Posted: 13 Jul 2011 at 4:23am
|
hmmm....don't use crosstabs very often, so it didn't occur to me. thanks for the hint...who knows when I will need it as well.
|