I have a report set up:
It has a Report Header, Page Header & a Report Footer.
The main driver of the Report is a Contract Nbr
We are running Paradox 9 with all applicable Patches

Whenever the last page is needed to display the Grand Total AND there are
no items on that page the Grand Total is wrong SOMETIMES:
1) If the report with the above specs is printed before any other Contract
Nbr the Grand Total is accurate
2) if you re-run the Report after an accurate print-out, the Grand Total
is double the actual amount
3) if you exit Paradox and run & print the Report the Grand Total is accurate
4) as best as I can tell, if you look at the report via Project Viewer /
Reports, the Grand Total is ALWAYS double even when the Report prints accurately


Please help me fix this oddity…

Thanks!

Dear Jeanette,

Try adjusting the BDE settings for for MINBUFSIZE and MAXBUFSIZE to 8192 and
16384 respectively and try the report again. Make sure that you have
MAXFILEHANDLES set to 150

Gene


"Jeanette" <HarrisJR (AT) bwsc (DOT) org> wrote

"PSPI" <pspi (AT) eastern (DOT) com.ph> wrote:
Can I make these changes while Users are logged in?

Changes in the BDE will only take effect next time you start the BDE
(=Paradox).

I doubt the settings for maxfilehandles will help in this case.

Min and max bufsize, maybe...

Anders

Jeanette wrote:

It is unfortunately a well-known fact that the subtotals in a Paradox report
are sometimes wrong. The problem seems to have something to do with the
exact placement of page-breaks.

I have found that the only reliable solution ... is not to use report
generated totals at all, but to calculate them in queries and/or ObjectPAL
before the report runs. Yeah, I know... a crock.

"Sundial Services" <info (AT) sundialservices (DOT) com> wrote in message
hey.. that concept is *not* a crock.. it's the starting point of a way to do
stuff, on an on-going basis, that is way beyond the capabilities of the
report generator.. specifically, multiple sub-totals within groups..

i.e. totals for labor / travel / other costs, within each group.. and/or
totals per employee and/or per company within each group.. and/or product
groups.. and/or calc'd rates per multiple sub-groupings..

the possibilities are endless, depending on context.. but the point is the
same.. make "calculating sub-totals" a regular item in your toolbox..


--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

Steven Green wrote:

I think Mike's point is that it's a crock that one has to worry about it for
stuff that *should* be within the capabilities of the report generator.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com
Check out www.thedbcommunity.com for Paradox resources.