Skip to Content
0
Former Member
Feb 27, 2011 at 01:43 PM

Filter query with sub query using Dropdown box

46 Views

Dear Community,

I have 2 queries

1. Main Query with 2 fields: Project | Project value

2. Sub Query with 2 fields: Project group | Project

Project group can be belonging to number of projects and project can be belong to number of project group (Many to Many).

My customer wants the main query will open without any filtering.

When I choose project group from WAD dropdown box, the main query will filtering all the projects that belong to the project group.

I create WAD; define dropdown box as sub query, and Analysis as main query.

In the dropdown box I choose "data binding" char and create command "set selection state by binding" (project to project) but it doesnu2019t work.

I also try to do this by Replacement Path in the main query, but the variable requires the attribute will be ready for input.

Thanks a lot

Yaniv