- June 20, 2012 at 10:46 am #1029
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.
RichJune 20, 2012 at 3:42 pm #6157
Dennis @ PerfectFormsBlocked
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.June 25, 2012 at 9:37 am #6160
Many thanks Dennis – I think I follow you. I’ll give it a go.
You must be logged in to reply to this topic.