How to avoid reload of parameter area in drillthrough report

I have produced a number of financial reports in SQL 2000 Reporting Services that all has drillthrough links to the same child report. The parametes of the parent reports are passed on to the child report. The child report has more parameters than there is passed from each of the parent reports. All parameters in the child report has default value settings.

It works OK when clicking on the drillthrough link. If I expand the parameter box of the child report the parameters has been passed alright (i e, the listboxes has the correct selections).

However, if I select a new value in one of the parameter listboxes the parameter box reloads and all parameters are set to their default settings. Does anyone know if there is a way of avoiding this annoying reload

Best regards,
Lars Seger

Answer this question

How to avoid reload of parameter area in drillthrough report

Adrian Johnson
Are the parameters related That is do they have a dependancy upon one another. If so then you will see the related parameters reset when you change a parameter. If they are not related, I am not sure what might be happening.

-Daniel
Larry Tenny
The parameters are not related. The parameter list in the Navigation tab was however not in the same order as the parameters in the child report.
After rearranging the order of the parameters in the navigation tab to the same order as the in the child report the behaviour has improved. When making a new selection for one of the parameters in the child report the parameter box is reloaded and the report window is emptied, but the other parameter listboxes keep their selections and are not reset to the default. This behaviour is OK.
How to avoid reload of parameter area in drillthrough report

Answer this question