Crystal reports 2011 - passing mult-select parameter values to subreport
I have a report where the amount of data that's being return is enomorous when the user chooses to bring back all personnel and their training for their department.
We have a multi select prompt which allows the user to select the training that they wish to display on the report. This filter is done in Crystal in selection record formula.
I would like to pass the selected multiple titles to a subreport and have the query bring back only records that match the titles that were selected.
Main report - have only the multi-select parameter.
Sub report - select from datasource where title_id = multi-select title_id
Can this be done?
We have a multi select prompt which allows the user to select the training that they wish to display on the report. This filter is done in Crystal in selection record formula.
I would like to pass the selected multiple titles to a subreport and have the query bring back only records that match the titles that were selected.
Main report - have only the multi-select parameter.
Sub report - select from datasource where title_id = multi-select title_id
Can this be done?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
On the server side, we're filtering by department and returning all training records for that department.
On the client side is where the user will apply the filter to bring back the training records out of that department they wish to view.
I thought by passing the multi-select values to the query command of the subreport would force the server to filter out the selected training records. But now, I see this is not possible unless I pass the the values to a stored procedure. By using that method I have a limit as to the side of the string that can be passed to ORACLE varchar2 field.
On the client side is where the user will apply the filter to bring back the training records out of that department they wish to view.
I thought by passing the multi-select values to the query command of the subreport would force the server to filter out the selected training records. But now, I see this is not possible unless I pass the the values to a stored procedure. By using that method I have a limit as to the side of the string that can be passed to ORACLE varchar2 field.
What about CLOB ?
ASKER
I will check with the ORACLE experts to see if this can be done.
I haven't used the more recent versions of CR, but I think I read that some of them support using a multi-value parameter with a CR Command (CR presumably replaces the parameter with a separate test for each value in the parameter). Even if that's true, it may not work with Oracle, but it might be worth looking into.
James
James
Is there a reason for doing this as a subreport?
mlmcc