SSRS 2008 – How to Total values from an expression

ssrsssrs-2008

I'm trying to figure out how to total values from a calculated field.

In the example below, I have the following expression:

=IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100,
Fields!actualwork.Value * 77)

Now I want to provide a total, but it doesn't show up on the report. Is there something I'm missing?

Best Answer

You actually just put a SUM around the outside:

=Sum(IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100,
Fields!actualwork.Value * 77))

It will evaluate that row by row and will provide the correct sum.

Related Solutions

Sql-server – SSRS Merge Data Across 2 Group Values

It is a bit kludgey, but here's an idea sketch... instead of merging the cells, could you fake it by placing an A in the left cell aligned to the right and a D in the right cell aligned to the left? You could then use expressions to control value, alignment, color, and borders of the two separate cells.

Let me know if you need more details. I think this would give you the visual you want. Good luck!

SSRS calculated field strange behavior

It is because it may not have a value at that pariticular field/place so first replace the value providing box with:

iif(IsNothing(sum(field)),"0",(sum(field))

Then replace row summary field with the below expression:

=iif(cInt(ReportItems!textbox1name.value)=0,100,(ReportItems!textbox2.value/iif(cInt(ReportItems!textbox1name.value)=0,100,ReportItems!textbox1name.value)*100))

Best Answer

Related Solutions

Sql-server – SSRS Merge Data Across 2 Group Values

SSRS calculated field strange behavior

Related Question