Hi, I know that you can't create a multi value paramter in the Crystal Command, but is there a way where you can pass the result of a parameter selection
EG create those parameters in Crystal not in Command and create a result formula similar to Join{?param}',') to create a string to use in an IN clause in the SQL.
I had to replace my standard table join way, with a select statement in SQL due to poor report performance, and now I have parameter issues.
I had a look at this FAQ ( but It requires the Main report to house the parameters and pass to a Subreport where all the report action happened. I cant do that as I need a drill-down level below this.
Also, I need the option of Dynamic Cascading parameters aswell, with the 'All' option included.
I am using Crystal 2016 on a SQL Database.
Any help would be greatly appreciated.
Thanks
BeeBear
EG create those parameters in Crystal not in Command and create a result formula similar to Join{?param}',') to create a string to use in an IN clause in the SQL.
I had to replace my standard table join way, with a select statement in SQL due to poor report performance, and now I have parameter issues.
I had a look at this FAQ ( but It requires the Main report to house the parameters and pass to a Subreport where all the report action happened. I cant do that as I need a drill-down level below this.
Also, I need the option of Dynamic Cascading parameters aswell, with the 'All' option included.
I am using Crystal 2016 on a SQL Database.
Any help would be greatly appreciated.
Thanks
BeeBear