Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Suppress 10 Groups depending on a Formula

Status
Not open for further replies.

FinnB

Programmer
Jan 6, 2002
17
DK
Hi,
I have a report which has 10 groups.

Report prints Salary Notes for each Employee.
However when 2 Formulas is zero then Suppress the
whole Salary Note for that Employee.

The Formulas in question:
Formula1:
WhilePrintingRecords;
numberVar sumydny;
//Shows the total Salary
Formula2:

WhilePrintingRecords;
numberVar deductny;
//Shows the Total deductable
These Formula is shown at GF 7a
When both are zero then Suppress.
It is OK to suppress from Group 7-10 but
It doesn't work when it is
Group4- Employee
Group5- page 1 or 2
Group6- Controlofdate
__
The reason is that I can't make the result as
Sum(formula1,employee)=0 and sum(formula1,employee)=0
Due to the Numbervar and I'm using Runningtotal with
Previous.

Please come up with some suggestion how to prevent that
Employee's Salary Note not to be printet.

Looking forward
to your help!!
FinnB
 
Hi -k,
Unfortunately I can't provide sample data But if you
can provide me with your e-mail address I can send you
Print screen of the Report with data shown and explaination
of the problem.
FinnB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top