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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics