Is there a way to suppress rows and columns in a cross tab report in the Web Reports?
Summary:
I needed to build a cross tab report fetching all records with Cancellations in horizontal order.
Shipments could be associated to multiple order lines. I only need to select and display the shipments where all associated order lines are cancelled. So If there are other lines that are shipped, the report should not select that shipment.
Content (please ensure you mask any confidential information):
Based on the data on the screenshot, only shipment 64001 should be the only one to be displayed because all order lines associated to that shipment had been cancelled.
Version (include the version you are using, if applicable):