Multiple Parameter values

[radhak]

Kathleen,____Does R&R allow multiple entries in Parameter selection? Or is there a drop down menu from which one can select the codes wanted to included in the report?____Eg: Customer Type a, b, c, d, e____In the parameter, I would like to select a and d on one instance and generate a report. On another instance I want to select b only and on another instance I want to select all. ____Parameter field - Param1 default value "*" (All)____How do I form the query which will satisfy all the above mentioned selections?____At present I am having ctype is equal to Param1 ____this query satisfies the ALL selection and individual selection.____Would appreciate your immediate response.____Regards__

[kfleming]

You cannot create a drop down select list but you can create a validation rule that would limit the entries that can be made.____If you want to give users the opportunity to select one or more values or all you could create a validation expression that accepts only a b c d e or an asterisk if the length of the trimmed string is 1 or if the length is longer, then enforces that there must be a comma between entries. Or you could skip the validation altogether.____The second step would be to create a logical calculated field that does your selection criteria. ____I will create a small example report that shows how this might work and will email it to you later today.______Kathleen__R&R Support

[radhak]

Kathleen,____Thanks. I will test it out when I get into the office tomorrow.____After writing reports in Crystal, I am trying to do the same things with R&R. But, it seems that I am getting into problems here.____I am sure you can help me to get the reports running without any issues.____Thanks once again.____Regards__

[radhak]

Kathleen,____Thanks for the e-mail and the report. your report works perfectly. But, when I replicatre your way of doing it I end up selecting everything in my report instead of the required codes.____I think, I may have left out something from my report.____I have two databases. One has oders and the other has the customer info.____I select from the orders file all order number which fall on a specific date and within each selected order record, I select the corresponding customer record from the customer database and check to see whether the customer type is equal to one of the specified type as indicated through the parameter. This where the problem comes up.____Your example has only one database and all selections are done based on the same record. Here I have two databases and one selection is done on the main database and the other selection is done based on the corresponding record from the customer database.____How do I get the selection done?____I would like to see it working the way your sample program works.____Would appreciate if you could help me.____Thanks and Regards__ __>You cannot create a drop down select list but you can create __>a validation rule that would limit the entries that can be __>made. __>__>If you want to give users the opportunity to select one or __>more values or all you could create a validation expression __>that accepts only a b c d e or an asterisk if the length of __>the trimmed string is 1 or if the length is longer, then __>enforces that there must be a comma between entries. Or you __>could skip the validation altogether. __>__>The second step would be to create a logical calculated __>field that does your selection criteria. __>__>I will create a small example report that shows how this __>might work and will email it to you later today. __>__>__>Kathleen __>R&R Support __

[kfleming]

Email your report file to me and I will have a look.____Kathleen__R&R Support__kfleming@livewarepub.com

[radhak]

Thanks Kathleen.____I will e-mail it to you when I get into the office tomorrow morning.____Regards__