I have a cross-tab report where for the row values I have error names, and the columns are each day w/in whatever date range is entered into the prompt.
The problem is that the report will only show the error names that have been used within that particular date range, and I need to show the entire list/table of errors (without having to enter a date range covering the existence of the error field), even if its values are zero across the board. Using only Web Intelligence (XI R2) with no back-end/universe access, is there a way I can accomplish this?
For some reason that’s not working… I probably should have specified that I’m using a variable (as opposed to an actual ‘field’/object), but I’m not sure why that would affect the outcome, assuming that’s a part of the problem… :?
The variable is the object I’m trying to get the full list of. To be frank – it’s a mess. There were some variations of the error name in the beginning (this is a relatively new database I’m working with), so I had to create a variable to account for/combine the different variations of the same error (e.g., an error that said simply “Name” in a previous version now says “failed to verify name”, etc.)… I don’t want to return the old errors in the list, but the newer name including the counts of that older version.