Report with too much sorting/grouping 1

[ZoomerZ]

Hi again!
I have this Access Report I was suppose to add 5 Sorting Headers/Footers so now it looks like

Executive
Unit
CostCenter
Location
Manager

Is there way to get it all to the same level. It take up so much space and looks dorky.

Thanks

 

[GingerR]

If your data is sorted in that order (Exec, then Unit, then CostCenter, etc) you can put them all on one line in the detail section (get rid of the headers) then use the HIDE DUPLICATES property of each control. It hides the data if the data directly before it is the same, which sounds great but depending on what you have going on, it might not come out exactly as you envision it will. Try it out though, and see how it looks. Maybe a combination of the two (one or two headers, then the rest in the detail section with Hide Duplicates on them) will be the best answer. You'll only know by trying it out.
Hope this helps--g

 

[ZoomerZ]

Thanks, it seems working except i am having huge blank spots between groups...and yes I am formatting it and making boxes as small and close as I can. Thanks

 

[ZoomerZ]

I see now...where it was 4 records and they are hidden now - it still alocates space for 4 records. It is no good...please, anyone?

 

[MichaelRed]

see the ubiquitous {F1} (aka H e l p) re CanGrow" (& cousin :CanShrink)





MichaelRed

 

[GingerR]

is all the data for the four records exactly the same? if so you might want to check out the query property "Unique Records" or make your query into a TOTALS query.

 

[ZoomerZ]

I set all CanGrow/CanShrink to YES but still there one field 42 records and it alocates 42 blanks so one page almost blank. I will check Unique Records though...Thanks

 

[ZoomerZ]

Thanks TotalS qUERY WORKED !!!