Keith:
I'm not sure what causes this, but I also ran into the same problem.
Upgrading to RBW 6.5++ took care of it in my application.
Tony
Anthony J. Schmidt, JD
President
The Computery Ltd.
One East Main Street
Bay Shore, NY 11706
631-665-8100 Voice
631-969-5988 Fax
|---------+---------------------------->
| | owner-rbase-l@son|
| | etmail.com |
| | |
| | 02/19/2002 11:51 |
| | PM |
| | Please respond to|
| | rbase-l |
| | |
|---------+---------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc: (bcc: Anthony Schmidt/BayShore/SGU_LN)
|
| Subject: RBDOS Report Break Summing
|
>---------------------------------------------------------------------------------------------------------------------------------------------|
Hi All, I really enjoy working with the long Running and Reliable
R:Base itself...my own mistakes are usually the cause of my problems,
but I have one I can't seem to get a handle on.
In R:Base for DOS 6.1a and 6.5+ a report with 2 break levels does not
sum the first detail line when it is the first item on a page after the
break header #1 has just printed on the bottom of the previous page. It
works OK for other random break positions. There are a variable number
of detail lines printed so I don't have a way to make sure the 1st break
header printes on the top of a page without setting the breakpoint new
page. If I do set a new page at the breakpoint it works fine, but
prints 38 pages instead of 17 since some of the breaks contain only one
or two detail lines. I have tried to repaginate it, but all that did
was to move the problem to the next random occurance of the situation.
I have verified that the variables are reset properly for the
breakpoints.
Example:
Break Header 1 "Category Name"<--- at bottom of a page
--------------------------------------------------------------------
Break header 2 "Account Name"<--- at top of page below page header
Detail line 1 $100.00 <--- prints, but is NOT in any totals
Detail line 2 $200.00 <--- prints and is included in totals
Account Total $200.00
If detail line 1 is by itself, the account total is $0.00. Other random
combinations of breakpoint/header/footer positions work OK also as far
as I can tell.
The Account total for Break 2, the Category total for break 2, and the
report grand total are incorrect by the line 1 amount. The problem
occurred twice in a long report, and the only way I found it was by
checking each and every item. I tried unloading the report and
reloading into a different database...same result. The customer who
reported it sent their database so I could work with their actual data
which looks fine.
Any ideas on what causes this and how to correct it?
Keith Jacks
Advanced Union Computing
mailto:[EMAIL PROTECTED]
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
