asked
Optional Parameter in SSRS query is in oracle
I have a report in SSRS whose source is Oracle query. I want optional parameters in my report. For eg-Suppose i have 3 parameters like Area,Branch Code and Product Code. All 3 should be multivalue parameter. If i select a value from Area parameter dropdown and rest parameters are not selected i should get the records for that. Also,i have a main dataset which is having all the values from the oracle table and each parameter dataset from where the parameter is picking the data and selection How this can be achieved in SSRS.I dont have any stored
proc.So dont suggest it. my issue is that when the selection of one parameter should not depend on another..for eg if I want to display report for area south Asia then it should not say to select product prompt also in case there is no default value for product...
You will need to set the default value on the params to include all the values you want to be returned. If you do this then the user can just un-tick the ones they do not want. It would be bad practice to assume that all should be returned if nothing is selected, what if the user doesn’t want that behaviour?
15 People are following this question.
