Repeat Section = Yes causes large report to hang

[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

 

[Duane Hookom]

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

--
Duane Hookom
MS Access MVP

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?

 

[Guest]

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

I have a couple of reports with where I group data using the Group Heade

(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