?
Solved

SSRS:  How to Toggle

Posted on 2013-12-19
7
Medium Priority
?
915 Views
Last Modified: 2013-12-20
Hello:

Attached is a SQL 2008 SSRS report.  Attached is a screenshot of how it appears when I run it.

I want a toggle plus sign to the left of the first dollar figure in the screenshot.  And, when collapsed, I only want one column to show.  When expanded, I want the other columns to show, of course.

How do I make this happen?  Whenever I try to use the toggle feature of SSRS, I seem to always get a cryptic error.  I'm surprised that the process is not as simple as it looks.

Thanks!

TBSupport
toggle.docx
POOR-RCG-PastDue-Detail-Subrepor.rdl
0
Comment
Question by:TBSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 8

Expert Comment

by:vr6r
ID: 39729826
In your row groups section, right click "(table1_Details_Group)", select Group Properties, Visibility and set the following options:

When the report is initially run: Hide
Display can be toggled by this report item: Checked, and select "PastDue1" from dropdown

I can't really test this without your data source, but that should be all you need to do.  Attached file has these changes made already.
POOR-RCG-PastDue-Detail-Subrepor.rdl
0
 
LVL 1

Author Comment

by:TBSupport
ID: 39729888
That's close.  Attached is a new screenshot.

But, I want it collapsed to where I only see that first dollar figure.  Then, upon hitting the plus sign, I want to see the expanded data (i.e. the other columns).

Thanks, for the quick response!

TBSupport
toggle2.docx
0
 
LVL 8

Expert Comment

by:vr6r
ID: 39730271
Try this one, this should do it by moving the detail rows below the heading total.  SSRS seems to have trouble showing/hiding detail rows if they are on the same row as the parent group, even though the visibility setting is defined that way.  Again, wasn't really able to preview/test - but this should be the most direct way to get what you want.
POOR-RCG-PastDue-Detail-Subrepor.rdl
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 1

Author Comment

by:TBSupport
ID: 39730375
vr6r:

Can you send me instructions of what you did, instead?

Thanks!

TBSupport
0
 
LVL 8

Accepted Solution

by:
vr6r earned 2000 total points
ID: 39730447
Sure thing...

Just right click the "[PastDue]" cell (the 2nd column cell, not the sum column) and select "Insert Row" -> "Outside Group - Above"

That brings your detail group 1 row below the parent group, which should eliminate the conflict from hiding/showing groups mixed on a single row.
0
 
LVL 1

Author Comment

by:TBSupport
ID: 39730504
Unfortunately, when I do that, I get what is shown in the attached screenshot.

What am I doing wrong?

TBSupport
toggle3.docx
0
 
LVL 8

Expert Comment

by:vr6r
ID: 39730616
Could you send a screenshot of your design view of the report?
Also, have you tried running the last file that I attached? (just to confirm that it generates the report they way you want)

With these types of edits SSRS is very picky about the layout of the rows.  For example in the steps I mentioned before, selecting "Inside Group - Above" will behave very differently than "Outside Group - Above"
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

752 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