my MAIN report uses an odbc link to connect to my erp system but my subreport is trying to pull data from an access database, using a desptach no which is on both the erp system and the access data table.

 

the problem is that when i run the report i get all my data for a specific despatch no on my print but then when the subreport kicks in and should report back one line of "serial no " data from the corresponding data on the access dbase, it pulls up and lists EVERY Serial no on the database, so instead of page 1 equalling a 1 page print, it now equals 1722 page print !!!!

any ideas please.

 

have now linked the subreport, but when i run the report i get a blank block where the subreport data SHOULD be

 

 

i) linked by right clicking within main report and using the LINK tab, chose the correct field from the "available fields" and added to the fileds to link to box with the ' > ' button

 

ii) the sub report is in the "Details b" section of the report

 

hope that helps

 

thanks

Paul

 

have checked the select expert statement and it looks ok

table.field equal to ?pm-table.field

{tbl_serialNumbers.delvno} equal to ?pm_delv.delvno

ie the delvno on the Access SerialNumbers table must equate to the SQL table delv with the same delvno

 

thanks