Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying groups that contain negative detail lines

I have a report that displays sales transactions. The report is grouped by transaction id. I need to only display the transaction group that contains a negative transaction (neg quantity or neg price); showing both neg and pos transactions for that group. This report is based off Access tables.

Former Member
Former Member replied

David,

The easiest way to do this would be to build a query in Access that provides this for you. You can do it easily using a two query approach.

QueryNo1:

SELECT
TransactionTable.TransactionID
FROM TransactionTable
WHERE TransactionTable.Price < 0 OR TransactionTable.Quantity < 0

QueryNo2:

SELECT *
FROM TransactionTable
WHERE TransactionTable.TransactionID IN [QueryNo1.TransactionID]

This will give you all of the TransactionID's that have a negative transaction associated with it.

Once you have the query completed to your satisfaction and saved, you can use it as your data source in CR. CR will see it as a View. If you make it a parameter query, CR will see it as a Stored Procedure.

Hope this helps,

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question