How to remove Primary Key Fields from Report?
I'm using a VENDOR_ID as a GROUP BY variable in a report for totals so I seem to have to included it in the fields I want on the report in the first step of setting up a report. Otherwise, this field isn't available to use in the group by dialog part of setting up a report.
So, my question is, now that I have the report how do I get this VENDOR_ID field to not display? Nobody will care about the VENDOR_ID field.
I've tried removing it from the report, but then the report stops working as expected.
I'm sure this is simple, but I'm missing something.