RDLC format text Red for negative values

by ebarcza 1/26/2012 10:05:00 AM

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")


SSRS Rich Textbox Carriage Return

by rbellantoni 1/24/2012 11:39:00 AM

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



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


=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!


Forms Authentication Doesn't Work in IE

by rbellantoni 1/3/2012 5:22:00 AM

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.


Powered by BlogEngine.NET
Theme by Mads Kristensen

About the author

Name of author Author name
Something about me and what I do.

E-mail me Send mail


<<  September 2022  >>

View posts in large calendar

Recent comments



The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2022

Sign in