Saving changes in MDX

Hi,

I have written a report in Reporting Services 2005 which gets its data from a cube.

I want to edit the mdx generated by the Mdx builder in RS 2005, so I click on the "design mode" button to do this.

However, when i make the changes, i cannot save it. How can I do this?

Thanks,

Ashleys.

The only time it seems that you can't save the mdx changes are when they are not syntactically correct. Paste the same query into management studio and see if it runs w/o errors (and if you have @.parameters in the query, use actual valuse for them instead).

sql

Saving a report in Report Builder

I used Report Builder to create a report then I saved it. The report does NOT appear in my Shared Reports folder in Report Manager. However, if I go back into Report Builder and hit "open" the report defintion is saved and I can open and run it in Report Builder.

Why can't I run it from Report Manager?

Thanks.

Put another one in the "too stupid to live" file....I was saving it as a model instead of a report....D'OH!

Saving a report built in Report Builder

I have built a report using Report Builder. When I try to save it I get and error,

The name cannot contain any of the following characters: ;?@.&=+$,\*<>|", and cannot consist exclusively of dots or spaces.

The name I am saving is cta. Any ideas?

Hi GTO52,

cta.

Works fine for me. Is there some other character you are using?

|||I do not think so. Did you install anything special on the web server, like front page server extenstions or disable the firewall or open a port in the firewall. Did you just do a vanillla install of reporting services or did you add pieces on afterwards (don't know what these wou ld be)?sql