Saving of the report removes all of the new line characters from SqlCommand element

ekomisarenko · Post by **ekomisarenko** » Tue Sep 22, 2009 1:33 am

Hi there,
Saving of the report from Designer removes all of the new line characters from the SqlCommand element inside DataSource and in the most of the cases breaks the report down after opening it afterwards :dumb:. As a workaround all of the line breaks must be accompanied with space or tab character which is not obvious and leads to occasional problems. When you maintain a bunch of reports with 2-4 data sources inside it is crucial to have readable queries, but because of Designer it becomes impossible.

We strongly advice do not modify the content of the SqlCommand element and save it as it was before opening in the Designer. Can you fix that? Thanks.

Regards,
Eugene

Post by **Andrew** » Tue Sep 22, 2009 7:51 am

Hello,

We are unable to reproduce the error. All line breaks in Query Text are saved and loaded with the Web designer without errors and problems, including empty line breaks. Could you please sne us the sample of the SQL query that is not working to support@stimulsoft.com. What version of the product do you use? What is the OS and browsers version? (most ptrobably the error occurs due to incorrect encoding).

thank you.