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