Report problem

[swee]

Report not displaying all records

Not all my records are being displayed on my report. Only OutletB is being displayed and OutletA's records are not visible at all. Attached is my sample db.

Note: Report generally shows all the purchase orders whereas mainForm_Report shows the records based on the form, "mainForm". The problem lies with "Report". Hope that someone can help.

Many thanks,
Swee

 

[swee]

Help, anyone?

 

[st3ve]

Sorting and Grouping

SWEE,

I think you need to adjust one of the 'Sorting and Groupings' to Outlet Choice. At present you have two Sorts on PONumber.

This may not be the full solution but it should give you a start.

 

[swee]

Thanks! Got some idea from your suggestion and got me moving on.