Solved

Formatting every page when in preview

Posted on 2011-03-22
4
261 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now