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

Two reports in one page

edited December 2014 in General
Hello, is there a way to print two small full reports (Header, Detail,
footer) in a one page from same dataset? like:

Page 1
Header Employee 1
Detail Employee 1
Footer Employee 1

Header Employee 2
Detail Employee 2
Footer Employee 2
End Page 1

Page 2
Header Employee 3
Detail Employee 3
Footer Employee 3

Header Employee 4
Detail Employee 4
Footer Employee 4
End Page 2
.
.
.
Etc...


Thank you for you help.

Martin Acevedo.

Comments

  • edited December 2014
    Hi Martin,

    You will want to use two Fixed style subreports vertically sized to
    approximately half a page. See the main reports demo for examples of
    using Fixed style subreports in your report.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited December 2014
    "Nico Cizik (Digital Metaphors)" escribi? en
  • edited January 2015
    Hello Nico,



    I? am having problems using subreports because I use a virtual table created
    with joins:

    Select *

    From Employee as e

    Join EmployeeData1 as t1 on t1.EmployeeNumber = e.
    EmployeeNumber

    Join EmployeeData2 as t2 on t2.EmployeeNumber = e. EmployeeNumber



    It?s there a way to use subreports with this type of queries?





    Thanks on advance.




    "Nico Cizik (Digital Metaphors)" escribi? en el mensaje de
    noticias:54a1cfb1@mail....

    Hi Martin,

    You will want to use two Fixed style subreports vertically sized to
    approximately half a page. See the main reports demo for examples of
    using Fixed style subreports in your report.

  • edited January 2015
    Hi Martin,

    Each report/subreport in ReportBuilder simply traverses the data it is
    given.

    Rather than joining your data, you will need to link multiple datasets
    in a master-detail relationship in order to get the output you want.
    Something like the following.

    Master Dataset: Employee
    Detail Dataset: EmployeeData

    Linked on the EmployeeNumber field.

    Take a look at the following article on Data Traversal Fundamentals with
    ReportBuilder as well as the main reports demo included with
    ReportBuilder for example of how to use linked datasets.

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

    Best Regards,

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