on 10-25-2006 2:58 AM
<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'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>
<p>if you check out the crosstab samples at</p><p><a href="/node/901">http://diamond.businessobjects.com/node/901</a></p><p>you will get an idea of how to display any number in a crosstab...there's an example of a quarterly growth in one of the samples that will help with your question.</p><p>jamie</p>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.