Query Filters

[Freefall27]

I am using Crystal XI and getting data through an ODBC connection to Oracle DB.

This is the SQL equivalent in Access of what I want to do in Crystal.

select circ_path_hum_id, status, bandwidth, A_side_site_name, Z_side_site_name, ELEM_COST from path_view
where circ_path_inst_id not in ( Select distinct c.circ_path_inst_id from circ_path_element c, circ_path_inst c1
where c.circ_path_inst_id = c1.circ_path_inst_id
and c1.bandwidth = 'TRUNK GROUP'
and c.element_Type = 'P')
and bandwidth = 'TRUNK GROUP'


I need help on how to have a select query in the filter section while building crystal report.

Your help is greatly appreciated

 

[lbass]

Try copying your query into a command and use that as your datasource (database->database expert->your datasource->add command).

-LB