Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Printing a multi range parameter Post Reply Post New Topic
Author Message
cfrey
Groupie
Groupie


Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 55
Quote cfrey Replybullet Topic: Printing a multi range parameter
    Posted: 03 Jul 2008 at 8:31am
I have a parameter with multi ranges that I would like to print in the title

the parameter is a number range : 123444 to 123999 or 555777 to 555888;

JOIN({?SIC RANGE}, ", ") errors with "A String array is required". But if I change it Totext it errors with "A number, currency amount , boolean, date, time, date-time, or string is required here."

Thanks for your help.

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: 04 Jul 2008 at 12:59am
Hi ,
 
Use the following
 
 Minimum ( {?No_Parameter} ) & ' to ' & Maximum ( {?No_Parameter} )
 
if you want to use ToText you can use following
 
totext (Minimum ( {?No_Parameter} )) + '  ' +
totext(Maximum ( {?No_Parameter} ))
 
 
Cheers
Rahul
IP IP Logged
cfrey
Groupie
Groupie


Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 55
Quote cfrey Replybullet Posted: 07 Jul 2008 at 9:13am
Hi Rahul,

Thanks for your reply but I need it to print all of the ranges.
My parameter looks like this:

504500-504599;
573400-573499;
737100-737102;
737303-737304;
737600-739999;
357100-357999;

Your code prints this:
357,100.00 to 739,999.00

I need to show each of the ranges. I would think a combination of Minimum/maximum and join would work but I haven't been successful yet.

Thanks.
IP IP Logged
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.