This topic contains 4 replies, has 0 voices, and was last updated by 
- AuthorPosts
- March 2, 2010 at 1:13 pm #429
AnonymousHi,
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.
March 2, 2010 at 2:05 pm #5107Form 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
http://www.perfectforms.com/Documentation/manual/html/index.html?adding_a_filter_selector.htm
http://www.perfectforms.com/Documentation/manual/html/index.html?adding_a_filter_input.htm
http://www.perfectforms.com/Documentation/manual/html/index.html?drill_down.htm
December 6, 2012 at 4:53 pm #6338Hi, Dennis,
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?
Thank you!
December 6, 2012 at 6:49 pm #6340I don’t have a method of filtering a source by OR. The Set Filter object (and all other objects that set dynamic filter) filter by a single metric.
December 6, 2012 at 7:24 pm #6341Thank you Dennis. Is it possible to include this functionality in future release, so that we can design reports with more extensive functionaity. Thank you.
- AuthorPosts
You must be logged in to reply to this topic.