Profit and Loss Statement in Crystal Reports
Posted on 2012-03-12
I'm trying to create a P&L statement in CR. We have approximately 40 GL accounts. Sometimes multiple GL accounts will be used to give a total for an account description on the P&L. For instance "Materials" may consist of "Purchases", "Inventory Variance" and "Raw Material" I created formulas that will total the account descriptions but now I'm not sure how do I display it on the report. If I put @Materials on the Details section and refresh the report, it will show zeros or empty spaces if I select to 'suppress if zero' on the report for each of the 40 GL accounts. All I want to see is just one line of information.