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
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).
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.
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?
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.
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