Hi
I have been using Crystal Reports for years but only recently started using CR2008. I am reporting against an Oracle 11g database. I have set up a dynamic cascading parameter based on the following:
Region
District
Division
These are set up as optional (if no division is selected then all divisions in the district selected should be used) and multiple values can be selected if required.
Incident records need to be retrieved by matching the Division_ID to the Location_ID on an incident. This is working fine when Division/s is selected but if no Division is selected then the Region/District is not used to retrieve records, all records are returned.
How do I get the selection to be based on Region and/or District if only these are selected? I don't want to set these up as separate parameters as the users only want to see the values associated with the Region/District. Will I have to base the parameters on a command and if so, how do I do this?
Thanks for your help in advance.
I have been using Crystal Reports for years but only recently started using CR2008. I am reporting against an Oracle 11g database. I have set up a dynamic cascading parameter based on the following:
Region
District
Division
These are set up as optional (if no division is selected then all divisions in the district selected should be used) and multiple values can be selected if required.
Incident records need to be retrieved by matching the Division_ID to the Location_ID on an incident. This is working fine when Division/s is selected but if no Division is selected then the Region/District is not used to retrieve records, all records are returned.
How do I get the selection to be based on Region and/or District if only these are selected? I don't want to set these up as separate parameters as the users only want to see the values associated with the Region/District. Will I have to base the parameters on a command and if so, how do I do this?
Thanks for your help in advance.