473,883 Members | 1,665 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem - HUNDREDS of pages blank detail section

Hello,

I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.

I am finding that on some occasions the report errors and generates hundreds
(perhaps even an infinite loop...I have to break the system to stop the
report generating) of pages.

While I'm not 100% I think this may have something to do with the detail
section (memo field) running over to 2 pages.

The Detail section itself is set to YES for Can grow and Can shrink.
The memo field control is also set to YES for Can grow and Can shrink.

In the Sorting and Grouping I have turned off the KEEP TOGETHER property for
now.

The report itself gathers messages sent to a particular site (first grouping
level) and then groups messages sent to a single person(second grouping
level).
The can grow/shrink is so I can get many varying length messages on as few
pages as possible.

Any ideas or thoughts would be greatly appreciated.
Jul 26 '06 #1
4 3162
Mal Reeve wrote:
Hello,

I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.

I am finding that on some occasions the report errors and generates hundreds
(perhaps even an infinite loop...I have to break the system to stop the
report generating) of pages.

While I'm not 100% I think this may have something to do with the detail
section (memo field) running over to 2 pages.

The Detail section itself is set to YES for Can grow and Can shrink.
The memo field control is also set to YES for Can grow and Can shrink.

In the Sorting and Grouping I have turned off the KEEP TOGETHER property for
now.

The report itself gathers messages sent to a particular site (first grouping
level) and then groups messages sent to a single person(second grouping
level).
The can grow/shrink is so I can get many varying length messages on as few
pages as possible.

Any ideas or thoughts would be greatly appreciated.

The times that I've had blank pages is when my report and print margins
conflict. It will print some data and then a blank page, data, blank
page, etc.

I would think that before you solve this problem you do a few print
previews first.
Jul 27 '06 #2
You can get an infinite format loop if you set a header section
to not visible in code.

put a code counter in the format event so that you can break
if you get an infinite loop.

use the hide and skip methods to go past the problem if necessary.

(david)

"Mal Reeve" <ma******@hotma il.comwrote in message
news:tC******** *********@newsr ead2.news.pas.e arthlink.net...
Hello,

I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.

I am finding that on some occasions the report errors and generates
hundreds (perhaps even an infinite loop...I have to break the system to
stop the report generating) of pages.

While I'm not 100% I think this may have something to do with the detail
section (memo field) running over to 2 pages.

The Detail section itself is set to YES for Can grow and Can shrink.
The memo field control is also set to YES for Can grow and Can shrink.

In the Sorting and Grouping I have turned off the KEEP TOGETHER property
for now.

The report itself gathers messages sent to a particular site (first
grouping level) and then groups messages sent to a single person(second
grouping level).
The can grow/shrink is so I can get many varying length messages on as few
pages as possible.

Any ideas or thoughts would be greatly appreciated.

Jul 27 '06 #3
Thanks,

I think I could skip the problem - but how do I determine if it is going to
happen.

Basically - how do I determine if this next instance of the detail will flow
over to another page?

And (for the sake of the reply from Salad) this is not an every other page
type of thing...everyth ing will be good for mny pages, then one particular
record will cause the loop.

I have experimented and found that if I shink the font size enough (varies
on the memo length) it will print just fine. Problem there is I will never
know how much space is left at the bottom of the page.

Thanks,
Mal.

"david epsom dot com dot au" <david@epsomdot comdotauwrote in message
news:44******** *************** @lon-reader.news.tel stra.net...
You can get an infinite format loop if you set a header section
to not visible in code.

put a code counter in the format event so that you can break
if you get an infinite loop.

use the hide and skip methods to go past the problem if necessary.

(david)

"Mal Reeve" <ma******@hotma il.comwrote in message
news:tC******** *********@newsr ead2.news.pas.e arthlink.net...
>Hello,

I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.

I am finding that on some occasions the report errors and generates
hundreds (perhaps even an infinite loop...I have to break the system to
stop the report generating) of pages.

While I'm not 100% I think this may have something to do with the detail
section (memo field) running over to 2 pages.

The Detail section itself is set to YES for Can grow and Can shrink.
The memo field control is also set to YES for Can grow and Can shrink.

In the Sorting and Grouping I have turned off the KEEP TOGETHER property
for now.

The report itself gathers messages sent to a particular site (first
grouping level) and then groups messages sent to a single person(second
grouping level).
The can grow/shrink is so I can get many varying length messages on as
few pages as possible.

Any ideas or thoughts would be greatly appreciated.


Jul 27 '06 #4
Mal Reeve wrote:
And (for the sake of the reply from Salad) this is not an every other page
type of thing...everyth ing will be good for mny pages, then one particular
record will cause the loop.
What happens if you print the report for just the record with a memo
that creates the problem? Does that error too?

