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

Printing certain pages 1

Status
Not open for further replies.

FB1

Instructor
May 31, 2005
69
GB
Crystal 11
using sql commands

Have a 3 page report

1st page always gets printed
Page 2 only gets printed if Patient = HD
Page 3 an extended page only gets printed if user requires it

1st page is simple
#2nd page will depend on a formular, but what formular do I need to use for printing
#3rd page I take it will depend on a parameter, what formular will I need to use for printing.

Thank you for all your time

Ralph
 
Hi FB1

You could use conditional suppression of all sections based on the patient and parameter. Go to the Section Expert, and for each report section click on the x2 button beside "Suppress" and enter the formula:

// Conditional Suppression Formula
(
(
PageNumber = 2 and
{table.patient} <> 'HD'
)
or
(
PageNumber = 3 and
{?PrintPage3} = 'N'
)
)

where table.patient is the 'Patient' field you refer to and {?PrintPage3} is a new parameter with the option Y or N (or you could use a Boolean parameter of True/False.

Hope this helps.


Cheers
Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top