cancel
Showing results for 
Search instead for 
Did you mean: 

Question regarding Custom Running Total value on Group with same field

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Abhilash,

Basically what I need to do is to display a total for each account that starts with "1", then display another total for each account that starts with "2", then yet another one with "3", and after all that, a grand total of each totals.

abhilash_kumar
Active Contributor
0 Kudos

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

Former Member
0 Kudos

HI Abhilash,

This was helpful, but now I'm not able to see any Account ID or Account name on the report, tho I'm able to see what it seems to be a Summary.

Here are some screenshots for you.

Please advice.

abhilash_kumar
Active Contributor
0 Kudos

You'll need to drag and drop the 'Account ID' field on the details section for it to show up.

-Abhilash

Former Member
0 Kudos

That worked!

But the issue is, I had Account ID in a group, so I could order ascendent. If I place the data in details, i'm not able to sort by Account ID Ascendent, how can I do that ?:D

abhilash_kumar
Active Contributor
0 Kudos

Go to Report > Record Sort Expert > Add the Account ID field to the list.

-Abhilash

Former Member
0 Kudos

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!

abhilash_kumar
Active Contributor
0 Kudos

Hi Mathias,

Glad it worked!

Please post the new question you have as a separate discussion per SCN's rules and also to separate issues based on their solutions.

-Abhilash

Answers (0)