Post reply

SSRS Evaluating Rows using an expression

  • October 16, 2020 at 2:13 pm

    #3798005

    I have a SSRS report that for a column, I need to calc the time different between the DateTime value in one row with the same column in the previous row to find the greatest interval of a set of rows.

    Is this possible using expressions. Anyone face this challenge?

    Attachments:
    You must be logged in to view attached files.

  • October 16, 2020 at 2:16 pm

    #3798009

    Do you have to do this in SSRS, or can you do it within the source query?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • October 16, 2020 at 2:35 pm

    #3798045

    The source query is limited because I'm OSI PISQLCLIENT which is pretty limited. It doesn't support sub queries or date function.

  • October 16, 2020 at 3:01 pm

    #3798055

    OK. The Previous() function should get you the value of a data item from the previous row, which you can then use to calculate the time difference. I'm not sure whether that is enough to satisfy your requirement.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • October 16, 2020 at 3:04 pm

    #3798060

    I was familiar with Previous() but unsure how I could loop thru and find the time difference between the Previous() and Current and store the greatest time difference.

  • October 16, 2020 at 3:28 pm

    #3798070

    I have not tried this before, but have you experimented with Shared Datasets?

    If you were to create one which included the calculated 'time difference' column, you could then create another dataset based on it.

    Maybe that would give you the ability to get to where you need.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • October 28, 2020 at 7:36 pm

    #3802227

    I've spent time on the SQL Server side developing a view with the data I need but still trying to find a way of using a dataset to query this view per row of my tablix. The query must use the two column field values in the row in the tablix. SSRS seems to block this. Is there any way around this?

  • November 22, 2020 at 6:45 am

    This was removed by the editor as SPAM

  • November 22, 2020 at 6:48 am

    This was removed by the editor as SPAM

Viewing 9 posts - 1 through 8 (of 8 total)

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