Print a list of report

0

Hi everyone,

I made two tables

HDR
Id        TIN            Name        Address                  Email
1        1234        Mr.John       128 StPet Street    John@mail
2        2354        Ms.Daisy    256 Ein Street        Daisy@mail
3        5632        Ms.Luna     512    Aix Street      Luna@mail


DTL
TIN            Date                      Bill
1234        12-Nov-2017        $125.00
1234        13-Nov-2017        $99.00    
1234        14-Nov-2017        $256.00
2354        15-Oct-2017        $62.00
2354        16-Oct-2017        $32.00
2354        17-Oct-2017        $45.00
2354        18-Oct-2017        $77.00
5632        1-Nov-2017        $97.00
5632        2-Nov-2017        $19.00

How do i use subreport to make a pdf file look like

Dear Mr.John
I send you a message from MyCompany, thank you for using our service. This is your payment list:

Date                       Bill
12-Nov-2017        $125.00
13-Nov-2017        $99.00    
14-Nov-2017        $256.00
____________________
                               $480.00

Best regards


Dear Ms.Daisy
I send you a message from MyCompany, thank you for using our service. This is your payment list:
Date                      Bill
15-Oct-2017        $62.00
16-Oct-2017        $32.00
17-Oct-2017        $45.00
18-Oct-2017        $77.00
___________________
                              $216.00

Best regards


Dear Ms.Daisy
I send you a message from MyCompany, thank you for using our service. This is your payment list:
Date                    Bill
1-Nov-2017        $97.00
2-Nov-2017        $19.00
___________________
                             $116.00

Best regards

Thank you

 

namdn.vt's picture
Joined: Oct 23 2017 - 12:12am
Last seen: 2 years 2 months ago

1 Answer:

0

Use your main report to get your HDR data and display those in either the detail band or maybe even column header.

Then build a subreport which get's your TIN as a parameter from your main report. Then use that parameter in your subreports SQL statement to get all entries for that TIN and build the layout as you described.

Last put that subreport inside your main report, send the field TIN from main report to parameter TIN of subreport and you'll be good.

MiditecReportDev's picture
Joined: Mar 6 2016 - 11:42pm
Last seen: 1 year 8 months ago
Feedback