I've created the following conditional running total based upon what I've learned from other postings here......
whileprintingrecords;
numbervar ordrunningtotal;
if ({@OrdNo} <> previous ({@OrdNo}) )
then
ordrunningtotal:=ordrunningtotal + {@OrdTot}
else
ordrunningtotal := ordrunningtotal
the...
Hi has anyone developed an import, export template or other macro that would allow me to import serial numbers into an order. We are currently using Accpac 4.1A.
I'm using CR 7.0. I've got a simple report with a subreport linked to it. I'm bringing one field from the subreport over to the main report. For each unique group, the are multiple instances of the data from the Sub-reports (ie. each detail line of an order displays the sub-report data). I...
I'm having a problem with a scheduled daily report when there is no activity to report. The report runs fine on my desktop and returns the column headings and the report title when there is no data, however when the same report is scheduled (the report is suppose to be generated and emailed via...
Ken,
Bear with me on the terminology, I'm relatively new at this...
The Docnum field in Table 1 is joined to the Invoice# field in Table 2 and Creditnote# field in Table 3 (Table 2 and 3 have an order# field which I'm trying to display).
The Database is pervasive Sql, but the joins are...
I have a single field that has invoice#'s and Credit Note# {*.DOCNUM) in one table, this field is linked to 2 fields in 2 other tables an invoice table and Credit note table (where IN's are separate from CN's).
The goal is to return the order number associated with the DOCNUM. I've created...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.