WebJun 1, 2024 · 1. In your parameter field, check Allow Multiple Values. The field is now an array. (NOTE: to allow user to type in characters that cause the drop down list to scroll, … WebOct 16, 2013 · Please ensure that Allow Multiple Values if false". Basically, I would like to pass multiple selected company names from the crystal report in a comma separated value list to the procedure. Can someone, please let me know what are the possible solutions to overcome this problem. thanks, Sathish Find us on Privacy Terms of Use …
Multiple, Discrete and Range Values - Crystal Reports book
WebWhen creating a report based on a paramaterize stored procedure, Crystal Reports will automatically generate a discrete value parameter of the same data type, but it will not … WebJun 23, 2024 · So i have a parameter that is a string that I want to allow the user to enter multiple values (i.e. 1, 12, 15) but when I call the parameter in my Selection Formulas > Report section with an if statement it returns 1, 2, 12, 15, 5) it seems crystal is ignoring the comma and picking every possible number. Here is my if statement. chisago co sheriff facebook
Crystal Reports Parameter with multiple values
WebMar 27, 2003 · Create a main report with your parameter as you have it and allow them to select multiples. Create a formula @JoinedParams join ( {?Parameter},",") This makes the string you are wanting to send. Place what is now your main report as a subreport into the new main report .. (You can get rid of the parameter in it) WebFeb 16, 2016 · 4. Choose/highlight the field from the database that you want the report to use to select records (using primary keys is the fastest method). You may click Browse to view the first 500 entries in that field. Click OK. Usually you want to keep "Discrete Values" checked and "Allow multiple values" unchecked. 5. Click "Set Default Values". WebJan 12, 2024 · First make sure your Crystal Parameter accepts multiple values. For the example below, the parameter is {?Site}. In the record selection formula, enter the following text . {SALES_PART\.CONTRACT} = Split ( {?Site} [1],",") 3. Save the report and place in your Crystal runtime. 4. chisago co sheriff twitter