If Used('INVOICE') and Used('DISCOUNT') then & check tables are accessible

* when starting the report the current pass number is 0 it becomes 1 for the second pass Go to the end of these comments and enter the following after which click the OK button to save your changes.

In the Run-time extensions: edit box you will see This says that the code we are going to enter is run just prior to running the report. In the Execute when: text box put BEFOREREPORT Now click Run-time extensions Edit settings to open the Run-time extension edit window On the properties dialog select tab - Other Now under ReportWriter, select menu option Report | Properties. You only need 1 Detail Band in this report (we are basically doing what Tom does or did for older versions of VFP). Now what to do with this Union Select which has put our fields into the Union Reporting Cursor URCįirst, make a copy of the report you intend changing - or better still start with a fresh report. Rectype, customerid into cursor URC NOFILTER Select '1' as rectype, customerid, txt, amt, 0 as discountpercent, $0.00 as discamt from INVOICE UNION Select '2' as rectype, customerid, space(50) as txt, $0.00 as amt, discountpercent, discamt from DISCOUNT order by Now as Union selects MUST have the same structure in each part of the union (here's 1 of the difficulties) the Union select for our tables is

We also need to add a RecordType field to the end cursor to identify the source of each record and as a sort parameter. So lets assume table INVOICE has fields customerid as Int, txt as char(50), amt as currĪnd that table DISCOUNT has fields customerid as Int, discountpercent as Num(2), discamt as curr Thus, you need to use a 'Union Select' on the 2 tables to create a third cursor, which you then link too If you don't want to or you can't change the program code producing the required report under VFP 9 SP2 ReportWriter can be done - but a warning - it is not easy and full of technical traps.įundamentally what you have to do is to get the report to merger the 2 tables together into a single cursor before it starts reporting.

Phpmaker multiple detail tables