I have built a VB6.0 datareport in my Vb6.0 app. I designed the report using an entry (PriceSheet) in the dataenvironment. PriceSheet had all of the fields that I needed on the report and the report looks good. It shows a price list of every item for every client. However when the user requests the report in the app I want to give them the ability to filter the output based on client and/or itemid. For example if they select clientid 10 I only want to show the prices for the items of client 10. if they also select item12 I only want to show the item 12 for client 10 etc.
I know how to build a where clause based on the user selections but I'm not clear on how to apply a 'filter' or where clause to and entry in the dataenvironment using code so that the report only shows the clients and items that the user wants to see.
How can this be done.