February 28, 2012 at 2:50 am
Hi,
I am trying to figure out the style for the Formats(Expression ) in a Reporting Services expression.
I can't find where these style format are documented!
Specifically I am trying to format a field that has both numbers and percetange, then I created a field called format and apply all the rules that determine whether a number (n2) or percentage (p2).
I tried the expression below, but it is not working. can someone assist.
=IIF(Fields!Format.Value="P1",format(me.value,"p2"),format(me.value,"n2"))
February 29, 2012 at 2:09 am
What's the error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 29, 2012 at 3:01 am
The report execute successful, but the format is not effective. Actual it views the format as default (original)
February 29, 2012 at 3:10 am
Shouldn't the format string be more like 0.0% for a percentage?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 29, 2012 at 3:37 am
I have tried it, but I didn't work
February 29, 2012 at 3:49 am
So, if I get this correctly, you have a field that indicates what kind of formatting a certain textbox should get.
Put the following expression on the format property of the textbox:
=IFF(Fields!Format.Value="P1","0.00%","0.00")
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 29, 2012 at 5:04 am
Thanks you very much. It works this time.
February 29, 2012 at 5:07 am
pitso.maceke (2/29/2012)
Thanks you very much. It works this time.
Great, glad that you got it working.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply