Crystal Reports 7.0 and customer statements in version 3.0

Dan,
If you want to email me what you've worked on, along with the associated dbf file(s), I would be willing to take a 'quick' look at it. The files should be in your vntgwork directory, and there may be a couple other files with the same name as the dbf file (like idx or something).

Troy Funte
Liberty Electronics

----- Original Message -----
From: Dan Shallbetter
To: 'Vantage@egroups.com'
Sent: Wednesday, January 03, 2001 1:24 PM
Subject: [Vantage] Crystal Reports 7.0 and customer statements in version 3.0


I have been struggling to write a Customer Statement using the dbf files
Vantage creates. I have discovered in the process that there is a know bug
with the running totals in Version 7.0. Seagate has a maintenance release
(crw32 7.0.200.17) and a running total specific patch. My problem I think is
with the evaluation of variables I created to support manual running totals.
I am using two basic variables one to collect the total invoice header
amount (Runningtotal1), and one to collect cash detail transaction (#invoice
transactions). I am trying to reproduce the invoice balance field
(Invchead.Invoicebal) that I don't have access to in the dbf file. The
variables are being evaluated inside the invoice number group. If I use the
function while printing records on this formula( if{customer.STMNTDATE} -
{invchead.INVDATE} <= 30 then IF {invchead.INVAMT} - {#invoice transactions}
<> 0 THEN RunningTotal1 := RunningTotal1 + {invchead.INVAMT} - {#invoice
transactions} else RunningTotal1 := RunningTotal1 + {invchead.INVAMT};) My
running total will be correctly reflected providing there are not multiple
cash detail records against a single invoice. On invoices with multiple
applications It displays the runningtotal variable before reading the last
cash detail record. If I use the evaluate after (@invoice transaction) it
displays the runningtotal as the last Invoice header amount it read. I have
spent far to much time on this already can anybody enlighten me?

Thanks
Dan Shalllbetter
States Electric Mfg.



eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files, please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to www.egroups.com, login and be sure to save your password, choose My Groups, choose Vantage, then choose Files. If you save the password, the link above will work the next time you try it.)



[Non-text portions of this message have been removed]
I have been struggling to write a Customer Statement using the dbf files
Vantage creates. I have discovered in the process that there is a know bug
with the running totals in Version 7.0. Seagate has a maintenance release
(crw32 7.0.200.17) and a running total specific patch. My problem I think is
with the evaluation of variables I created to support manual running totals.
I am using two basic variables one to collect the total invoice header
amount (Runningtotal1), and one to collect cash detail transaction (#invoice
transactions). I am trying to reproduce the invoice balance field
(Invchead.Invoicebal) that I don't have access to in the dbf file. The
variables are being evaluated inside the invoice number group. If I use the
function while printing records on this formula( if{customer.STMNTDATE} -
{invchead.INVDATE} <= 30 then IF {invchead.INVAMT} - {#invoice transactions}
<> 0 THEN RunningTotal1 := RunningTotal1 + {invchead.INVAMT} - {#invoice
transactions} else RunningTotal1 := RunningTotal1 + {invchead.INVAMT};) My
running total will be correctly reflected providing there are not multiple
cash detail records against a single invoice. On invoices with multiple
applications It displays the runningtotal variable before reading the last
cash detail record. If I use the evaluate after (@invoice transaction) it
displays the runningtotal as the last Invoice header amount it read. I have
spent far to much time on this already can anybody enlighten me?

Thanks
Dan Shalllbetter
States Electric Mfg.