Groups | Blog | Home
all groups > sql server reporting services > march 2005 >

sql server reporting services : How can I stop the designer changing sql layout?


Stan
3/25/2005 11:49:34 AM
It is annoying - I make nicely formatted query in Query Analyzer, paste it
into reporting services designer, switch to data view, come back - designer
reformats the query.

Can I turned this off?

Thanks,

-Stan

Robert Bruckner [MSFT]
3/25/2005 2:12:27 PM
Just use the generic text-based query designer. It will never reformat the
query.


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Stan
3/25/2005 2:21:59 PM
I just found out that there is Generic Query Designer that seems does not
change the layout...

[quoted text, click to view]

Usenet User
3/25/2005 7:05:19 PM
[quoted text, click to view]

You can't. When you're in the Data view, the designer re-generates
the code by using its query object model. As the result, you get
AddThis Social Bookmark Button