Skip to Content
avatar image
Former Member

How do I insert data from a field using 2 different date parameters

Jun 14, 2017 at 10:29 PM | 26 Views | Last edit Jun 14, 2017 at 10:29 PM 2 rev.

Example..

I want to have for example product (Bronidox 1160) display data for 1/1/16-6/30/16 and also data for 1/1/17-6/30/17.

capture.png (5.5 kB)
SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Ian Waterman
    Jun 16, 2017 at 08:13 AM

    Create two formula

    @Range1

    If datefield >= 1/1/17-6 and datefield <= 6/30/17-6 then valuefield else 0

    Repeat for other date range and place in details and suppress detail section,

    Group by product and then you can then perform summaries on these two formula as required.

    Ian

    Add comment
    10|10000 characters needed characters exceeded