Printing suppressed results

[Kakoivini]

Greetings All,

CR9, Informix procedure, Unix database.

I have a formula that is getting damaged quantities from the same procedure expression as the undamaged quantities This formula is finding the records created in the db that have the hold code of DAMG and selecting the quantity. I am having a problem with the grouping on this field. The only place it will display a footer, however the objects that I need it to line up with for the report are in various headers. Is there anyway to write a formula that will just show the results of the 1st formula so I can leave it in the footer?

This is the formula:

whileprintingrecords;
shared numbervar dmgQty :=
If ({sp_osd.(expression):9}="DAMG") then
(dmgQty + {sp_osd.(expression):7})
else
dmgQty;

Thanks!!

 

[helenv]

Don't you just write a formula referencing the other formula, so if formula 1 is called formula1, write formula2:

{@formula1}

Place formula2 in the headers etc. then surpress formula1 where you don't want to see it in the footer?

 

[Kakoivini]

Tried that-the one in the header came back zero

 

[helenv]

Ah. Where I've used this before is with group sums. Could you group by hold code, then insert a sum of quantity based on that group. The sum will appear in the group footer, which you can surpress. Then if you write a formula, one of the report fields available will be the sum you have created.