Skip to Content
0

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

Jul 12, 2017 at 12:48 PM

19

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Jul 12, 2017 at 03:46 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded