SSRS Text Box Properties: 2008

Question

Post reply

SSRS Text Box Properties: 2008

niha.736

Ten Centuries

Points: 1210
More actions
October 29, 2012 at 2:29 am

#284202

Hi , currently in my reports, i have 3 types of columns.
1. sales 989999
2.sales % 98
3.count 400000
here i need to get the values as
if the value is <999999 then it should be like 9999.99, if it is >999999 it should be same.
so what could be the expression for this?
TR
Niharika

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 1

Try something like:

=IIF(Fields!YourField.Value < 99999, FormatPercent(Fields!YourField.Value), CInt(Fields!YourField.Value))

I haven't tried this, so you may need to play around with this. But it should give you a start.

HTH,

Rob

niha.736 Ten Centuries Points: 1210 More actions · Answer 2

Thanks for the reply ,

problem has moved a bit forward , But strucked over a little change

=iif(Cint(ReportItems!Sales38.Value)>99999,ReportItems!Sales38.Value,FormatNumber(CDbl(ReportItems!Sales38.Value),"N2"))

this is the expression i have written. with help of this am getting values with decimal values

like 76585.23 for some rows 89096.2

Problem is: i need to get 2 decimal points after " . "

can anybody suggest something.

Thanks in advance,

Niharika

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 3

niha.736 (10/29/2012)
problem has moved a bit forward , But strucked over a little change
=IIF(CInt(ReportItems!Sales38.Value) > 99999, ReportItems!Sales38.Value, FormatNumber(CDbl(ReportItems!Sales38.Value),"N2"))
this is the expression i have written. with help of this am getting values with decimal values
like 76585.23 for some rows 89096.2
Problem is: i need to get 2 decimal points after " . "
can anybody suggest something.

Would FormatCurrency() work better for you than FormatNumber()?

Or something like:

=Format(Fields!Sales38.Value, "#,##0.00")

Good luck,

Rob