Export to text from subreport

rbuser

Hi,

Currently we have a text exchange to an external party using the RB text
export. The report consists of a main report with one subreport. The main
report contains purchase orders, the subreport the purchase order lines
(products). If a purchase order contains 5 order lines the resulting text
file contains 5 lines each replicating the purchase order data with only a
changing product. This works.
The external party would now like to see 1 line per purchase order with on
that line all products. Is this possible?

So from

order_1, Janssen, 04-02-2011, product_a
order_1, Janssen, 04-02-2011, product_b
order_1, Janssen, 04-02-2011, product_c
order_1, Janssen, 04-02-2011, product_d
order_1, Janssen, 04-02-2011, product_e

to

order_1, Janssen, 04-02-2011, product_a, product_b, product_c, product_d,
product_e


Using RB11.08

Regards,
Jeroen.

nicocizik

Hi Jeroen,

The TextFileDevice is designed to break to a new line each time a new band,
subreport or crosstab row occurs. This is determined by the ReportSaveNo,
BandSaveNo, and RowSaveNo properties of the DrawText drawcommand. In order
to change this you would need to alter the code located in the
TppTextFileDevice.SavePageToFile routine where these properties are checked
against the current values to determine if a new line is needed.



Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com