Result row when condition is active

[Former Member]

Hello gurus,

I have created a condition in my report and the result row does not reflect the rows displayed when condition is active. Is it possible to get a result which is the total of rows displayed when condition is active ?

Thanks in advance,

Vanina

[former_member188975 · Accepted solution]

Hi Vanina,

When you apply a condition it affects only the details rows, the results rows are not affected and they show the values resulting from the report, without the condition. As a work around, you can create a replacement path query (prequery with the condition) and then feed the main query with the results of the replacement path query. This way your condition is applied and also the result row gives correct values.

Hope this helps...

[Former Member · Accepted solution]

Thanks for your answer. I have never created a replacement path query, may I ask you how to proceed ?

Best regards,

Vanina

[former_member188975 · Accepted solution]

Hi Vanina,

You can go through the steps here:

http://help.sap.com/saphelp_nw04/helpdata/en/2c/78a03c1178ad2ce10000000a114084/content.htm

Basically you have 2 queries that are linked by a replacement path variable. This will carry the results (char values) of the pre-query to the resultset (final) query.

Hope this helps...