Two reports in one page

rbuser

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.

nicocizik

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.

rbuser

"Nico Cizik (Digital Metaphors)" escribi? en

rbuser

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.

nicocizik

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