Hope you can help!

 

I have a report which shows the weight of forecasted product sold per month for a rolling year.

due to the nature of the product many of the lines are empty as we don't expect to sell any of them during this year, but I can't stop it showing all the zeros in the report.

 

the line data is fetched with 

If Date(Year({CASE_VOLUME\\.MSDATE}),Month({CASE_VOLUME\\MSDATE}),1)=date(year(currentdate),month(currentdate),1) THEN ({CASE_VOLUME\\.FORECAST_CASE_QTY})*{INVENTORY_PART\.WEIGHT_NET}

 

this is grouped and displayed by part number and the totals are summed by month.

 

I would like to suppress the whole line if all the sums of the forecast qty sales are zero for every month.

 

i have tried to suppress if Zero, but that just hides the value and not the line.

 

I'm probably missing something obvious!  but any help appreciated.

 

Many Thanks in advance

Gav

 

 

Part_No  Desc   July  Aug  Sep  Oct   Nov ........... for 12 months        totals

401ty    desc      0      0      0      0       0      0    0   0    0                    0

401ut     desc    500   900   0     100   200    0      100 0  50   100        2,300

 

I only want to show the lines that are not all 0's.

 

the formula in the totals field looks like this:

Sum ({@month now},{Case_Volumne\\.Part_no}) +Sum({@month+1,{Case_volume\\.Part_no})..... etc for each of the 12 months

 

Can I make the select on the totals field if it is >0?

 

If I pick this field in the group select and use >0 I get an error that it cant be done and must be evaluated later?

 

 

Many Thanks

 

 

 

 

 

 

re-thinking the way the totals were summed was indeed the key.

 

I could then add it to the group selection formula!

 

Many Thanks for your help!

 

 

there a loads of other reports I can use this re-think on too!!

 

cheers

 

Gav