Skip to Content
0
Feb 14, 2011 at 04:57 AM

Possible to programmatically create a command object?

103 Views

Hi all,

Is it possible to programmatically create a command object into an existing report? (Visual basic .net)

I would like to do so as a filtering mechanism.

The report is based on a database query.

I would like to create a command object and inner-join it to the query, and use the SQL of the command object to do the filtering.

I want to use a command as the filtering because the SQL comes from an application that has it's own filtering mechanism that builds up SQL. It may include database fields that are not necessarily part of the original report table (query)

Is it possible? Any ideas?

Many thanks,

Rod