A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report formatting hangs



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 06:23 PM posted to microsoft.public.access.reports
Tara
external usenet poster
 
Posts: 269
Default Report formatting hangs

I have a report (rptHV) that uses a query (qryHV) as its record source. The
user opens a form (frmHVClient), chooses a name from a combo box, and then
clicks a command button (cmdClient) to run the report. The report works fine
as long as certain client names are not chosen. If those certain client
names are chosen, a progress bar appears in the status area with the message,
"Formatting report - press ctrl + Break to stop..." and the report hangs and
never formats at all. Coincidentally (or not) the clients that cause the
issue are all assigned to the same staff member. I've looked at the data in
those records several times and everything appears normal, so I'm at a loss
as to why this is happening.
  #2  
Old June 3rd, 2010, 04:17 AM posted to microsoft.public.access.reports
Allen Browne
external usenet poster
 
Posts: 11,706
Default Report formatting hangs

This is probably to so with the properties of the sections and groupings. It
may be attempting to find a solution that's not possible.

To test if this is the problem, open the report in design view. In the
Sorting and Grouping box, make sure that each group header/foot is set to
"Do not keep together."

If that doesn't solve it, right-click the Detail section, and choose
Properties. On the Format tab of the properties box, set Keep Together to
No. Repeat for the other sections on the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Tara" wrote in message
...
I have a report (rptHV) that uses a query (qryHV) as its record source.
The
user opens a form (frmHVClient), chooses a name from a combo box, and then
clicks a command button (cmdClient) to run the report. The report works
fine
as long as certain client names are not chosen. If those certain client
names are chosen, a progress bar appears in the status area with the
message,
"Formatting report - press ctrl + Break to stop..." and the report hangs
and
never formats at all. Coincidentally (or not) the clients that cause the
issue are all assigned to the same staff member. I've looked at the data
in
those records several times and everything appears normal, so I'm at a
loss
as to why this is happening.


  #3  
Old June 3rd, 2010, 03:18 PM posted to microsoft.public.access.reports
Tara
external usenet poster
 
Posts: 269
Default Report formatting hangs

The second suggestion fixed it! Now I just have to figure out why it's
having trouble with the grouping...

Thanks so much!

"Allen Browne" wrote:

This is probably to so with the properties of the sections and groupings. It
may be attempting to find a solution that's not possible.

To test if this is the problem, open the report in design view. In the
Sorting and Grouping box, make sure that each group header/foot is set to
"Do not keep together."

If that doesn't solve it, right-click the Detail section, and choose
Properties. On the Format tab of the properties box, set Keep Together to
No. Repeat for the other sections on the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Tara" wrote in message
...
I have a report (rptHV) that uses a query (qryHV) as its record source.
The
user opens a form (frmHVClient), chooses a name from a combo box, and then
clicks a command button (cmdClient) to run the report. The report works
fine
as long as certain client names are not chosen. If those certain client
names are chosen, a progress bar appears in the status area with the
message,
"Formatting report - press ctrl + Break to stop..." and the report hangs
and
never formats at all. Coincidentally (or not) the clients that cause the
issue are all assigned to the same staff member. I've looked at the data
in
those records several times and everything appears normal, so I'm at a
loss
as to why this is happening.


.

  #4  
Old June 3rd, 2010, 07:06 PM posted to microsoft.public.access.reports
John Spencer
external usenet poster
 
Posts: 7,815
Default Report formatting hangs

Usually, the amount of the data in the section is TOO large to keep together.
So Access looks for another page to put it on, but if the amount of data is
too large to fit on one page Access looks for another page and ...

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Tara wrote:
The second suggestion fixed it! Now I just have to figure out why it's
having trouble with the grouping...

Thanks so much!

"Allen Browne" wrote:

This is probably to so with the properties of the sections and groupings. It
may be attempting to find a solution that's not possible.

To test if this is the problem, open the report in design view. In the
Sorting and Grouping box, make sure that each group header/foot is set to
"Do not keep together."

If that doesn't solve it, right-click the Detail section, and choose
Properties. On the Format tab of the properties box, set Keep Together to
No. Repeat for the other sections on the report.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Tara" wrote in message
...
I have a report (rptHV) that uses a query (qryHV) as its record source.
The
user opens a form (frmHVClient), chooses a name from a combo box, and then
clicks a command button (cmdClient) to run the report. The report works
fine
as long as certain client names are not chosen. If those certain client
names are chosen, a progress bar appears in the status area with the
message,
"Formatting report - press ctrl + Break to stop..." and the report hangs
and
never formats at all. Coincidentally (or not) the clients that cause the
issue are all assigned to the same staff member. I've looked at the data
in
those records several times and everything appears normal, so I'm at a
loss
as to why this is happening.

.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.