Skip to Content
author's profile photo Former Member
Former Member

Budget Variance

<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>

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 25, 2006 at 01:59 AM

    I have posted this question to the Report Design forum. I think you might have better luck there.

    See my post:

    Rob Horne
    Rob's blog ->

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.