Enabling Drill Down in "Report Server Project" instead doing in the "WIZARD"

Question

Enabling Drill Down in "Report Server Project" instead doing in the "WIZARD"

devammehta

Right there with Babe

Points: 783
More actions
December 5, 2008 at 12:13 pm

#96736

Hello,
I am using the Report Server Project to create my SSRS report.
I am getting all the data from the Dataset I defined for it.
But the problem is that I am not getting the Drill Down functionality as the
"Report Server Project Wizard" gives straight away (i.e. we just need to click the check box for it)
So how to group the data and how we can toggle the fields (i.e. textboxes what we say in SQL terms)
When I add a report in the project ... I use "Add item" instead of using "Add Report"
I do that ways because I am unable to specify the stored procedure I want to use as It gives only
one option that is text SQL statement.
So anyone out there can help me with the Drill down stuffs and if possible on this
adding report to the project.
Well ... this two problems may be related to each other I dont know. ???
Thanks in advance.
==== DEVAM 🙂

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

In the report, select the object you want to toggle, go to properties -> Visibility and set to hidden and set the toggleitem to the item you want to have the "+"

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

prabha-956826 SSC Enthusiast Points: 134 More actions · Answer 2

1) Right click the text box which you want to drill and select add group. (Ex: department name)

2) Select parent group. This will be grouped. Delete the column department name and rename the column header group to department name.

3) Select the other textboxes ([employee name]).Right click and in textbox properties select visibility. In this select hide radio button and Display can be toggled by this report item .In these select a field (for ex: department name).

4) Repeat the same for all other textboxes.