Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 15 Oct 2007 at 9:19am
Yes, you have to use the customize group name option. Is this not working, or are you confused as to how to use it?
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>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 15 Oct 2007 at 12:21pm
I see. I cover how to customize the group name with a formula starting on page 107 of my new book.
You're not going to use a boolean formula to determine when to change the group name. Instead, on the Change Group Options dialog box, select the option Use Formula as Group Name and enter that formula in there.
The formula you create will look at a field in the current row (most likely the group id) and then return then new data that is the group name you want to display. You can use a Select Case statement, a calculation of some sort, or whatever. So this formula is always used to display the new group name and the group id field will never be displayed.
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>
Joined: 10 Oct 2007
Location: United States
Online Status: Offline
Posts: 4
Posted: 16 Oct 2007 at 1:19pm
The customize group name option is not working.I used a select case statement formula.It doesn't see the group( is one of dave44 or john242,etc.)displayed in preview.Only an "a" that is in the default clause string is displayed for each???Not the name I want them changed to.Formula icon shows Conditional formatting has been applied.
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
IP Logged
