Home General

Export to text from subreport

edited February 2011 in General
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.

Comments

  • edited February 2011
    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.