Table of quantities by week-ending date should include weeks with zero 1

[ekl0908]

I am printing a report of quantities by week-ending date, using the ACROSS function. This is the code that prints the report:

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!

 

[jimster06]

Yes there is a way to add 'dummy' rows: it is called the MacGyver Technique. It will do what you need. Go over to the Information Builders' site and search for it.

Note: you may have to be registered to access this info.

 

[jimster06]

FYI-
IB is offering a webinar on this topic on 16 DEC 2010 presented by the renowned Noreen Redden. Check out the Virual User Forum on IB's Web site.