Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Format Properties not Exporting to Excel

Author  Topic  Lujako Starting Member 1 Post Posted - 2006-06-08 : 12:12:08 Hello, My report has a "name" textbox which has its Color and Underline properties set using the following code: <TextDecoration>=iif(Fields!changed.Value,"None","Underline")</TextDecoration> <TextAlign>Left</TextAlign> <Color>=iif(Fields!changed.Value,"Black","Red")</Color> The value of the field "changed" is returned from the DB as either "true" or "false". The report along with colors and underline properties are rendered properly when viewing from Reporting services. When exported to Excel, the data is properly exported but the format on the "name" textbox is not. Any suggestions on how force the format to export to Excel? Background: Using Reporting Services 2000 SP2, SQL Server 2000 SP4, Microsoft Excel SP2. Reporting Services SP2 and SQL server SP4 where applied about 2 weeks ago, prior to applying the SP's the report rendered to Excel correctly. Thank you for your time and help! Bradley