Multivalue Parameter in Command?
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22402
Printed Date: 29 Apr 2024 at 6:26am
Topic: Multivalue Parameter in Command?
Posted By: XstalPat
Subject: Multivalue Parameter in Command?
Date Posted: 28 Jul 2017 at 3:05am
This issue has gone back since 2007, was this issue ever resolved? I've encountered this issue now in CR XI, is there a workaround?
http://www.tek-tips.com/faqs.cfm?fid=6779 - Multivalue Parameter in Command
Thanks
|
Replies:
Posted By: Sastry
Date Posted: 29 Jul 2017 at 12:33am
Hi
This was addressed in Crystal Reports 2008, while creating parameter it self it will ask you to check a box if the parameter has multi selection.
Work around for this problem is:
Create a blank report, with a parameter (if this is dynamic then select the table else select static values)
Now, insert your report as sub report and link main report parameter to sub report parameter. Then go in command where clause mention some thing like :
{databasefiled} in ({?parameter})
Thanks,
Sastry
-------------
Thanks,
Sastry
|
|