Skip to Content

I am trying to show/compare information from two different date ranges.

I am trying to create a report that allows me to compare customer sales between 2 user defined date ranges. I think I need to use a subreport to accomplish this but I am not sure. Any assistance would be appreciated.

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 12, 2017 at 03:46 PM

    No need for subreport create 4 date parameters

    In Select Expert

    (datefield >= Startdateparam1 and Datefield <= Endadateparam1)

    OR

    (datefield >= Startdateparam12 and Datefield <= Endadateparam2)

    Then create two formula

    @range1

    If (datefield >= Startdateparam1 and Datefield <= Endadateparam1) then valuefield else 0

    Repeat for daterane 2

    These formula can be summarised and compared at either detail or group level

    Ian

    Add comment
    10|10000 characters needed characters exceeded