Thanks for your reply, I still don’t understand, I thought you had to use portal.
What I have is a customer site that has a number of products that are made up using various fields as each product contains size, type, location exc. The products are linked to site by site ID each product has its on ID so and is permanently attached to one site, I need to be able to print service sheets for each month that will include several sites and each report will contain products that my be only one on site or may run in to hundreds.
So I need to list the products for each site showing all the information of each product, site address exc.
What would you suggest please.