Repeat Section = Yes causes large report to hang

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

Guest

I have a couple of reports with where I group data using the Group Header (Sorting and Grouping) and I have the header section property set to Repeat Section = Yes. When I run these reports against a larger data set, it chokes. The status bar says "Formatting page, press Ctrl+Break to stop..." And it says this forever. I've walked away and taken a long break and come back and it's still doing that, so I just have to cancel out. I finally noticed that when I set the header property to Repeat Section = No, it works just fine and is quite fast. But, the report needs the grouping. Any ideas on how to handle this

Thanks
Clarissa
 
If you have Page of Pages in the report, try remove at least the Pages part.

--
Duane Hookom
MS Access MVP


Clarissa said:
I have a couple of reports with where I group data using the Group Header
Click to expand...
(Sorting and Grouping) and I have the header section property set to Repeat
Section = Yes. When I run these reports against a larger data set, it
chokes. The status bar says "Formatting page, press Ctrl+Break to stop..."
And it says this forever. I've walked away and taken a long break and come
back and it's still doing that, so I just have to cancel out. I finally
noticed that when I set the header property to Repeat Section = No, it works
just fine and is quite fast. But, the report needs the grouping. Any ideas
on how to handle this?
 
Hey, wow! That worked! Thank you

----- Duane Hookom wrote: ----

If you have Page of Pages in the report, try remove at least the Pages part

--
Duane Hooko
MS Access MV


Clarissa said:
I have a couple of reports with where I group data using the Group Heade
Click to expand...
(Sorting and Grouping) and I have the header section property set to Repea
Section = Yes. When I run these reports against a larger data set, i
chokes. The status bar says "Formatting page, press Ctrl+Break to stop...
And it says this forever. I've walked away and taken a long break and com
back and it's still doing that, so I just have to cancel out. I finall
noticed that when I set the header property to Repeat Section = No, it work
just fine and is quite fast. But, the report needs the grouping. Any idea
on how to handle this
 
Back
Top