March 3, 2011 at 1:35 pm
Hi every one,
Here is my issue.
I need to selectively BOLD the result set data from a stored procedure.
Here is the End column looking like
C1 C2 C3 C4
1 2 34 23
2 3 1 22
3 45 6 26
Total 50 35 69
all the above data is retrived from astored procedure including the totals.
But i need to bold the entire last ROW which is having the totals
Please help me.
March 4, 2011 at 7:57 am
If I understand correctly the word Total and the data on that row are returned from your SP.
You need an expression in the Textbox properties dialog Font tab. For the sake of the example lets say the data in your first column from your result is named FirstColumn. Your bold expression would be something like
=IIF(Fields!FirstColumn.Value = "Total","Bold","Default")
Each column would have pretty much the same formula for the bold (FontWeight) property.
Generally speaking however, I would leave totals calculations to the report.
March 8, 2011 at 2:46 am
I agree, if you add a Group Total Row in SSRS you can easily make that one bold. Also, you should avoid hard coding field values into your report as maybe one day someone decides to change 'Total' into 'Grand Total'.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply