473,757 Members | 10,708 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Report very slow to load with subreport, how can I speed it up?

Hi all,

Using Access 97 Front End, linked to SQL Server back end.
Required data is spread across three tables, with one table linked
one to many to the two others.

I created a report based on one child and the master (inner join),
which works properly and loads to preview in less than a second.

Created the second report using the third table, with a select
distinct clause, that also loads very rapidly.

When I insert the second report into the detail section (also tried
in a group header) of the first, linking the Foreign key in the
subreport to the Primary key of the main report, The form takes
thirty seconds to load, with the status bar text saying "formatting
page" all this time.

Once the form has loaded I have about 4 records per page. There are
about 100 records on the main report altogether, and each subreport
instance has from 1 to 5 records (without the distinct clause, I
might have 200 records on the subreport) .

The foreign key is indexed in the subreport.

Any clues as to how I can speed up the form loading?

Nov 12 '05 #1
0 3215

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
7058
by: deko | last post by:
I can't move a multi-page report to the last record unless I keep the popup form (that defined it's subreports) open. DoCmd.OpenReport "rptStandard", acViewNormal DoCmd.Close acForm, "frmReportOptions" <== popup form This is the error I get when I try to move to the last page of the report *after* closing the popup: "This expression is typed incorectly, or is too complex to be evaluate...."
3
2210
by: Dom | last post by:
Hi, I have a werid problem with a subreport. If someone can help me out I'd be very grateful! Based on results from a query, the visibility of textboxes and labels in a subreport are set to true or false. Some sample code is below. It all looks straight foward however the desired output does not happen. To makes things even more strange when I load the Print Preview of the subreport and then switch to the Design View of the subreport...
7
3571
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those students in that program are printed. I want the subreports headings to print only for the first student on the page. Is there a way to suppress printing of the headings on subsequent students on that page? I tried the following in both the...
1
3064
by: khalsaiskingraajkaregakhalsa | last post by:
hello all, i m using vb.net.i want to make a crytal report which contains a subreport in the header .the subreport in the header will display class info like class ,class teacher,class monitor and school name. the main report will display the list of students in that studying in that class.list contains info like student name,age and sex. i am using dataset for the data source of report. i can bind only one dataset at a time to the...
2
1708
by: Jasper Jones | last post by:
Hi, I've designed several Crystal Reports using the built in wizard. They point to my database as HQ which is called "Thom". There is a database called Sales on Thom which all the reports point to and get their results from. I'm ready to compile my program to give to the users at a different site. They have a database server there called "Sidney" which had a copy of the same "Sales" database on there. Is there a way I can change the...
1
6795
by: Andrew Hall | last post by:
Can any one tell me how to report "no data" from a subreport to the main report. The "On No Data" in the subreport does not fire when the main report runs The "On No Data" in the main wont fire because the data does not exist in the main report anyway The report I have has five subreports. 4 will almost always return data
4
7235
by: Jana | last post by:
Hi! I have an Access 97 report based on tables linked to an SQL back end. The report has 5 subreports in it (unfortunately unavoidable due to the nature of the report) and performance is quite slow. The query runs quickly and the report displays the first page in a short amount of time, but takes quite a while to format each page. This means it takes a long time to print the report (up to 50 mins to print around 360 pages!) as it...
2
2186
by: hmznzr | last post by:
i am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
7
10113
OuTCasT
by: OuTCasT | last post by:
I know how to change the database and sqlserver for a crystal report Dim report As New ReportDocument Dim connection As IConnectionInfo Dim oldServerName As String = ".\SQLEXPRESS" Dim oldDatabaseName As String = oldDatabaseName Dim newServerName As String = newServerName Dim newDatabaseName As String = newDatabaseName Dim UserID As String = "" Dim Password As String = ""
0
9489
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
9885
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9737
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8737
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7286
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5172
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3829
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3399
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.