Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Appending a alue to a parameter Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Sep 2012 at 8:25am
use
{Employee_job_History_SCD.Client_ID} = 10981000 in the select statement
make a formula field as
(10000000 + {?Client ID}) = {Employee_job_History_SCD.Client_ID}
place this in the detial section
enter 981000 in the param when prompted
does the formula result show TRUE or FALSE?
 
IP IP Logged
SATELE01
Newbie
Newbie
Avatar

Joined: 13 Aug 2012
Location: United States
Online Status: Offline
Posts: 24
Quote SATELE01 Replybullet Posted: 27 Sep 2012 at 8:36am
The result is TRUE
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Sep 2012 at 9:10am

this means that the formula should work in the select expert

copy it from the formula field and place it in the select expert and try it again
 
 
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.