Hiding blank space on reports.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a report that summarizes the number of physician
contracts I receive each month by region and county. I want a report that
looks like this:

Region 1:
County A: (total)
County B: (total)
County C: (total)
Region Total: (sum of above)

What I do NOT want is a report that looks like this (which is what I am
getting):

Region 1:
County A:
..
..
..
County A:
Total

County B:
..
..
..
County B:
Total

County C:
..
..
..
County C:
Total

How can get the NUMBER of records from each county without LISTING all of
them individually? I tried setting "Hide Duplicates" to "Yes" but that only
left me with 1 heading for each county and then pages of blank space below (I
assume the hidden records). How do I get rid of these hidden records without
messing up my =Count(*) function?

Thanks!
 
Hi. If you set the visible property for the detail band to no and for good
measure set the can shrink properties to yes also. That should give you what
you want.
Hope this helps.
Fons
 
I tried that but it didn't work... it only erased the one remaining heading
for each county (blank space didn't budge). Thanks for your help, though!
 
Hi. There must be be something I did not understand correctly.
I assume your report is grouped by Region and than also by County?
Each one of these groupings has a footer set to yes and the region has a
header.
If you place the the region name in hte region header band, than the county
name in the county footer along with the sum, now place the "Region Total:
"in the region footer along with the same count as you used for the region
(you could just copy the same textbox from the county footer.
The detail band you could totally delete or set visible to no and can shrink
to yes.
This should give a report just like I think you described.
Hope this works for you.
Fons
 
Hi. There must be be something I did not understand correctly.
I assume your report is grouped by Region and than also by County?
Each one of these groupings has a footer set to yes and the region has a
header.
If you place the the region name in hte region header band, than the county
name in the county footer along with the sum, now place the "Region Total:
"in the region footer along with the same count as you used for the region
(you could just copy the same textbox from the county footer.
The detail band you could totally delete or set visible to no and can shrink
to yes.
This should give a report just like I think you described.
Hope this works for you.
Fons
 
Hi. There must be be something I did not understand correctly.
I assume your report is grouped by Region and than also by County?
Each one of these groupings has a footer set to yes and the region has a
header.
If you place the the region name in hte region header band, than the county
name in the county footer along with the sum, now place the "Region Total:
"in the region footer along with the same count as you used for the region
(you could just copy the same textbox from the county footer.
The detail band you could totally delete or set visible to no and can shrink
to yes.
This should give a report just like I think you described.
Hope this works for you.
Fons
 
Hi. I must have missed some thing.
Your report should be sorted/gouped by Region (with a header and a footer)
and than by County (with a footer only)
In the region header place a textbox with the region name.
In the County footer place a textbox with the county name, and another
textbox with the sum or count formula.
Now in the Region footer place a text boxt or label with "Region Total:" and
a textbox with the same formula as you placed in the county footer.
This should give you a report as you described.
Hope this helps.
Fons
 
Back
Top