Solved

Formatting every page when in preview

Posted on 2011-03-22
4
280 Views
Last Modified: 2012-05-11
Is there a way to speed up the viewing of a report in access 2003?  Right now it takes awhile to go the next page.  In the window, access is displaying formatting page.  
0
Comment
Question by:DowneyCity
  • 2
4 Comments
 
LVL 75
ID: 35194687
What is the SQL for the query driving the Report - if it is a query ?

mx
0
 

Author Comment

by:DowneyCity
ID: 35194940
SQL database and the query is created in access.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 25 total points
ID: 35194973
Sorry ... I meant post the SQL for the query.

And are you saying this is a SQL Server backend ?

Also ... there are 100's of things that can affect report performance ... a complex query included.

mx
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 25 total points
ID: 35195563
<there are 100's of things that can affect report performance>
Graphics and Code being two others...

In other words, you need to tell us a bit more about this report...
Post the SQL (as MX asks)
Any Graphics in the report?
Any code in the report
How many Grouping levels

Also you need to define "it takes awhile" in real chronological terms...
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question