Technical Questions: Displaying Multiple Values in Parameter Fields

Displaying Multiple Values in Parameter Fields

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=340
Printed Date: 03 May 2025 at 4:27pm

Topic: Displaying Multiple Values in Parameter Fields

Posted By: mwahid
Subject: Displaying Multiple Values in Parameter Fields
Date 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

Replies:

Posted By: mwahid
Date 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