Post reply

Calculations using partial rows data and displaying the calculations in the middle of a report

  • January 31, 2018 at 10:48 am

    #326767

    Hi,
    I need to take some selected rows and do the calculation and display in the report.
    For example: I need to display my 5th row as sum of 3rd and 4th, display 10th row as difference of 9th row and 5th row etc. The Serial/row numbers are there in the dataset and my display row numbers are rigid.
    So I cannot add calculation in the design view.
    Are there any builtin functions that can help? or any other thoughts?

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • January 31, 2018 at 11:02 am

    #1978066

    Unless you can group your data somehow, I don't think so. What you're describing is Excel, not SSRS.

  • January 31, 2018 at 1:16 pm

    #1978088

    pietlinden - Wednesday, January 31, 2018 11:02 AM

    Unless you can group your data somehow, I don't think so. What you're describing is Excel, not SSRS.

    yes, it is like excel kind of requirement. I am just thinking if Lookup function can be used to get data based on row numbers in the dataset.

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply