Item Status Reporting Hot

by Jimmy Scott on December 12, 2016

Create a report type that allows view of items over a range and their change in status.
Example: I should be able to run a report that displays currently active items, and what that (defined on the report) status field was a week ago.
In place of Status, some users may wish it to reflect State, or other on-form field similar to the tabular reports.

  •  

    Item# Owner Description Priority Last Modified Previous/Current Week Active Pending Review Approved Developement Testing Peer Review Pending Implementation Implemented
    1234 Jack  .............. HIGH 11/15/2016 Previous Week Y Y            
    Current week Y     Y        
    3456 Jill .............. LOW 12/12/2016 Previous Week N              
    Current week Y   Y          
    1234 Jim  .............. Medium 12/12/2016 Previous Week Y       Y      
    Current week N             Y

    A report such as shown above would allow a quick point in time assessment of ongoing work and where in its lifecycle it may fall. Note that when the user run this report, it would display any items that were active in that report window, not just thos active presently.

  • Please login to view any attachments.

  • Have you tried to create this report using Advanced Reporting - first introduced in SBM 11.0?
    David J. Easter Commented by David J. Easter December 19, 2016
    #1 Reviewer  -  

    Have you tried to create this report using Advanced Reporting - first introduced in SBM 11.0?

    The third item should have been a unique item number.
    The report should also allow a user to identify the interval from Day, Week, or Monthly views.
    Jimmy Scott Commented by Jimmy Scott December 12, 2016
    Top 50 Reviewer  -  

    The third item should have been a unique item number.
    The report should also allow a user to identify the interval from Day, Week, or Monthly views.

     

Print