October 1, 2009 at 11:03 am
I want comma seperated Grand Total.
If i use the following and use ##,### in the format its fine.
=Count(Fields!inci_no.Value,"CTotal")
(Result Ex: 12,458)
But if i use the following statement.... and use ##,### it doesn't work, it gives me the plane number.
="Grand Total : "&Count(Fields!inci_no.Value,"CTotal")
(Result Ex: 12458)
Can anyone help me out please.... Thanks
Sam
October 2, 2009 at 6:10 am
Because you are putting the Text "Grand Total: " in the same textbox as the number the formatting will not apply because it is no longer numeric data the textbox.
You will need to use the Format function around your numeric data like this:
="Grand Total : " & Format(Count(Fields!inci_no.Value,"CTotal"), "##,###")
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 2, 2009 at 9:43 am
Thanks Jack. It worked. I appreciate that...
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply