Filter Report

Home Forum General Filter Report

Tagged: ,

This topic contains 4 replies, has 0 voices, and was last updated by  Anonymous 5 years, 11 months ago.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #429

    Anonymous

    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.

    #5107

    ijobling
    Participant

    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

    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

    #6338

    evelina.liu
    Participant

    Hi, 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!

    #6340

    I 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.

    Workflow software, Process software, Procedure software

    #6341

    evelina.liu
    Participant

    Thank you Dennis. Is it possible to include this functionality in future release, so that we can design reports with more extensive functionaity. Thank you.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.