Recently I am working little bit more on SSRS. Last week, we migrated from SSRS 2005 to SSRS 2008. The migration was smooth except few gotchas in Line charts. The way we handle empty points (null values) is improved. for more information, look at: http://msdn.microsoft.com/e... http://msdn.microsoft.com/e... ------- Coming to some tips regarding formatting date time, text etc. 1) How do you persist the date format when you export the report to Excel?...

Consider you have a SQL Server Table with some multiline text data. And that data contains carriage return in it. Now, if you want to display that data with carriage return in SSRS 2005 textbox, there is no direct way to display it. Because SSRS 2005 uses VB engine to render the data, where it doesn’t understand line feed-->CHR(10) or Carriage Return -->CHR(13) characters. So, what is the alternative? Well, simple we need to use the Replace() function available and replace the specific characters...