combine multiple values into one new name
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17968
Printed Date: 05 May 2024 at 7:21am
Topic: combine multiple values into one new name
Posted By: dandanearl
Subject: combine multiple values into one new name
Date Posted: 08 Nov 2012 at 4:26pm
I'm looking for some assistance in combining multiple values to display with a new name of my choosing.
for example:
Values are
MC - test
MC - release
MC - Production
and i want to display this group as "Main Campus".
This is only my second week using Crystal and appreciate any pointers!
|
Replies:
Posted By: shanth
Date Posted: 09 Nov 2012 at 2:46am
When you said, combining multiple value, means do you like to concatenate multiple fields to show as one field/column?
What do you mean by group here? Please explain a bit more..
|
Posted By: dandanearl
Date Posted: 09 Nov 2012 at 3:24am
|
Let me rephrase. I would like to group everything that starts with "MC" into a single group named "Main Campus". I am looking to do a total count by campus instead of per workstation location.
|
Posted By: shanth
Date Posted: 09 Nov 2012 at 4:55am
Report -> GroupExpert-> Add Field which you wanted to Group->Options-> Options Right Tab->Check Customize group name Field-> check Radio Button (Use Formula as Group Name)->Click [X-2] ->Write formula similar to:
IF {field} STARTSWITH "MC" THEN 'Main Campus' ELSE {field}
Then Count accordingly.
If this is not the case, you have to create a formula similar to the above and group by on that formula and count Group By.
|
|