SubReport Filtering problem with massive amount of pages

JuniorWoodchuck24

Registered User.
Local time
Today, 08:10
Joined
Jan 13, 2010
Messages
59
I've created a Report with two Subreports on it. The problem I'm having is that the report is only 4 pages, but it keeps repeating the same 4 pages until page 680. Any idea what is wrong?
 
Something isn't properly JOINed so you are getting what is called a Cartesian product. OR your filtration criteria are incorrectly specified and you aren't filtering out records you should be ignoring. One of those two will do it.

For the improper JOIN, the subreports will work better when a formal relationship exists (i.e. in the Relations window) between the parent and child tables. Failing that, if a parent and child have a decent JOIN between them, they will eliminate a lot of duplication.

For the improper filtration issue, if the report was supposed to focus on some particular value for a given field, that selectivity wasn't defined right.
 
It was the improper filtering. Thanks for pointing me in the right direction.
 

Users who are viewing this thread

Back
Top Bottom