What happens if you preview the report?

Does this occur everytime for the same record or will it work one time
with the record and othertimes not?

What would happen if you created a report with just the ID and Memo
field and then inserted this as a subreport into the current report,
removed the current memo field, and then linked the subreport to the
main report's ID?

What would happen if you created an extra column in the recordsource like
ExtraColumn : 1
and then put that in detail band and made the field hidden?

What is the setting for KeepTogether for your various bands? See if
changing that makes a difference.

>
I have experimented and found that if I shink the font size enough (varies
on the memo length) it will print just fine. Problem there is I will never
know how much space is left at the bottom of the page.

Thanks,
Mal.

"david epsom dot com dot au" <david@epsomdot comdotauwrote in message
news:44******** *************** @lon-reader.news.tel stra.net...
>>You can get an infinite format loop if you set a header section
to not visible in code.

put a code counter in the format event so that you can break
if you get an infinite loop.

use the hide and skip methods to go past the problem if necessary.

(david)

"Mal Reeve" <ma******@hotma il.comwrote in message
news:tC****** ***********@new sread2.news.pas .earthlink.net. ..
>>>Hello,

I have a report that has only 2 levels of grouping.
The detail section is simply 1 large block for a memo field.

I am finding that on some occasions the report errors and generates
hundreds (perhaps even an infinite loop...I have to break the system to
stop the report generating) of pages.

While I'm not 100% I think this may have something to do with the detail
section (memo field) running over to 2 pages.

The Detail section itself is set to YES for Can grow and Can shrink.
The memo field control is also set to YES for Can grow and Can shrink.

In the Sorting and Grouping I have turned off the KEEP TOGETHER property
for now.

The report itself gathers messages sent to a particular site (first
grouping level) and then groups messages sent to a single person(second
grouping level).
The can grow/shrink is so I can get many varying length messages on as
few pages as possible.

Any ideas or thoughts would be greatly appreciated.


Jul 27 '06 #5

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

Similar topics

5
4554
by: Bob | last post by:
Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle line page header, three lines of detail (name address etc)and a footer. On previewing or printing the report it inserts a blank three line detail section before the first record. Every other page is fine except this first page. Not a big deal but it...
6
2703
by: David B | last post by:
I have a report with 2 sub reports on it. The report is an invoice and the sub reports are dropping data onto the invoice. This worked fine if generating 1 invoice at a time. I am trying to create a run of invoices. I would like the appropriate data for each custid from each sub report to be on the same page. The nearest I can get is 2 pages for each customer Any Thoughts TIA David B Hexham UK
4
5410
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a memo field When CAN GROW is set to NO everything works just fine. When CAN GROW is set to YES - watch out.... One record causes BIG
4
2810
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
2157
by: Nadia Daems via .NET 247 | last post by:
I desingned a report with several subreports to use in my application. Normally each subreport have to start on a new page. I did this by making a diffrent section for each subreport and selecting the option "New page before" for each section. When a subreport is blank, both the subreport and the section are suppressed but the new page isn't, so there are empty pages in my report. Because the reportheaders of the subreports are suppressed,...
2
4449
by: Ray | last post by:
Dear all, I would like to ask if the crystal Report can remove if blank in Detail just like Report in Foxpro? Thanks a lot, Ray
1
3550
by: Daniel Alvarez | last post by:
Hello. First of all, I'm working in an ASP.NET 1.1 project, which has a large page (due to client requirements, a huge page is needed to process the information, and it has a lot of interactivity with the user, so that if some value changes, the screen refresh showing some other data, or a grid, and so on). This is working well (but slow, but this is not the problem right now). The problem is that, randomly, opening the page, or refreshing...
3
1701
by: Zippy | last post by:
I have a report which has a list of products, with a total page count. Due to layout concerns, the client wants to be able to adjust how many products are printed on a page. What I do, is keep a count of products and force a page break when the total no of products per page is reached. (It is a very messy business. I have been trying unsuccessfully to convince them to change the layout to avoid this need). The problem now is that the...
4
5619
by: Tom | last post by:
Hi: I'm having a problem with a simple report in a simple database. Basically it's an issue tracking database - what is the issue, what is the proposed solution, who is responsible, a tracking number, and that is it. Two tables - one for the issue, one for the people (one issue can have more than one responsible person). No code - whole thing slapped together in 15 minutes. The report is set up to print the tracking number, issue,...
0
9779
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
11114
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
10730
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10407
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...
1
7960
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
7114
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
5787
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
4605
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
3230
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.