Skip to Content
0

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

Jun 14, 2017 at 10:29 PM

23

avatar image
Daniel Ochoa

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
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
Ian Waterman Answered Jun 16, 2017 at 08:13 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users