cancel
Showing results for 
Search instead for 
Did you mean: 

SubReports

Former Member
0 Kudos

Hello,

I am trying to run two subreports on one report page. Each one subreport on one side of the paper such that data is printed on both the left and right sides of the paper.

Hence for one subreport I have

SELECT * FROM DBO.OHEM WHERE (dbo.OHEM.empID % 2 = 0)

and for the other I have

SELECT * FROM DBO.OHEM WHERE (dbo.OHEM.empID % 2 = 1)

Hence I should have employees with even numbers on one side and odd numbers olan another. However I get the problem where the first page is completely blank, and I have 66 pages. There are 66 employee in the OHEM master data. How do I resolve this error. I pass the two parameters month and year to filter information.

Kind Regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Marco,

Try this, sample


SELECT *
FROM
(SELECT * FROM OHEM T0 WHERE T0.empID % 2 = '0'
UNION ALL
(SELECT * FROM OHEM T0 WHERE T0.empID % 2 = '1')a

Check the thread(UNION ALL - Sample Query)

Regards,

Madhan.

Former Member
0 Kudos

How about the other pages? If it is fine from second page, the first page might be parameter page with empty parameter.

Thanks,

Gordon

Former Member
0 Kudos

The other pages have data, Upto 66 pages, which i think is for all 66 employee id's. How can I remove the first blank page ?

Kind Regards,