August 1, 2010 at 6:41 pm
I have an SSRS 2005 report that has cascading parameters. The report has two parameters. The first is a company and the second is a plant number. When something is selected in the company parameter it is cascaded to the plant parameter to only show plants that belong to the company selected.
But there are times when the plant parameter does not get reset correctly. So I wanted to write some custom code to either select all the plants or un-select them.
Take this scenario: When the report initially runs, all companies and all plants are selected. If I then only select a few companies it in turn only selects the few plants that go with the selected companies. So far so good.
But if I then go back and select all companies, it populates the plant drop down with all associated plants but only the same plants they were previously selected are selected. In this case I wanted all plants to be selected again. So basically i wanted to write a section of custom code to go through the plants and select them all. But in order to do so I need to know when the company parameter has been changed.
So I was thinking is there an event I can check for to see if something has been selected in the company drop down to know then to go manuipulate the plant drop down? Or am I missing something and there is an easier way to do this?
Thanks for any help or ideas
August 2, 2010 at 6:53 am
After thinking about this and trying different things this is the path I am going down. When the Companies are loaded, instead of cascading into the Plant parameter that is on the screen, I load it into an internal plant parm. The actual plant parm on the screen references the internal plant parm.
Now I am going to try to write some code to pass that list in and select everything. Can I select and unselect in embedded code??
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply