Details Return true
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.
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.
Abhilash Kumar replied
Yes, just create a formula with this code:
If vatgrp = "True" then
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).