Details Return true

[Former Member]

Hello guys,

I am still a newbie in crystal report and trying to learn from the existing reports for SAP in our company. Recently, I am trying to edit our sales invoice for getting the right computation.

So I got this result.

What I wanted to have is, when the condition for Vatgrp = 'TRUE' then I will get the summary of the stocksum that returns true on vatgrp.

ex:

Description: crabstick surimi 33% 8cm L VP 10x500gms

1,237.50 must be the result for the total sale(vat inclusive) since vatgrp = 'TRUE'

Is is possible to get it without making effect on details? I want stocksum to be placed on the report footer particularly on TOTAL SALE(Vat inclusive). Thank you so much for your help.

Regards,

JZA

[abhilash_kumar · Accepted solution]

Hi Ramoncito,

Yes, just create a formula with this code:

If vatgrp = "True" then

     {StockSum}

Then, go to the 'Insert Summary' option > Select the formula field above from the 'Field to Summarize' drop-down > Choose 'Sum' as the Summary > Place the summary on the Report Footer (Grand Total).

-Abhilash

[Former Member · Accepted solution]

Thank you sir. Actually the value for true is alternate to OUTPUT for vatgrp field. I replaced it and then I got the summary result. Thank you so much for your help.

Best Regards,

JZA