I have relational data in State & City format. Using reports parameters I see these issues.
(1) I can not have parameter having "ALL" in state parameter as selection and based on that cities selected automatically.. if any coding needed I dont know and not interested.
(2) I can not have only single State selection as I must select filtered city or cities to send it to report filter to get data only for the city.. I do not want customer to select multiple states.. as of no use in my case
so here is what I am looking..
By default report launch will ALL data
(1) one parameter for state (combo box) where single selection will be done and based on it applied filter will work on the report data
(2) have two parameters for state (single selection combo box) and City (single selection combo box)..based on selected state.. all cities will be listed and user chooses single city and that will work on different filter ..
is this possible at all? I mean independent parameters working on report data using independent filters?