Subreport Errors 1

[Tdharris]

I have a timesheet report that captures three different types of leave from 3 different databases. The main report contains one type of leave and two subreports capture the other two types. The reports are joined by employee id #'s and have a date range parameter. The issue I'm having is, if the employee has no leave recorded in the leave type that is the main report, then I get no results in the sub reports either. Even if the subreport data has leave in them for that employee.

Thanks,
TDH

TDH
Business Application Specialist

 

[lbass]

If one of the subs contains all employees, then you should use that as your main report, but I'm guessing that what you really need to do is use a table that contains all employees for your main report, and then use three subs to to show the three kinds of leaves. Subreports behave like tables that are left outer joined to the lead table, i.e., they will only show results for IDs/key fields that match those in the main (lead) table.

-LB

 

[Tdharris]

Thank You,
I was leaning toward 3 subreports and will definately give it a try with the main only containing employees.

Thanks again
TDH

TDH
Business Application Specialist