Report never shown up

G

GL

Hello
I have a report named “Find Items to Share†that includes a subreport named
“Find Items to Share Subreport†in its detail section.

Main’s report detail section is populated by the query:

SELECT Items.ItemCode, Items.Kind, Items.Type, Items.SupplierID,
ProjectItems.fkProjectID, Projects.StartCompDate, Projects.EndCompDate
FROM Projects INNER JOIN (Items INNER JOIN ProjectItems ON Items.ItemCode =
ProjectItems.fkItemCode) ON Projects.ProjectID = ProjectItems.fkProjectID
ORDER BY Items.ItemCode, Items.Kind, Items.Type;

And subreport’s detail section is populated by the query:

SELECT ProjectItems.fkProjectID, Items.ItemCode, Items.Kind, Items.Type,
Items.SupplierID, Projects.StartCompDate, Projects.EndCompDate
FROM Projects INNER JOIN (Items INNER JOIN ProjectItems ON Items.ItemCode =
ProjectItems.fkItemCode) ON Projects.ProjectID = ProjectItems.fkProjectID
WHERE (((Items.ItemCode)<>[Reports]![Find Items to Share]![ItemCode]) AND
((Items.Kind) Like [Reports]![Find Items to Share]![Kind]) AND ((Items.Type)
Like [Reports]![Find Items to Share]![Type]) AND ((Items.SupplierID) Like
[Reports]![Find Items to Share]![SupplierID]) AND ((Projects.StartCompDate)
Not Between [Reports]![Find Items to Share]![StartCompDate] And
[Reports]![Find Items to Share]![EndCompDate]) AND ((Projects.EndCompDate)
Not Between [Reports]![Find Items to Share]![StartCompDate] And
[Reports]![Find Items to Share]![EndCompDate]));

Also main report detail section On Format event has the code:
Cancel = Not Me.SharedItemsSubreport.Report.HasData 'This skips and
doesn't show items which produce an empty subreport
The database has the tables
“Itemsâ€, “ProjectItems†and “Projects†with fields and relations as shown on
the queries above.

When I had a few hundred of records and asked for the report, it was
available after a couple of seconds. However, when for testing purposes, I
increased the number of records of “Items†and “ProjectItems†to 12000 and I
call the report, I see on the taskbar the phrase “Formatting page, …†but the
report never reveals.

Can you see where the problem is?

Thanks
GL
 
Top