Sum of Group in Crystal report for vs 2015

Hi,
For display of heirarchies, you can  create groupings on account, supplier and currency in that order.
You can create 3 running totals one each for each currency and place it in report footer for sum of currency values.

Simply insert a CrossTab. It allows you to show summaries grouped in any desired way.

Are the currency values in a single field?

It looks like you have a group on the account and want the currency totals in the account group footer.
In that case it can be done with a simple cross tab with the currency as the row and the account as the column.
If you have multiple currency columns then the running totals or another summary will work better.

How many currencies are there?

mlmcc

to be more clear  i need the below:
AccountParent1 (ex :4)
       account1 (ex :41)
                  Supplier1   Currency1    10
                                     Currency2     20
                  Supplier2   Currency 1    30
                                     Currency 3     40
       (here, for account 1 i need that result :     currency1   40(10 + 30)
                                                                             currency2  20
                                                                             currency 3 40)
      account2 (ex :42)
                 supplier1          currency 1   30
                 supplier2          currency2     50

       (here, for account 2 i need that result :    currency1   30
                                                                           currency2  50)

(here i need total for accounts(accounts1 + account2)  that exists under accountParent1
currency 1 70
currency 2 70
currency 3) 40

(which means i need to total total for all parent of a node
4 (here i need total for account4)
 41 (here i need total for account41)
    411(here i need total for account411)
and so one.
any help would be appreciated

IS your data like
Account   CurrencyType   amount
42                Currency 1            30
42                Currency 3            50

or

Account         Currency1             Currency2             currency3
42                        30                             0                          50

mlmcc

my  data is like
42 currency 1 30
42 currency 3 50

yes this is what i want but i need to know how can i customize the cross tab report  in example please check attached details
(where i need debit in the details of teh crystal report to be aligned with debit in cross tab report)
Please advise
design-crystal-report.png
execute-crystal-report.png

There is no easy way.  You can try to use the vertical alignment guidelines to align the right sides.  You can make both the invoice debit and the cross tab cell the same width.

mlmcc

ok i will try as nuch as i can to align columns , but what about reducing the height of cross tab report.please refer to the attached document.
crystal-report1.png

ok but in attached file you can see that in the cross tabl report there is a first row , second row and third row where only second row is visible why in preview mode the cross tab is taking its normal heght as it contain 3 rows
crystal-report1.png
crystal-report2.png

Well, unless we see report with some sample data, it's difficult to say which column is making the height of crosstab to increase. I think the first row in the screenshot you shown may not be part of crosstab as that only contains column separator lines. Correct me if I am wrong.

yes you are right

in the attached crystal report , i have a cross tab report with 2 lines:
LL 0.00
US 1.75
i need to make unvisible values 0 or negative
i need the result in cross tab report to be
LL
US 1.75
how to do that?
any hint
crystal-report1.png

THANK YOU /mrS. mlmcc AND  Raghavendra Hullur
FOR YOUR HELPFUL ANSWERS

Hi,
I would say you give credit to the experts for their effort by selecting most relevant one as best answer and any other as helpful answers.

thank you all