How to make Report controls disappear based off a condition

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Mar 2006
Posts: 194
Reputation: HI2Japan is an unknown quantity at this point 
Solved Threads: 21
HI2Japan HI2Japan is offline Offline
Junior Poster

How to make Report controls disappear based off a condition

 
0
  #1
Oct 21st, 2008
I have a database used for Phone record auditing. I am trying to see whether it is possible to have labels within a section disappear for 1 page but appear for another. I'll explain below.

In the page header, I have it display the customers name and phone number as well as the date range for the billing period. Currently, I also have the labels for the details section also in the page header (this is what I want to disappear for the first page of the phone number group).
I have a group based off the phone number and in that I have a write up that the user needs to sign verifying the phone charges are accurate. I do not need the labels for the detail section to show above this.
Next I have the details section which can span multiple pages. I want to be able to see those labels at the top of all pages.
I have a footer for the phone number which forces a new page after the section. This way the write up that needs a signature in the phone numebr group heading will always appear on a new page thus allowing me to give the report to the customer without them seeing anyone elses info.

So in essence I have many reports within my 1 report, but I did not use any subreports.

So is it possible to make controls not be visible for the first page of my report for the customers? Do I need to use sub reports to make this happen or can it be done programatically? I currently do not do any programming but am willing to learn if someone can point me in the right direction.

Thanks
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the MS Access and FileMaker Pro Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC