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

Comma-Delimited problem with Master/Detail

edited July 2004 in Subreports
I'm using Delphi 6 and RB 6.03. I have a Master/Detail report which
successfully prints something like this:

Red Group
Bill
Jane
Bob

Blue Group
Sue
Jeff
Jim

Green Group
Ben
Leigh
Anne

When I choose Text export, I get something completely different, I get this:

Bill,Jane,Bob
Sue,Jeff,Jim
Ben,Leigh,Anne
Red Group
Blue Group
Green Group

The setup selections for Text export are very limited. Is there a
setting(s) I can change so that the comma-delimited export matches the
printed master/detail relationship?


Thanks for any info



James

Comments

  • edited July 2004
    Hi James,

    If you would like your text export to look more like the report itself, try
    setting the device to Report Emulation Text File instead of Text File. This
    should give you a result that copies the format of the report in
    ReportBuilder.

    --
    Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
    Delphi Informant Readers Choice awards!

    http://www.delphizine.com/ballot2004/

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2004
    Thanks for the suggestion, but "report emulation" isn't even close to
    usable for things like wire service sports results. Report Emulation
    truncates a lot of fields, and there are no delimiters.

    What I really need is ideally this:

    Red Group
    Bill,Jane,Bob
    Blue Group
    Sue,Jeff,Jim

    or else at least this:

    Bill,Jane,Bob
    Sue,Jeff,Jim

    If there are no setting to accomplish this, then I'm going to have to
    either re-write all the reports (over 40 of them!) with another print
    product, or else write a separate program for each report which exports
    the data correctly. Neither alternative is very attractive.

    Why would RB export records in an order so radically different from the
    way it prints them? Seems pretty straightforward. The Master looks like
    this:

    Red Group
    Blue Group
    Green Group

    and the Detail looks like this:

    Red Group,Bill
    Red Group,Jane
    Red Group,Bob
    Blue Group,Sue
    Blue Group,Jeff
    Blue Group,Jim





    James






  • edited July 2004
    Hi James,

    Sorry about that, I was completely off base with the last answer :).
    Unfortunately, the TextFile Device was not designed to handle a master
    detail report. We have had quite a few requests for this capability and
    have added this feature to our wish list for future enhancements to
    ReportBuilder. Thanks for your feedback.

    --
    Thanks for supporting ReportBuilder! Please vote for ReportBuilder in the
    Delphi Informant Readers Choice awards!

    http://www.delphizine.com/ballot2004/

    Best Regards,

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