Shrinking Detail Page

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
 
T

Terry

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
 
M

Marshall Barton

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)
 
Top