Drilldown 1

[kjohnson530]

Hello all,

I trying to learn how to develop a drilldown feature with my data using ASP and I'm wondering if anyone has any tutorial suggestions.

I'd like to be able to provide a list of hyperlinks from my db that when one is click it expands the data directly below it:
example

--Baseball db--

Teams
Rumors
News

Click on teams and the following happens.

Teams
Houston
Boston
New York
Rumors
News


Click on a team:

Teams
Houston
Bagwell
Biggio
Clemens
Boston
New York
Rumors
News

I have a feeling this is pretty easy to do, but i simply don't know where to get the info I need to learn how to do this.

 

[MikeBronner]

One way to do it is to create the report with ALL data and hide the parts you can drill into. This can be easily done with CSS and JavaScript. Then you provide links or buttons for the user to expand the hidden parts at his or her leisure.

Another way to do this would be to use cubed reports using the SQL Reporting Services. The cubed reports are designed using the Reporting Services Reports designer, and will automatically generate drill-down reports based on your design parameters.

Sorry, I don't have any tutorials off-hand, but a search on data cubes (

http://www.google.com/search?hs=Nmi...illa:en-US:official&q=data+cubes&btnG=Search)

should dig something up.

Take Care,
Mike

 

[kjohnson530]

Thank you, I will look into both those options.