Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Grouping a split total Post Reply Post New Topic
Author Message
Trisha22191
Newbie
Newbie
Avatar

Joined: 15 Apr 2008
Online Status: Offline
Posts: 10
Quote Trisha22191 Replybullet Topic: Grouping a split total
    Posted: 13 May 2008 at 6:28am
Hopefully someone can help.
 
I have a report that took 50% of total items completed and displayed these items.
 
What I need to do is split them in half among two people.  It should look like this:
 
NAME
Item 1
Item 2
.
.
.Item 50
 
NAME
Item 51
Item 52
.
.
Item 100
 
Can someone help me display this on a report?
 
Thanks
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 13 May 2008 at 10:18am
Hmm.  I'm guessing that this isn't a case where "NAME" already exists in the database records?  Then, what you are going to have to do is insert it.

Create a formula, and call it something like AssignName.  It should look like:

IF {MyReport.Item_No} <= 50 THEN
    "Name 1"
ELSE
    "Name 2"


You can then create a group on @AssignName, which should break it up as you wish.


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.