Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: possible to combine only 2 records in a group? Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Jan 2013 at 10:21am
well, you cannot actually alter data using crystal.
Is the issue that a user might select only one of the 2 IDs?
IP IP Logged
MellieD
Newbie
Newbie
Avatar

Joined: 03 Dec 2012
Location: United States
Online Status: Offline
Posts: 16
Quote MellieD Replybullet Posted: 22 Jan 2013 at 10:24am
The issue is that the sales rep who handles both accounts for the customer, would like to have it printed in one sheet instead of two, so he dose not have to do the extra math when presenting the customer with the information. So he was hoping there was a way to merge the two accounts onto the one page.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Jan 2013 at 10:56am
what is the structure of your report?
Sounds like you are using grouping and drilling into the report so I was trying to give you a solution so that all of the detail records would be combined via grouping.
IP IP Logged
MellieD
Newbie
Newbie
Avatar

Joined: 03 Dec 2012
Location: United States
Online Status: Offline
Posts: 16
Quote MellieD Replybullet Posted: 22 Jan 2013 at 11:40am
The report is almost in a Letter format, with each customer having a full page for their information.

I have the report Grouped by customer ID as per the changes you suggested, and originally had the report grouped by customer name. The report contains sales totals, and sales goals for the time length of the program (10/12-10/13). Each page is listed by company Name and customer ID. Not sure what other info you need, please ask and I will be happy to provide any more detail.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 22 Jan 2013 at 11:54am
you should be grouping by the formula field that converts teh customer id not the original customer ID.
IP IP Logged
MellieD
Newbie
Newbie
Avatar

Joined: 03 Dec 2012
Location: United States
Online Status: Offline
Posts: 16
Quote MellieD Replybullet Posted: 22 Jan 2013 at 12:08pm
It looks like it's working this time. I have sent the information to the sales agent who had requested, and i will let you know if there are any other issues that pop up. Thank you again for all the time and help you have provided me today. Thumbs%20Up
IP IP Logged
<< Prev Page  of 2
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.