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.
Form instances do not have to be in the closed stage to be reported on.
as to how to filter your data, there are many ways you can do this depending on your requirements. refer to the user guide to see all the options (use the SEARCH tab and enter in ‘filter’ for instance) to determine which approach is suitable for your needs
I have a question regarding filter. In the event of “Data Grid is shown” from the report, if what I need is to set filter with “OR” condition from a few fields(“outer-join” in SQL sense), instead of “AND” condition, how should I do that?