Skip to Content
Former Member
Oct 18, 2006 at 04:43 AM

Budget Report


<p><font face="Times New Roman" size="3">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:</font></p><p><font face="Times New Roman" size="3">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:</font></p><p><font face="Times New Roman" size="3"> <strong>January</strong> </font></p><p><font face="Times New Roman" size="3">Office Supplies 1,000 (records database)</font></p><p><font face="Times New Roman" size="3"> 800 (Budget Amt)</font></p><p><font face="Times New Roman" size="3">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. </font></p><font face="Times New Roman" size="3"> </font>