Drill through parameters

[TheDarkKnight]

Hello Experts,
Is there a way to replace the drill through parameter in all the links in a report in a single GO?  8) ...just a bit curious!

i have a bit complex report with over 200 drill through links. need to make a common change in one of the parameter passed in all the links.

Besides manually updating in each link, any single click way to do the same?

Cheers
TDK

[simon.hodgkiss]

Hi,

If you export to xml from report studio does the drill thru parameter get included?  If so you could do a 'find & replace' in a text editor.

Not sure if it works like this - it's just a thought!

Si

[charon]

Hi dark knight,
simon is correct. What you do is open the report in Report Studio, choose in the menu bar "extras" the option "copy to clipboard" and search for you parameter name (e.g. ?pt_year?).
When you are done, just select all from the editor, copy it iinto your clipboard and in Report Studio, in the menu bar click "copy FROM clipboard".
This should work for you.

Good luck :P