Totals in a page

Hello
I have a report that has a page break at different product types and it works fine. I need to have the totals at the bottom of the page where the product type ends. I have set a field and put in a formula to sum the values but it sums the values for the entire report rather than that product type.

Can someone please suggest what I am doing wrong? or what I need to change

THanks
Sri


ddsrini (BOB member since 2004-06-23)

Is your total by chance placed in the PAGE footer?
I assume you are using Master/Detail sections for your Product Types? If so make sure that your total is in the Master/Detail footer (not in the page footer).


Andreas :de: (BOB member since 2002-06-20)

It’s difficult to put the totals in if you use the last block. If you use the 1st one, you need to put the “total” above the line for the next section.

If you are using breaks, I don’t know what to tell you.


Steve Krandel :us: (BOB member since 2002-06-25)

Sri,

Are you using breaks or sections? If you are using Breaks, then it would do the total at the end of the report for the entire report.
Do you want a total for each product type or once at the end of report?

kashif


Kashif Saeed :pakistan: (BOB member since 2004-06-02)

Break is use for Grouping .And you want Sum of all Product Type at the end of each page or at end of each group (page break).
Put you mouse over the Product type and then press Sum and see where this sum appears i think this will help you to get the Results.


hassan :pakistan: (BOB member since 2003-08-01)

Hello All
THanks for the input and the help. This is what I have.

I have a report which has two breaks. One for Region, One for Product Type. When I refresh the report everything works fine. For example if a region has two product types, then I get twp pages one for Region A and Product Type P1 and one for Region B and Product Type P2. NOw on each page I want to show totals of a measure related to that product type. For example if P1 total is 56 and P2 is 50, In the footer field when I did the sum, I get 106 on both pages.

Can some one please suggest something to get this to working the way I want it to

THanks


ddsrini (BOB member since 2004-06-23)

try evaluating the formula in its context.

Click on the cell which contains Sum(xx) and then then go to Data --> Define as variable

and there select evaluate formula in its conext.

Not sure whether this will work in your case or not but give it a try


JaiGupta (BOB member since 2002-09-12)

THanks Jai. I tried that but did not work


ddsrini (BOB member since 2004-06-23)

would it possible for you to send the report to me at jai_reb@yahoo.com


JaiGupta (BOB member since 2002-09-12)