Displaying time spent on current stage

Home Forum Reporting Displaying time spent on current stage

This topic contains 2 replies, has 0 voices, and was last updated by  Valisk 6 years, 5 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #1029

    Valisk
    Participant

    Hi there!

    I have a report that displays time spent on each stage. As the request progresses the form records the time spent on each stage and I diplay this on a report using a data grid.

    Is there a way to display the time that a request has been awaiting action on its current stage? i.e. Date report opened – Last approval date.

    Cheers,

    Rich

    #6157

    The reporting objects in a PerfectForms report cannot be used in behaviors. For this reason the approach will have to be a little different. Create a connection to your subject form. In the action have at least your date field and some identifying field. Place a table in your report with three columns (identifying field, date, and days since last result). When the report opens populate the first two columns of the table – all rows with the form connection. Next create a behavior that loops through the table and at each row uses a Set Field object with a Date Difference function to set the Result column – current row with the difference between the date column – current row and today’s date.

    Unfortunately the table is not a standard reporting object so it will not set or respect the dynamic inputs of other reporting objects. You can however create a behavior to filter your table by specific parameters.

    Workflow software, Process software, Procedure software

    #6160

    Valisk
    Participant

    Many thanks Dennis – I think I follow you. I’ll give it a go.

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

You must be logged in to reply to this topic.