?
Solved

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

Posted on 2008-10-09
7
Medium Priority
?
2,001 Views
Last Modified: 2013-11-08
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
Comment
Question by:aisinfo
  • 4
  • 3
7 Comments
 
LVL 61

Expert Comment

by:Kevin Cross
ID: 22690291
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
 

Author Comment

by:aisinfo
ID: 22690319
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
 
LVL 61

Expert Comment

by:Kevin Cross
ID: 22690328
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:aisinfo
ID: 22690346
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
 
LVL 61

Expert Comment

by:Kevin Cross
ID: 22690359
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
 
LVL 61

Accepted Solution

by:
Kevin Cross earned 2000 total points
ID: 22690384
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
 

Author Closing Comment

by:aisinfo
ID: 31504840
Thanks a lot man, at least I got some info!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question