This isn't rocket science, I can do this with a script so DPA should also be able to do it! I have amended the standard report card (left most data source) and joined it with a list of clients found by looking at last backup (middle data source) which adds a field indicating it is a member of specific groups (beginning with zz) and at join a condition is applied to exclude (successfully) any client in any of these groups (they are not in production so no interest to our SLAs).
Next thing I want to do is filter the report card so only rows shown are those that have an error anytime during its time period (usually one week). Applying a filter does not work on rows in the report card, it works on rows in the table behind the report card, so if I filter only those with a failure what I get is the report card with only the failure days showing, the rest left blank. So I figure like removing the zz* group members I can create a list of clients which have failed in that period and use a join to filter out anything not in that list:
However it seems things don't work that way! Whatever data source I seem to use has some hidden time data which leaves only one column of data after the join. I have tried several data sources and time settings without effect!
I'm sure I am not the first person who has wanted to apply a filter to a report card, I was hoping somebody has been able to successfully do this and point me in the right direction.
Script provides us with some powerful tools and commands in our hands, so it's obvious that we can achieve more via scripts than some mouse clicks. I think the data tables you have taken have some sort of priority issues in their fields. It should show you field since the priority is not limited to high. But, just in case it is not showing the required data, you might as well try to do the trick with similar data tables, and notice the output. It might help you understand what's happening here.
But EMC have sold us DPA as a solution to make our reporting easier, more reliable, more accurate and more easy to maintain! How can it be when you have to carry out hugely complex procedures to carry out relatively simple tasks?
From the description you have provided, I am assuming you are after a Report Card that will highlight the clients that have failed jobs in the last week and you want both the successful and failed jobs to show in the report.
I was running into the same issue as we wanted to just show a report card with clients that failed over the last week.
What I did find is the following discussion that shows how to create a Standard Query which helped create the Report Card we are looking at.
Hopefully this will help you out with what you are after.