I don't think this is possible, but at this point my report has the data formated in the way I need to, I guess, create the report I want.
The data in the report is grouped by SectionID. In each SectionID, there are numerous documents (docID). Each document has a numeric status code(Code). In my report I have a footer for the SectionID grouping that displays the status code of the last document. If the code is 3, then I have a condition that makes the text red and bold. If it's not code 3, then the font is normal, as I don't really need to look at it.
Now they are asking for a report of just the code 3 documents, but it's not as simple as that. The reason I did the above grouping and footer flag of the last document is that they only care if the last document of the section has a code 3 status. So basically, I guess I need to simulate what I did in the report in a query, then get a report of the last documents of the sections if the code status is 3... Hope I made that clear enough...
Bookmarks