I am printing a report of quantities by week-ending date, using the ACROSS function. This is the code that prints the report:
This correctly prints the quantities for each week that has non-zero quantities. I am trying to get the report to print all weeks, even weeks with zero quantities.
Is there a way to put "dummy" records into the file with all week-ending dates within a selected range, so that all weeks will print?
Thanks!
Code:
BY STYLE_DESC AS ‘ ‘
ACROSS weekseqn NOPRINT
ACROSS Saturday AS ‘ ‘
ON TABLE SUMMARIZE AS ‘ ‘This correctly prints the quantities for each week that has non-zero quantities. I am trying to get the report to print all weeks, even weeks with zero quantities.
Is there a way to put "dummy" records into the file with all week-ending dates within a selected range, so that all weeks will print?
Thanks!