Skip to Content
avatar image
Former Member

How to display a subtotal on a report footer ?

Hello

  I have a report that has

report header

page header

Group header #1 a, on this (group header # 1a) it's grouping by a customer no and on this group i have a formula which has some text(it's a letter) and I display the letter then below the letter I have

Group Header #2 a. where I display one line that has an address information then

Group Header #2 b. this has the header information things like, invoice_no,invoice_date,amount, currency. then

Group Header #3. this has the currency(no show) then

Group Header #4. this display the currency code either, USD or CHF or EUR then below this is

the Details : this has the detail of what is on Group Header #2 b, the, invoice_no,invoice_date,amount,currency then I have

Group footer #4

Group footer #3: this is the currency where I have a total by currency

Group footer #2

Group footer #1 : this is the customer no


Now the question, how can I display a summary of all subtotals at the button of the report, most of the time I will have 2 types of currency on the report per customer.

    I want display  a summary for both , for example

       

        Total in USD is :

        Total in EUR is :

        Total in CHF is :

  

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 31, 2015 at 08:44 AM

    Hi Alpha,

    Insert a Crosstab and place it on the Report Footer.

    Use the Currency field as the 'Row' and the field you wish to summarize under 'Field to summarize'.

    You can then 'format' the crosstab if you do not wish to see Gridlines et al. This is customized by going to the Crosstab Expert > Customize tab.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2015 at 01:08 PM

    ......  or you could use 3 formula fields in the page footer.      This gives you the added ability to do the currency conversion in the formula if needed, and to be able to use another formula to suppress the field for those instances where you only want to display 2 of the 3 different currency's.   

    Ted

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ted

      Could you see my update above, I tried using formulas but I am returning the total for one currency only not the others, what am I missing on the formula. Thank you guys for your help