Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
| Search | Today's Posts | Mark Forums Read
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 March 1st, 2006, 03:25 PM
Authorized User
 
Join Date: Mar 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Toggle/Drilldown help...please!!!

I want to be able to "toggle" [year] and then [month]:
I've got the toggle working perfect for [year].
I've got the grouping for month...sorta...meaning it's grouped the way I would like to see it with except that the subsequent data isn't showing. I'll try to demonstrate below

[u]How it is now:</u>
Column1 Column2 Column3 Column4 Column5
Title
Year(toggle)
                 Month Nothing shows in these 3 columns

[u]How I want it to work:</u>
Column1 Column2 Column3 Column4 Column5
Title
Year(toggle)
                 Month(toggle)
                                  Data Data Data

I've been working on this for 2 days...and I'm so ready to be finished w/ this!!!!
Please help.

 
Old March 2nd, 2006, 01:21 AM
Registered User
 
Join Date: Mar 2006
Location: Seattle, WA, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Adding another (3rd) detail row isn't doing it? I've done this, so I know it's do-able.

James

MCSD.MCDBA.MCT
 
Old March 3rd, 2006, 10:53 AM
Authorized User
 
Join Date: Mar 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I already did this...when I did nothing displayed in Columns 3-5 even though I have data tied to those columns.

 
Old March 3rd, 2006, 11:10 AM
Authorized User
 
Join Date: Mar 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think the reason nothing appears in 3-5 is b/c I'm grouping on Month in the previous detail line. Is there a way to have it grouped by Month on one detail line, and not grouped by anything on the next detail line?

 
Old March 24th, 2006, 04:11 PM
Authorized User
 
Join Date: Mar 2006
Location: , , .
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

the book solved my problem.





Similar Threads
Thread Thread Starter Forum Replies Last Post
DrillDown Crystal ReportsXI in .Net 2005 ArvindChilakalamarri Crystal Reports 0 November 24th, 2006 06:32 AM
Drilldown in SQL Reporting Service pat_seo Reporting Services 0 September 30th, 2006 02:15 AM
Is it possible to add a drilldown to a recursive h jeffwilson Reporting Services 2 March 2nd, 2006 01:18 AM
Toggle Key calvados VB.NET 2002/2003 Basics 2 December 17th, 2004 10:55 AM





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