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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie Help !!!

Status
Not open for further replies.

ferozy

Programmer
Feb 25, 2003
20
FJ
Hi,

In my form I have 3 options which ever option is chosen it opens that report.

Now e.g the 3 options shows reports:

1) Employee details

2) By Department

3) By Position Title

Now I want to add 2 more option separately.


a) Show Actual Pay b) Show Calculated Pay


So if I select 1) and a) then it should show me Employee details with the Actual Pay.

and so on.

I dont want to create dif reports for each combination.

How can I on my 3 Reports hide and show when a) or/and b) are checked (The Heading and the Details).

That is, on Report 1) if option a) and / or b) are checked than show this or else keep them hidden.

Help me.

Regards.

 
You can do this by conditionally suppressing the fields for Actual and Calculated pay.

I'm assuming you have set uup a parameter with defaults for choosing Actual, Calculated, or
Both

Right click on the field and choose Format. Click the conditional (x-2) button for Suppress. Use the following formula when setting up the Calcuated Pay field:

if {?pay_type}="Calculated" then false else
if {?pay_type}="Both" then false else true Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top