Shrinking Detail Page

  • Thread starter Thread starter Jana
  • Start date Start date
J

Jana

I am making a report which summarizes the following:

Each department has a division underneath it and each
division has several employees holding the same position.

I have made a report that first summarizes the amount of
employees per division and totals the employees per
department. I would like to run the report without the
individual employee information showing in the detail
section, but just the detail portions in both the
department and division sections. I have made all the
fields in the detail section Not Visible but they still
take up space in the report. Is there a way to have it
only print the footer sections and omit the space from the
detail section.

I hope I explained that well enough.

Thanks for any assistance you can provide.

Jana
 
Jana,

In most cases you do not need to place the controls into
the detail section. eg. In the department footer a control
with "=count([employee])" will return the result without
having "[employee]" anywhere on the actual report.
[Employee] MUST be in the report record source (the
query / table the report is based on). Using this premise
you can probably delete the controls from the detail
section and shrink it to a height of zero. If for some
reason you require a control in the detail section set the
controls height property to zero and position it so the
section can still be shrunk.

HTH,

Terry
 
Jana said:
I am making a report which summarizes the following:

Each department has a division underneath it and each
division has several employees holding the same position.

I have made a report that first summarizes the amount of
employees per division and totals the employees per
department. I would like to run the report without the
individual employee information showing in the detail
section, but just the detail portions in both the
department and division sections. I have made all the
fields in the detail section Not Visible but they still
take up space in the report. Is there a way to have it
only print the footer sections and omit the space from the
detail section.
Click to expand...


A quick and dirty way to do that is to add a text box named
txtShow to the report header section and set its control
source to something like [Show Employees Y/N]. Then, in the
report header section's Format event, add a little code:

Me.Section(0).Visible = (txtShow = "Y")

A better way is to use a form to open the report. Add an
option button named optShow to the form and a button to open
the report. In this scenario, leave out the text box in the
report header and the code would be:

Me.Section(0).Visible = (Forms!theform.chkShow <> False)
 
Back
Top