Solved

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

Posted on 2008-10-09
7
1,889 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 59

Expert Comment

by:Kevin Cross
Comment Utility
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
Comment Utility
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 59

Expert Comment

by:Kevin Cross
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 

Author Comment

by:aisinfo
Comment Utility
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 59

Expert Comment

by:Kevin Cross
Comment Utility
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 59

Accepted Solution

by:
Kevin Cross earned 500 total points
Comment Utility
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
Comment Utility
Thanks a lot man, at least I got some info!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now