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,
| Keywords | Product A | Product B | Product C | Product D |
| Keyword 1 | 125 | 24 | 275 | 12 |
| Keyword 2 | 456 | 245 | 67 | 1223 |
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| Keywords | Month1 | Month2 | Month3 | Month4 |
| Keyword 1 | 125 | 24 | 275 | 12 |
| Keyword 2 | 456 | 245 | 67 | 1223 |
and
For Month 1| Keywords | Product A | Product B | Product C | Product D |
| Keyword 1 | 125 | 24 | 275 | 12 |
| Keyword 2 | 456 | 245 | 67 | 1223 |
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.............
Drilldown in SQl Reporting Service
Graham Hansen
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.
Alex
azzyford
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.
Phil026
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...