Report displaying less records than query

[jv2]

Hello all...

I have a wierd problem and not sure what is causing it... any pointers in the right direction would be greatly appreciated!!!

so, I have a report, which is based on query, which queries the "staff" table.
For example, I have a query which returns 12 staff members for a particular team.

now, when I run the report based on that query (the report lists the staff members from the query and displays sub reports for each staff member)... the report only prints out 5 out of those 12 listed in the query.

Any ideas on what's going on?

Thanks for your help!

 

[Uncle Gizmo]

Presuming that the sub report should display data from a related table, is there any related information in that related table? Is there any information relevant to the twelve people ?

 

[jv2]

the sub reports are related by "staff_number"...

only one of them has any data entered for one of the sub reports. however, the report prints out "empty" pages for the rest of staffmembers... i.e. it comes out with the staff details at the top of the page...

but, the report only prints out a few of the staff listed in the query it is based on - randomly. i.e. it is not the first few of them.

if you are saying that the report would not, or should not, print them anyway, if the related subreports have no data, then why is it printing out some of the staff members with no data entered for them...?

 

[Rich]

Your main Report is based on the wrong query, it's printing a page for each member and not just those listed in your subReport query

 

[jv2]

Ive got the problem sorted now...
I noticed that I had put the details of the staff member in the page header, but I was not forcing a new page after each of the detail section... obviously some of the staff details were disappearing tehre somehow...

it is now printing all 12...

Rich, I think I understand what you mean... but please correct me if Im wrong... you are saying that I should have the query look up stuff for both staff details and the subreport in one go? or not?

the problem for me is that I have 12 different subreports... and the user can use the check boxes on a form to control whether each of these subreports are displayed on the report... so what shoud I do with this so that I would get what you are suggesting? i.e. display only staff with some details in at least one subreport?

staff team query (joined with) sub1data OR sub2data OR sub3data and so on... ????