Skip to Content
Former Member
Oct 25, 2006 at 01:58 AM

Budget Variance


<p>This question was in the Developer forum. Can somebody over here in report design help? </p><p>I am trying to design a a budget report using cross tabs. Our company likes the layout of them. I have beed led to believe that this budget report could be beyond the capability of Crystal Reports. I do not want to use mock cross tabs. It would just be easier to export the report to Excel. The issue is as follows:</p> <p>For example, I have 3 accounts. They are Computer Expenditures, Stationary and Sundries. I have grouped them in the database as Office Supplies. The sum is displaying correctly in the cross tab. The total for January is 1,000. I then create the Budget amount for the office supplies using a number variable. I use the running total expert to Evaluate for each department and to reset for each month or period. The total displays correctly. The total for Dept A & B is $800. I can&#39;t get the difference of $200. The report is as follows:</p> <p> <strong>January</strong> </p> <p>Office Supplies 1,000 (records database)</p> <p> 800 (Budget Amt)</p> <p>How do I get the difference of $200 for this cross tab? What the report does is it takes the difference for each record or row and then sums it. I want to take away the the sum of these records. Has anyone got a solution for this issue. </p>