July 18, 2011 at 2:43 pm
I have created a query that pulls a lot of opportunity data for a specific company. In SSRS 2008, I have formatted it so that when it exports to Excel, this information is broken down by month with each Month's data summarized in the appropriately named tab.
My problem is this: in the SSRS design, I have a bottom row that summarizes all of the financial data I am pulling in through query. However when I export to excel, the sum function is not breaking by month, rather on the last tab I have one row where the sum of the entire previous months' data is summed.
What I want is so that when I export to excel, the sum of each page, or in other words a summary of each month, is the last row of the sheet. Instead what I am getting is a total sum of all data I am pulling in this field.
Is there a way to break this up in the design so when I export to excel my totals (sums) appropriately sum the grouped by month data on each tab?
I appreciate any input on this it is causing me endless hours of frustration
July 19, 2011 at 5:35 am
Usually when exporting to Excel, new tabs are created whenever you create a hard page break in the report typically in between groups. If you chose this route and have a grouping by month in the report, then you should just need to create a group footer with your SUM function and it will total up values by month and show them on the appropriate tab.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply