Okay, let's try this again. Frustration level has come down to a 7.
I am creating a report using an ODBC link to Remedy ARSystem, which actually has another connect to DB2 for part of data which really does not affect the data I use. I have a parameter value to get records for specific dates. The report is broken down by regions (assigned, pending, resolved, etc.) these are count with a total under the heading of each region. Works great. Now manager wants filter even more, but still wants the counts. For example CST Eastern should be added to Eastern Office. He does not want to see CST on the report. These are some of the things I have tried: SELECT, Case, IF statements, nothing seems to work.
I am creating a report using an ODBC link to Remedy ARSystem, which actually has another connect to DB2 for part of data which really does not affect the data I use. I have a parameter value to get records for specific dates. The report is broken down by regions (assigned, pending, resolved, etc.) these are count with a total under the heading of each region. Works great. Now manager wants filter even more, but still wants the counts. For example CST Eastern should be added to Eastern Office. He does not want to see CST on the report. These are some of the things I have tried: SELECT, Case, IF statements, nothing seems to work.