Want to include areas with no activity on report/graph 1

[MichaelQCL]

I am working on graphing activity per day for all work centers & would like to have the work centers that did not have any activity on that day to show as zero. I am grouping by work center & using the work date for the selecting parameter.

How do I get a work center to show up if there is no data to pull from the table (SQL database)?

 

[lbass]

You would have to eliminate the selection on the date parameter, and instead create a formula like this in the field explorer:

if {table.date} in {?daterange} then {table.amt}

Use the sum of the formula as your summary field, and the work center as your "on change of" field.

-LB

 

[MichaelQCL]

Thanks so much lbass - it worked.