Results 1 to 2 of 2

Thread: Ssrs table & sum iif issue

  1. #1
    Join Date
    Mar 2014
    Posts
    2

    Post 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.

    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

  2. #2
    Join Date
    Dec 2014
    Location
    Paris
    Posts
    7
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •