3 Attachment(s)
Ssrs table & sum iif issue
Hi All,
I am new to SSRS. I am facing 2 issues.
Issue No 1 – I have created 1 table/. Please refer below image.
Attachment 671
Where I manually typed cost of tax. But when I am previewing report it’s come in all rows. Please refer below image.
Attachment 673
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.
Attachment 675