Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 18th, 2006, 01:34 PM
Registered User
Join Date: Apr 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Queries on Matrix Control

Hi All,

I had developed some reports using Matrix Control. The report came well.
The reason we go for Matrix reports are to have dynamic rows and columns. I have few requirements/doubts on Matrix Control...

Lets have an example here...

I have report, row section grouped by "Level", "sub-level" & "count(employees)". Column section i have "Roles" and In detail section i have "sum(salary)".

1. I want to have header for all the columns (Level,sub-level, count). Is it possible?
2. I want interactive sort on all the above columns. (If first question is possible then this is also possible)
3. When i use "Subtotal" for the column "Level", then the bottom of the report, RS have a overall total for "sum(salary)". But i want the "sum(count)" as well along with "sum(salary)". Is it possible?

Please answer, if anyone knows?

Thanks in advance!:)


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone know a good matrix control? Aaron Edwards ASP.NET 2.0 Basics 4 April 9th, 2007 11:05 PM
Queries On File Field Html Control in ASP.NET 1.1 daffodils ASP.NET 1.0 and 1.1 Basics 1 October 30th, 2006 11:30 AM
Combining Queries or results from 2 queries Ford SQL Server 2000 24 November 7th, 2005 08:54 PM
Page headers with Subreport and Matrix control runlevel007 BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 April 20th, 2005 04:16 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.