Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

KeywordsMonth1Month2Month3Month4Keyword 11252427512Keyword 2456245671223

and

For Month 1

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx