Hi,
I have a requirement to change an existing report to use a parameter in the following way:
Add two default values to a parameter -
* (for all records) or
"Head Offices Only" for a predefined set of records
By selecting * the report should return details for all offices or for "Head Offices Only" only details for those offices (say there are 4) should be returned.
Ive created a formula to determine which value is selected and create a string for the sql stmt.
ie * - office_id like '*'
'Head Office Only' - office_id in (101,102,103,104)
Is there a way I can dymanically create the sql stmt like this???? If I create the string I cant seem to get the selection formula to add it to the sql stmt being run.
I could make the user select the office_id from a multi select parameter list but they prefer not to do this as it take too much time and they'd have to remember which offices are the ones that fit this category!
Any help would be most appreciated. Please let me know if further explination is required.
jan
I have a requirement to change an existing report to use a parameter in the following way:
Add two default values to a parameter -
* (for all records) or
"Head Offices Only" for a predefined set of records
By selecting * the report should return details for all offices or for "Head Offices Only" only details for those offices (say there are 4) should be returned.
Ive created a formula to determine which value is selected and create a string for the sql stmt.
ie * - office_id like '*'
'Head Office Only' - office_id in (101,102,103,104)
Is there a way I can dymanically create the sql stmt like this???? If I create the string I cant seem to get the selection formula to add it to the sql stmt being run.
I could make the user select the office_id from a multi select parameter list but they prefer not to do this as it take too much time and they'd have to remember which offices are the ones that fit this category!
Any help would be most appreciated. Please let me know if further explination is required.
jan