Data missing from report

[KurtL]

Im trying to create a where used report that shows the part number, the assemblies its used in, and a total of the places used. When i open the report the first half of the data from the queries is missing. Attached are 2 screen captures. Queries shows the top of the 2 queries i used to create the report, and whereusedreport is a screen capture of the report.

As you can see the data in the queries starts with 001003021 but the report starts with 201010001.

Whats going on?

 

[KurtL]

I just attempted making the same report with just the part numbers < 201010001 and the report came up blank.

 

[boblarson]

Are you using that particular query for the report you are showing? Are there any grouping levels on the report?

 

[KurtL]

Are you using that particular query for the report you are showing? Are there any grouping levels on the report?

The 2 queries I posted are being used for the report that was shown.

I am grouping by the part number.

Kurt