Drill Down Functionality

Question

Post reply

Drill Down Functionality

danielagger98

Mr or Mrs. 500

Points: 502
More actions
June 28, 2010 at 2:43 pm

#223340

Hello Forum,
My client needs a drill down functionality in a report.
For example: Continent,Country, state,Cities,county. Country should drill down into state and hence forth.
But instead if the normal +/- sign of the drill down. He wants to able to click on each item(country) and then the cities should be drilled down. So the country should look like a link. No +/- sign should be there next to country.
Moreover for some reason +/- signs with drill down doesn't work on asp.net sites. It well works in the SSRS, but the reprot I am creating goes into the website. So the developer came back to me and said the drill down does not work in the site. So I am in deep S***
Any ideas would be really helpful Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

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

danielagger98 Mr or Mrs. 500 Points: 502 More actions · Answer 1

Just a quick Question. Is this forum still alive or is it that my question is boring?

Luke L SSC-Dedicated Points: 35547 More actions · Answer 2

But instead if the normal +/- sign of the drill down. He wants to able to click on each item(country) and then the cities should be drilled down. So the country should look like a link. No +/- sign should be there next to country.

What you probably want to look at is sub report and or using URLs in your textboxes. When a link is clicked you pass a parameter to the subreport and it refreshes based on that parameter.

HAve a look at this from MSDN about creating a drill-through report. http://msdn.microsoft.com/en-us/library/ms159847.aspx

To help us help you read this[/url]For better help with performance problems please read this[/url]

Luke L SSC-Dedicated Points: 35547 More actions · Answer 3

danielagger98 (6/29/2010)
Just a quick Question. Is this forum still alive or is it that my question is boring?

And no it's not dead, it's just that Not a lot of people frequent the SSRS forum and you posted your question at 4:45 EDT and re-posted at 8:27 EDT... in other words for East cost folks, that would be 15 minutes before most of us leave the office and 30 minutes after we get in. Please remember that we're all volunteers here, who give of the time we have to help others. If you want an SLA you'll need to find a vendor and start paying for one.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

Sunil Desai Valued Member Points: 53 More actions · Answer 4

Well the link you suggested was of great help. Thanks