I solve the issue with a workaround clumsy but it works.
I used the data assist module to create search and results pages of the products table.
Then deleted all visisble code except the button on the search page. changed the button to say "show stock list"
Now if the button is pressed the complete stick shows on the results page and can be printed using the normal mprint button.
No doubt there is a better way but it works for me