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

Intercalated detail lines

edited April 2016 in General
Hi.
I need to generate a text report with intercalated values (lines) from detail band,
grouped each 3 details.

See the example below:

D11 <--+ Group Header
PE |
A2 <--+

1912A0601120009<1000000> <--- Detail 1 / Record 1
1912A0601120137<2000000> <--- Detail 2 / Record 2
1912A0601120265<3000000> <--- Detail 3 / Record 3
1912A0600970009<CAL HIDRATADA CH-1> <--- Detail 1 / Record 1
1912A0600970137<CAL HIDRATADA CH-2> <--- Detail 2 / Record 2
1912A0600970265<CAL HIDRATADA CH-3> <--- Detail 3 / Record 3

Q0001 <--+ Group Footer
E <--+


From each 3 records (Detail band), I need a Header and a Footer.

What's the best way to do this?
Using D7 with RB 15.05

TIA,
Laercio

Comments

  • edited April 2016
    Hi Laercio,

    We are going to need more information about your data and exactly how
    you would like your report to appear. For instance, are you using a
    single dataset? Which field is the report grouped on? A sample of your
    data may be helpful as well.

    If you need a separate header and footer for each set of records, I
    suggest using a Master-Detail report with subreports. See the main
    reports demo for examples of creating reports like this.

    Also see the following article on data traversal fundamentals.

    http://www.digital-metaphors.com/rbWiki/Data_Access/Fundamentals/Data_Traversal

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2016
    Hi Nico,

    Problem solved!

    I was just trying to emulate 3 columns label report, but writting lines on vertical, to
    export this as a report text file.

    I solved this by using a memo control on Summary band.

    Anyway, thank you for your help.

    Laercio



    Em 28/04/2016 12:43, Nico Cizik (Digital Metaphors) escreveu:
This discussion has been closed.