Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Displaying Parameter Values on Report Post Reply Post New Topic
Author Message
SATELE01
Newbie
Newbie
Avatar

Joined: 13 Aug 2012
Location: United States
Online Status: Offline
Posts: 24
Quote SATELE01 Replybullet Topic: Displaying Parameter Values on Report
     Posted: 16 Aug 2012 at 7:31am
I've setup a Parameter that allows one to many values to be entered. How can I display the selected values in either the header line or a header section?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Aug 2012 at 8:04am
join(?param,",")
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 16 Aug 2012 at 9:50am
Hi
 
If your parameter consist of only one value then Join() function will give an error.
 
Use the following formula :
 
If count({?Parameter}) > 1 then
Join({Parameter},",") else
{?Parameter}[1]
 
 
 DBlank : Please correct me if I am wrong.


Edited by Sastry - 16 Aug 2012 at 9:51am
Thanks,
Sastry
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Aug 2012 at 10:35am
This may depend on a version but I have never had that problem on version X or XI.
If only one item is entered it will display it without the "," after it
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