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

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>

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Oct 18, 2006 at 06:18 AM

    <p>hello,</p><p>there is now a budget report in the Financial folder for xi & xir2.</p><p>C:\Program Files\Business Objects\Crystal Reports 11.5\Samples\en\Reports\Financial</p><p>this does not use a crosstab but uses a mock crosstab approach which is easier for making a lot of comparitive formulae.</p><p>jamie</p>

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks JamieÂ

      I wish there was a way to deduct to the displayed values from each other. Or take the sum of records from the maxinum of the group number variable to get the variance. I will look into those articles you recommeneded.

      Seán

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.