Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Saving to a flat file format

edited May 2011 in General
Good afternoon,

This may be a very basic question but I am very new to this. I am looking
to be able to save the results of a simple query into a 'flat file' format.

Essentially, this is a list of email addresses, where I would like each
address to be separated by a semi-colon. This is to be used as a
distribution list of sorts.

Is this possible to generate without carriage returns being generated
between the records?

Thanks in advance!

Comments

  • edited May 2011
    Tanya,


    select list(mailaddress,';') from myAddresses where ...

    Regards Uli
  • edited May 2011
    Tanya,

    sorry, I messed up the NG's. I though I was posting in the ElevateDB NG.

    This is an ElevateDB extension. Perhaps a reason to try EDB? :)

    Cheers Uli
  • edited May 2011
    Hi Tanya,

    You should be able to export your report using the Text File device.

    From the designer open the "Print To File Setup" dialog (File menu) and
    select the text components you would like to export. Next you need to
    set a custom delimiter and other custom properties in code. See demos
    105 and 106 in the \Demos\1. Reports\... directory for examples of how
    this can be done. Also take a look at the TppTextFileDevice topic in
    the ReportBuilder help for more information about the features of the
    text file device.


    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.