Skip to main content

Posts

Showing posts from 2012

SSRS Format Strings in BIDS

I used to capture results in an conditional statement to clean up reports.  It is still useful, when you want hide conditional statements. =IIf(<expr> = 0, "",  <expr>   ) However, I was considering the option numeric values have, to hide 0 values.  Which is:  0;(0);'' Now to hide the percentage format, use this:  0.0%;(0.0%);''