Print Page | Close Window

data groups

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=1486
Printed Date: 01 May 2024 at 12:33pm


Topic: data groups
Posted By: banjobill
Subject: data groups
Date Posted: 10 Oct 2007 at 10:46am
Data is sorted by company ie. 10,20,40,50
 
The numbers correspond to company names,
Is there a way to to change the data labels from a number to a more legible corresponding company name?


Replies:
Posted By: BrianBischof
Date Posted: 10 Oct 2007 at 11:32am
Do you have a table that lists a company name for each company number? If so, then you can link on that table and display the company name field instead of the company number field.

If you don't have such a table, you can create a formula that uses a SELECT CASE statement to return the company name for each company number. Then display that formula field instead of the company number field.


-------------
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>


Print Page | Close Window