on 09-19-2014 3:49 PM
Hi All,
I'm new with using Crystal report, and I'm not sure how to do this, so please help me
Basically, I have a report more or less like this:
Account Accountname Salary1 Salary2
100000 Example 3 4
100001 Example2 4 5
....
...
....
Total:
200000 Example3 5 7
.....
....
....
Total:
300000
What I need to do, is to add the Total field for Salary 1 and Salary 2 right after the account ID is 200000, and then another field right after the 3000000.
How can I do this?
Thanks!
Hi Mathias,
Could you also post a mock-up of expected results?
So, you don't want to show the 'summary' for the '1000x' accounts?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK. Try this please:
1) Create a formula with this code:
Totext({Accoount_ID})[1];
2) Go to the Group Expert > Add this formula field to the top of the group list
3) Go to Insert Summary > Choose the 'Salary 1' field as the Field to Summarize > Choose Sum > Under 'Summary Location' choose > Add to all group levels.
4) Repeat Step 3 for 'Salary 2'
5) Suppress Group Header #1
-Abhilash
Thanks!
Can I ask you another quick question? If I want to add a Group Header that says like "Acc 1" and list all 1, then another title but when it starts printing Accounts 2, for example:
Account 1
111111
111121
111112
subtotal:
Account 2
222222
22222
2222
subtotal
At the moment, I'm able to see the accounts and subtotals, but I want to add title on top of each accounts once they appear.
Thanks!
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.