473,804 Members | 3,278 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

A2K: Report hangs whith subreport on 2 pages

Hi all,
I have a report with a sub report in it. Everything displays all
right, even with records in the main report on >1 page (*).
But as soon as there are so many records in the _sub_report that a 2nd
page is necessary, the report hangs forever (can be stopped by Esc).

With just 1 record less than the "hanging number" there are 2 or 3
empty pages with only the headers of the main report - perhaps a
related problem.

Any ideas?

Fredi Daellenbach

(*) there are times I'm happy when the basic things work...

ps problem posted already by B. Paluch on june 13 2002, with no
answers
Nov 12 '05 #1
1 1474
Fredi Daellenbach wrote:
Hi all,
I have a report with a sub report in it. Everything displays all
right, even with records in the main report on >1 page (*).
But as soon as there are so many records in the _sub_report that a 2nd
page is necessary, the report hangs forever (can be stopped by Esc).

With just 1 record less than the "hanging number" there are 2 or 3
empty pages with only the headers of the main report - perhaps a
related problem.

Any ideas?

Fredi Daellenbach

(*) there are times I'm happy when the basic things work...

ps problem posted already by B. Paluch on june 13 2002, with no
answers


Something might be looping out of control when perhaps the report format of
detail event fires. Sounds like you need to step through it to see what's
happening.
Nov 12 '05 #2

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

Similar topics

2
1815
by: Deano | last post by:
OK, I've been taking the detour from hell trying to sort this and after taking a walk I think I need a rethink. I have a report for a single employee that includes a subreport which lists courses taken by that person. I ask the user for Start and End dates to allow them to see only courses that fall into that date range. I'm then trying to open the report to show the current employee with a list of courses that fall within the date...
1
1456
by: Ellen Manning | last post by:
I've got a report with a subreport linked on fund number. The subreport returns 2 columns of dollar amounts, both current and YTD, by object code for the selected fund number. The user can select one or many funds. I create a query for the subreport's recordsource in the open event. My problem is that if there's more than one fund number, YTD amounts from the first fund number show up on the 2nd fund numbers' report, overwriting the...
1
1523
by: Ellen Manning | last post by:
The main report shows all medical conferences for a resident by year, by month. A resident can attend many of the same conferences in a year. In the year footer, I have a subreport that summarizes all conferences and the number of times attended. This data is stored in an array that is updated during the printing of the report detail. I cannot do a simple grouping/counting of conferences. For some conferences, the resident has to be...
3
2255
by: Ellen Manning | last post by:
I've got an unbound text box on a subreport that doesn't display all it's data. At most the data may be 50 words long. The text box is 2" wide and only enough text to fill the width once is printed. I verified thru debug that all of the data is getting put into the text box. Am I doing something wrong here? Thanks for any help or advice.
4
2809
by: Trevor Best | last post by:
I have a report that's fairly simple, page headers and footers, detail has a subreport in (can vary in length). The customer wanted a signature block for them, their client and 3rd party. This was no problem, couple of boxes and labels in the report footer. Now customer wants this signature block on the foot of page 1 (stoopid IMO as that implies people read page 1 where at the end implies they read past page 1 at least). Anyway to...
1
3778
by: shaqattack1992-newsgroups | last post by:
I know this is kind of a weird question, but is there anyway to give a subreport control of a main report? I posted my situation earlier about having drawings print out after a group. I have a report grouped by part group that lists the part numbers needed from that group. I have force new page after each group. This gives me a list of parts on each page. I want to print the needed drawings after the groups/list of parts. There are...
2
2820
by: Michael S. Montoya | last post by:
I have a report which has 3 sub-reports in the detail section. Everything (subforms, detail section) is set to Can Grow and Can Shrink as True. I have one record in which one of the subforms has about 7 detail items and the other subforms have several detail items. When I try and print this record it does not get past "Formating - Hit Control-Break" in the status line. When I delete a couple of the 7 line items, it prints fine. Is...
0
1288
by: RJN | last post by:
Hi, I'm new to crystal report and require a help urgently. My requirement is something like this. I have a main report from where I call 2 subreports, say summary and details. The main report has a group based on a certain column and say this results in "n" distinct groups. The details of each group I'm getting from a subreport.
0
2205
by: rjn | last post by:
Hi I have a main report in which I have inserted a sub report. I have a formula field on the main report and one on the sub report. I want the formula in the subreport to be evaluated after the formula in the main report. The sub report is called in the report header of the main report and the formula fields are in the details section of the reports. Main report looks something like this. Report Header
0
9706
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...
0
9582
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10580
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10082
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
9157
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...
0
6854
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5525
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...
1
4301
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
2993
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.