Forum Discussion
Paginated Reports - Parameters
Hi everyone!
When I run the report to see rendered reports, as you see in the screenshot, only the Category and SubCategory parameters are enabled to write/select and I created all parameters in the same way but the Item key and Item no are not writable fields, what should I do to make them writable as default too?
Thank you very much for the answers in advance!
3 Replies
You probably have setup cascading parameters which means each parameter is dependent on values selected from the previous parameter. So for example, the first parameter values must be selected and only then the second parameter will populate based on the selection from the first.
Check this out for more details - https://www.mssqltips.com/sqlservertip/3466/cascaded-parameters-in-sql-server-reporting-services/
Another reason could be browser compatiblity. Try the below:
- Open Internet Explorer
- Go to Settings->Compatibility View Settings
- Add the URL of your report server.
Thank you very much for your answer Shahfaisal, yes, I guess the reason is cascading parameters, however, there is not any relationship between "category" and "item" parameters, that's why I don't understand why I cannot write anything before giving a category value...
The Category and SubCategory are cascaded within themselves, and the Item key and Item no are also within each other, but there is no relationship between these two groups.
You shoule be able to select/enter values in Item Key if it is not dependent on the previous parameters. From the parameter names, it sounds like all the 4 should be cascaded but I don't know your requirements.
