If you need to change the color of negative values in an RDLC textbox, use the following expression in the color property

=iif(Fields!base.Value < 0, "Red", "Black")

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 with VbCrLf

ex:

=Replace(First(Fields!YourField.Value, "DataSource"),CHR(10),VbCrLf) –>This worked for me.

or

=Replace(First(Fields!YourField.Value, "DataSource"),CHR(13),VbCrLf)

In my case, The user was entering the data into SQL Server Database from an InfoPath form and wanted the carriage return to be persisted in the report. And in this case, CHR(10) worked instead of CHR(13).

Good to see SSRS 2008 added lot of rich text functionality, where you don't have to deal with these kind of silly things..,

Happy Reporting!

In issue that we recently resolved and much trouble. Was that user's were able to login properly to the website using firefox and other browsers, but were not able to log in using any version of Internet Explorer. It just kept booting them back to the login screen. After verifying that it was indeed the forms authentication ticket causing the issue, we finally tracked down the problem. The problem actually the server date time causing the expiration date to be incorrect on the cookie. It seems that for some reason mozilla still logs in fine, but not IE. After fixing the server time it worked fine.