[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1982
  • Last Modified:

How can I display Subtotals by page on a RDLC report in Sql Reporting Services?

I want to show the whole total and then the subtotal of the current page at the end of each page, I have the whole total, but the subtotal I just can't do it.

Please help.
0
aisinfo
Asked:
aisinfo
  • 4
  • 3
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
Since no one else has jumped in yet, let me suggest trying querying WITH ROLLUP.  It will give you subtotal and total by your query groupings.

http://aspnet.4guysfromrolla.com/articles/073003-1.aspx
0
 
aisinfoAuthor Commented:
Thanks for your suggestion mwvisa1, but what I need is a subtotal per page, I dump all the data into the report and on the table footer do a SUM to get the total, how do I get the subtotal of each page of the report?
0
 
Kevin CrossChief Technology OfficerCommented:
I am not an expert on SQL Reporting, so offering help with SQL Server and .NET best I can.

You can also leave query as is and use .NET to calculate the totals and subtotal.  Here is an example method that captures Item Data Bound of grid to get totals.  Since you mentioned current page, I would suspect you have pagechange code you can hook onto -- basically have two variables that act like running total but one gets 0'd on page change. :)

http://www.dotnetjunkies.com/Tutorial/2F527E21-A6C5-497A-8B56-4150BDAF711D.dcik
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
aisinfoAuthor Commented:
The problem I have is not on the ASP.NET code, I have all that, I use LINQ to get everything I need on the ASP.NET side. on the .RDLC report is my problem.
0
 
Kevin CrossChief Technology OfficerCommented:
Here is article for SQL Reporting Services.  As I said, I have not used a great deal yet.  I wish I had, but application was stuck on other reporting...can't wait to re-install with SQL 2008 end of this year. :)

http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-1/
0
 
Kevin CrossChief Technology OfficerCommented:
Sorry was thinking through steps to provide you with what you needed since I was just taking a stab for you since no one else responded yet.  Figured you wanted SQL Reporting Services. :)

Anyway, everything I have read suggests that you can create subtotals by just right-clicking and picking option from context menu.  They talk about formatting subtotals there and so hopefully you get enough information on creating them in the first place too. :)
0
 
aisinfoAuthor Commented:
Thanks a lot man, at least I got some info!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now