Modify Report as XML? [SOLVED]

[qvixote]

Hi again!

Is there a way to modify directly the XML to make some changes in a report made with Report Studio?

My question comes because I've changed the cube's name of several reports and all data items references need to be refreshed. Using Report studio, I have to remove them and then relocate them from the new cube tree, losing format and making lot of work again. If I could simply edit the XML, I could find and replace all instances of the cube's old name with new name, since the tree of dimentions haven't changed at all.

Regards.

[MFGF]

Hi again!

Is there a way to modify directly the XML to make some changes in a report made with Report Studio?

My question comes because I've changed the cube's name of several reports and all data items references need to be refreshed. Using Report studio, I have to remove them and then relocate them from the new cube tree, losing format and making lot of work again. If I could simply edit the XML, I could find and replace all instances of the cube's old name with new name, since the tree of dimentions haven't changed at all.

Regards.

Use the following at your own risk... :)

1. Open the report in Report Studio
2. On the menubar, select Tools > Copy report to clipboard
3. Make sure the entire XML report spec is selected, and <ctrl>C to copy
4. Paste into Notepad (or some other text editing tool of choice)
5. Perform your find-and-replace actions
6. Select the entire edited XML spec and copy (<ctrl>C)
7. In Report Studio, from the Menubar select Tools > Open report from clipboard
8. Paste in the XML you copied (<ctrl>V)
9. Test the report and when happy, save, overwriting the original.

MF.

[qvixote]

Thanks, it worked perfect!

I know it's a little risky, but I always work on a copy and make backups.