Dynamically building record selection formula

[vbadmin]

I want to use VB 6 to dynamically build a query string then pass that into the record selection function that CR 9 provides but it doesn't allow me to do this. The reason I want to build the entire query string first is so the user can select mulitple filter categories and multiple options within each of those categories instead of just being able to select only one option in each of the categories at a time. Hope this makes sense. Does any one have any ideas or examples on how to do this?

 

[vidru]

Have a look at this thread: thread768-700289. It outlines the steps for setting up a report to receive a recordset as its data source.

You can also check out this sample app:

http://support.businessobjects.com/communityCS/FilesAndUpdates/ado_connectionmethods.zip.asp

-dave