REPORT FORM TO FILE ISSUES

[lcbart]

(simplified example of issue)

TABLE 1 - Customers
TABLE 2 - Contracts.

I have a process that scans through table 1, then scans table 2 for Contracts associated with the customer in table 1. When this data is collected I then issue a "REPORT FORM TO FILE" that generates a report which is automatically emailed.

The problem is - When the first run of records and reports is complete and the record pointer changes in table 1 - I select table 2, issue the report form to file command, and somehow the currently selected table is changed back to table 1, thus causing bad report output.

I,ve been debugging this for days, and can't resolve . Any ideas ? LCB

Puritanism - the secret fear that someone, somewhere is having fun.

 

[DSummZZZ]

Check the data environment of your report. Chances are that's where it's getting changed.

Dave S.

 

[lcbart]

Thanks - but that's one of the first things I checked . Also, this only happend when the "TO FILE" clause is included. If directed to print or preview everythings fine. LCB

Puritanism - the secret fear that someone, somewhere is having fun.

 

[chpicker]

I do this with my reports in a single pass. Create a Group on the Customer ID, move your TITLE band to the Group Header, and create a Relation between the tables. Then you just issue a single REPORT FORM command to print them all in one pass.

If you use page numbers that need to start with 1 each time, set the "Reset page number to 1 for each group" checkbox in the Data Grouping dialog.

If you need a more detailed example, let me know.

Ian