Possible to create a Trend report plotting the changes of a RTC custom integer field over time ?
![]()
We have a RTC custom work item type ('Project_Information') which contains a custom integer field ('Project_Spent_Budget').
Using a Reporting tool (not BIRT, not RRDI, not Insight) which accesses the RTC databases directly (RTC and DW), we want to create a Report which plots the trend/changes of the Project_Spent_Budget field over time.
So this Report needs to access each 'Project_Spent_Budget' field change, and plot a Report as per picture below.
Is this possible ?
If Y, which exact DB table(s) should we look at to capture all the Project_Spent_Budget changes (date of change and new value) ?
Thanks
![]() |
One answer
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.