Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Record Selection Formula Post Reply Post New Topic
Author Message
Bayshark_1
Newbie
Newbie
Avatar

Joined: 03 Dec 2008
Location: United States
Online Status: Offline
Posts: 2
Quote Bayshark_1 Replybullet Topic: Record Selection Formula
     Posted: 03 Dec 2008 at 10:44am
Crystal Novice here,
Using Crystal Reports 10, have created a report and want to alter the record selection formula to add a text message if no value is found.
 
The current formula is:
{Change_Request.Start Date} = CurrentDate-1
 
In the report this returns Change Requests from the previous day, however if there are no Change Requests from the previous day a blank filed is displayed.I want to add to this formula to return a text meassage if this is the case.
I tried some if thens and isnull but havn't stumbled across the right solution.
Any ideas?
Thanks!
Bayshark
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 03 Dec 2008 at 11:36am
Hi
 
Do you have any other fields in the report, you can create formula and  check for
 
if isnull(count({Table.FileName})) then
"No Records"
 
Then place the formula in details section once done right click the formula format field select common tab click x+2 against suppress and enter the code below
 
not(isnull(count({Table.fieldname})))
 
cheers
Rahul
IP IP Logged
Bayshark_1
Newbie
Newbie
Avatar

Joined: 03 Dec 2008
Location: United States
Online Status: Offline
Posts: 2
Quote Bayshark_1 Replybullet Posted: 03 Dec 2008 at 7:24pm
Rahul,
Thanks, worked perfectly!
Nick
Bayshark
IP IP Logged
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