>I have a reporting requirement which in order to do I've broken it down into five separate VFP report forms. Collectively it is refered to as a Batch Ticket in the plant. Each section of the 'Batch Ticket' has data that is specific to a type of operation in the plant. Each section is different except that they all share a common header band. My problem is that when I print these batch tickets I'm getting a 'light show' of 'Printing page...' and because they gang print multiple batch tickets it is generating quite a number of print jobs in the printer queue. Is there any way to link these different report forms together into one common .FRX/.FRT report file and send only once to the printer for each batch ticket? Or better yet, select all the info to print all the batch tickets needed and do a page break on the batch no.?
You can SELECT all the needed records into a cursor and in the order they need to be in and do the page break on the batch no. YOu could also just use 1 report form, duplicate fields on on top of the other and use the PRINT WHEN feature in the properties of each object. For example, if you have a label that says applies only to "Section A" on one report and a label that only applies to "Section B" on a second report, you can have 2 labels on the same report form, one label directly on top of the other. In the properties of each label, you would PRINT WHEN FieldName_Section = 'A' for the A label and PRINT WHEN FieldName_Section = 'B' for the other label.
Mark McCasland
Midlothian, TX USA