Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Displaying Multiple Values in Parameter Fields Post Reply Post New Topic
Author Message
mwahid
Newbie
Newbie
Avatar

Joined: 05 Mar 2007
Location: United States
Online Status: Offline
Posts: 8
Quote mwahid Replybullet Topic: Displaying Multiple Values in Parameter Fields
    Posted: 17 Mar 2007 at 10:08am
Hi,
I have a report that uses a parameter (Cascase LOV with part_no field as multivalued entry).  My record selection formula is
{DEFECT_CODE_DETAILS_VIEW.PART_NO} = {?PartNo}.
I also have a report header that shows the value of the parameter.  As many of you know if I just put the parameter like {?PartNo} and if I select two parts from LOV for my report, I will only show the first part in report header.  I need a formula to show all the parts in report header and have to have enough space to display it. I read that I have to have a formula that uses an array.  However, I do not know the full syntax of the formula.  I would highly appreciate someone writing th exact formula for me if I select two parts from drop down menu during report execution.
Thanks in advace for all of your help.
MW
MW
IP IP Logged
mwahid
Newbie
Newbie
Avatar

Joined: 05 Mar 2007
Location: United States
Online Status: Offline
Posts: 8
Quote mwahid Replybullet Posted: 18 Mar 2007 at 6:01pm
I figured out a way by defining an array string variable and contatenating the first few elements of the array in a formula. It works well. If anyone has a different approach let me know.
 
I actually have a different issue with record selection based on the part number user picks from pick list.  When a user picks more than 4 part, I want to limit the sub report linked to main report only use first 4 of the part numbers.  I tried using Redim function.  Even though my selection formula in sub report does not have any syntax error, I do not seem to get any results.
 
I would appreciate any help you can provide.
 
Thanks,
MW
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.031 seconds.