Crystal Reports Complex grouping (Maybe)

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Complex grouping (Maybe)

Author	Message
Tupacmoche Groupie Joined: 04 Apr 2007 Online Status: Offline Posts: 52	Topic: Complex grouping (Maybe) Posted: 06 Jun 2007 at 10:18am
	I have a report that has several groups that work nicely. But it requires some of the groups not all to be summarized below them. So I will have: Dept A Dept B Dept C Dept E Summary of Dept C and E Dept F Dept G Any thoughts on how this can be accomplished?
	Rob
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 06 Jun 2007 at 2:44pm
	First, I would do a manual running total and use logic within that formula to determine when a group should be added to the total. This could be a little complicated depending upon how many groups do/don't need to tget added. Secondly, I would use the Section Expert to conditionally suppress the group footer for the groups where you don't want the running total to be shown.
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

Tupacmoche Groupie Joined: 04 Apr 2007 Online Status: Offline Posts: 52	Posted: 08 Jun 2007 at 10:18am
	Sorry I believe that I was a bit vague in my description of the problem. I have a report with many groups for a company. Lets say they are Medicine, OB/GYN, Surgery, Pediatrics ect. See below: Medicine 895,458 888,937 777,211 124,411 Ob/Gyn 103,111 521,111 132,983 374,111 Surgery 999,127 987,123 888,123 876,222 Pediatrics 363,111 932,111 222,132 342,324 These departments have already been grouped with totals by dept. Now what I want to do is the following: Medicine 895,458 888,937 777,211 124,411 Totals for Ob/Gyn, Surgery, Pediatrics 1,465,349 2,440,345 1,243,238 1,592,657 As you can see three (3) of the above groups were grouped in a single row. Does anyone know how to do this?
	Rob
	IP Logged

Tupacmoche Groupie Joined: 04 Apr 2007 Online Status: Offline Posts: 52	Posted: 08 Jun 2007 at 10:22am
	Sorry I left one thing out. Medicine 895,458 888,937 777,211 124,411 Ob/Gyn 103,111 521,111 132,983 374,111 Surgery 999,127 987,123 888,123 876,222 Pediatrics 363,111 932,111 222,132 342,324 Totals for Ob/Gyn, Surgery, Pediatrics 1,465,349 2,440,345 1,243,238 1,592,657 The individual dept should remain in the report with one summary line for that group.
	Rob
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.