Comma-Delimited problem with Master/Detail
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
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
This discussion has been closed.
Comments
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/
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
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
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/
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com