Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Separate data Grouping Post Reply Post New Topic
Author Message
adg_
Newbie
Newbie
Avatar

Joined: 22 Apr 2009
Location: United States
Online Status: Offline
Posts: 1
Quote adg_ Replybullet Topic: Separate data Grouping
    Posted: 22 Apr 2009 at 12:48pm
I have two different groups of data in a report, which I'd like to display individually, rather than as nested groups.

The data to be group consists of Product Orders (group 1) and Manufacturing Instructions (group 2).

In the report, I'd like to display all the Product Orders, (0 to many) and then the set of Manufacturing Instructions (1 to many). 

With the way I'm grouping now, the set of Manufacturing Instructions gets repeated once for each Product Order, which is just duplicating the same data.

Is there a way to accomplish this, with or without groups?

I've considered using a separate subreport to display the Product Orders, but the calling code only knows how to pass one parameter, leaving little leeway to request separate data from the DB.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Apr 2009 at 1:05pm
If i understand you correctly as long as your rows do not overlap to fall into both groups you can avoid a sub report.
Create a formula to to determine which rows fall into which categories and then group on the formula.
if condition1 then "Product Orders" else
if condition2 then "Manufacturing Instructions"
else "Missed Records"
The last item is just a safe guard to make sure all your records fell into 1 or 2.
If any row overlaps into both categories then you will need a sub report.
IP 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.