Hi,
I have a form with 3 fields.There are ID,Department and Divion.Within a department there are more than one divisons.
Now i want to build a report on this form.First i want to filter Department and then on the basis of department selected,i want to see divions within that department and at the end i have data grid which will show me the IDs for all employee for that division selected.
How can this be done.What i have done is that im able to create a single filter on the Division but i want department to be filter first and then divison.
Another thing.......Can i create a report on open instances of any form or it has to be in its closed state.
Thnx.
