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?
See some examples of joining and parsing the data here:
http://www.r-tag.com/Pages/MultivalueParametersWithSQLSP.aspx
At the very bottom are the samples for Crystal Reports