Print Page | Close Window

Dynamic Name lable

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=16283
Printed Date: 26 Apr 2024 at 8:30pm


Topic: Dynamic Name lable
Posted By: 9south
Subject: Dynamic Name lable
Date Posted: 25 Apr 2012 at 5:48am
Hi, I have a request to make a conditional or dynamic label
How to i do that, what would the formula look like.
On one report the mane will change based on multiple fields in the report
The second request is to reflect the date range selected in the title.

Thanks in advance


Replies:
Posted By: lockwelle
Date Posted: 27 Apr 2012 at 7:14am
your formula would something like:
 
if {table.field} = something then
"xxxx"
else if {table.field} = somethingElse then
 "yyyy"
 
 
Crystal reports will display the last string 'displayed' in a formula. You can contenate / convert / do what you want.
 
your 2nd request would be something like:
totext({?start}, "MM/dd/yyyy") + " - " + totext ({?end}, "MM/dd/yyyy")
 
HTH


Print Page | Close Window