Interesting Report Creation Question (or at least its interesting to me)
I'm trying to figure out how to create the following report:
For example:
There are a total of 10 PCCs in the entire system. The PCCs are scheduled for various start and stop dates/times.
Lets say I specify a date range of Jan 6 and Jan 7. What I would expect the report to show me is all PCCs above except 2, 5 and 10, as those have scheduled start and/or schedule end dates outside of the date range of Jan 6 and Jan 7.
The goal of this report is to be able to show a holistic view of all changes that have been approved for implementation on or during a specific date (or date range) AND to be able see any other changes that are aiming to take place on or during this time range as well. It does not necessarily matter what state/status they are in but more importantly to be able to see them all. Well ok, maybe i don't need to see cancelled changes or completed changes....
I hope the above makes sense. Please help. Happy to share any additional information or clarify any additional requirements
Thanks in advance
Brian
Show all changes submitted or approved that take place on OR during a specific date (or date range)
For example:
There are a total of 10 PCCs in the entire system. The PCCs are scheduled for various start and stop dates/times.
PCC Start End
PCC 1 : Jan 1 Jan 7
PCC 2 : Jan 9 Jan 17
PCC 3 : Jan 1 Jan 23
PCC 4 : Jan 6 Jan 6
PCC 5 : Jan 12 Feb 02
PCC 6 : Jan 6 Jan 23
PCC 7 : Jan 6 Jan 6
PCC 8 : Jan 3 Jan 11
PCC 9 : Jan 6 Jan 7
PCC 10: Jan 4 Jan 5
Lets say I specify a date range of Jan 6 and Jan 7. What I would expect the report to show me is all PCCs above except 2, 5 and 10, as those have scheduled start and/or schedule end dates outside of the date range of Jan 6 and Jan 7.
The goal of this report is to be able to show a holistic view of all changes that have been approved for implementation on or during a specific date (or date range) AND to be able see any other changes that are aiming to take place on or during this time range as well. It does not necessarily matter what state/status they are in but more importantly to be able to see them all. Well ok, maybe i don't need to see cancelled changes or completed changes....
I hope the above makes sense. Please help. Happy to share any additional information or clarify any additional requirements
Thanks in advance
Brian