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

suppress section with parameter

Status
Not open for further replies.

codrutza

Technical User
Mar 31, 2002
357
IE
Hi
SQL Server 2000, CRXI
I have a report that has 5 Page Footer sections. In the first I print some fields, and in the 4 sections left I print in each an OLE object. I have a parameter ?Currency, and I have on the first OLE suppress if ?Currency<>”A”, on the second OLE suppress if ?Currency<>”B”, on the third OLE suppress if ?Currency<>”C”, on the fourth OLE suppress if ?Currency<>”D”, and I have on the sections Suppress blank section ; I have tried to put the conditions on the sections, as well.
It’s suppressing the OLE objects, but not the section. It’s going to the second page (letting space where the OLE are).
I tried with text fields instead of OLE objects and it’s the same result.
What do I do wrong?
 
Hi,
When you tried supressing the sections and in addition to the fields/objects, what happened?





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
So, instead of putting the condition on the object, I put it on the object (suppress) and on the section (suppress) and it’s the same, “prints the blanks”.
 
Solve it. I have put the objects all in the same place; I mean on top of each other
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top