Saving of the report removes all of the new line characters from SqlCommand element
Posted: 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
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