case in reporting services
Greetings, Is it
possible in reporting services add a case statement
in the window that show?
here
At the moment I have the sentence
so
= "Month" + "" + Cstr (Parameters!
mes.Value) + "" + "Quantity" +
"" + Cstr (Sum (Fields!
acum.Value))
But, this data shows me
so Month 8 Number 1100
what I want is to see well.
Month August Amount 1100
I hope I was clear and you can help.
thanks
August 4th, 2011 11:11am
Try:
[Code
="Month" + ""+ DateName(Month, (Parameters!mes.Value)+ ""+ "Quantity + "" + Cstr(Sum(Fields!acum.Value))
/Code]
Margaret
Margaret Norkett Database Administrator Commercial Foodservice Repair
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2011 11:22am
Augusto,
Try using this:
= "Month " &
MonthName(Parameters!mes.Value) &
" Quantity " & Cstr(Sum (Fields!
acum.Value))
Hope it helps!
Regards
Manoj
August 4th, 2011 12:54pm
thank you both
finally...
="Month" + " "+ MonthName(Fields!mes.Value)+ " "+ "Quantity" + " " + Cstr(Sum(Fields!acum.Value))
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2011 1:06pm