Ssrs table & sum iif issue

[akulka58]

Hi All,

I am new to SSRS. I am facing 2 issues.

Issue No 1 – I have created 1 table/. Please refer below image.

Cost Of Tax.PNG

Where I manually typed cost of tax. But when I am previewing report it’s come in all rows. Please refer below image.

Preview Issue.PNG

I do not need Cost of Tax in all rows I need it only in one row. How can I do this?

Issue No 2 – I have created expression right to Cost of tax. Below is the function.

=sum(iif(Fields!RevisionNumber.value = 2,Fields!Status.value = 3,Fields!ShipMethodID.value = 4,Fields!TaxAmt,0)

The function is not working properly. Please guide me.

The final output in report should be like below image.

Final.PNG

[roscin]

Hi,
Issue one - if you one only one line of Cost of tax ant to be static, you have to put it in the header. In fact, this is the way to make static table. You can pus as many as you want header line. But s long as you have the line where is the data, you will see many lines (as many as they are in the result of your dataset). If you don't want to see them, delete the line.

Issue No 2
=sum(iif(Fields!RevisionNumber.value = 2 and Fields!Status.value = 3 and Fields!ShipMethodID.value = 4,Fields!TaxAmt,0))

in your iif you have (condition, true, false)
if you need more than one condition you have to add and/or between them.
Also you have open ( with sum and second ( with iif but closed only once.

Good luck