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.