I've set a report that drills through to another report.
There is a parameter on the second report (sales orders)
called 'order_no'.
I can set up the drill through so clicking on an order
number on the first report links to the sales order
report, with the appropriate order number selected. What I
would like to be able to do is populate the parameter
values list from a query, so once the user has drilled-
through, they can browse through other sales orders using
the paramater.
Assuming the order_no parameter '000118' is sent through
to the sales orders report, I can display the correct
sales order. However, if I populate the paramater from a
query, I lose that value. Ideally I would like the default
parameter value to be the one passed from the first
report, but of course, you cannot set a parameter to
itself. Should I pass a second parameter to use for
setting the default value? It doesn't seem like a logical
way of doing things.
I hope this makes sense, and that someone can shed some
light on the issue.
Thanks,
Chris Ashworth.Chris,
I hope you don't mind if I piggy-back onto your inquiry. I'm looking for an
answer as well. I have several drill down reports where I'd like the user to
be able to see the parameter dropdowns, but have noticed that when a report
is drilled to, the parameters no longer show. Is there any kind of toggle to
show parameters, even after a drill down?
Showing posts with label sales. Show all posts
Showing posts with label sales. Show all posts
Sunday, February 19, 2012
Friday, February 17, 2012
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,
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 1and
For Month 1Just 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
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,
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
and
For Month 1
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
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,
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 1and
For Month 1Just 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
Tuesday, February 14, 2012
Drill Through to report from Matrix Subtotal
Hi,
I have the following result from a matrix:
| Week 1 | Week 2 | Week 3 |
DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
|New cust | 3 | 2 |
5 |
Salesrep 2| Sales | $200 | $300 | $100 |
|New cust | 2 | 1 |
3 |
---
DSM 1 Totals | $300 | $500 | $400 |
|New cust | 5 | 3 |
8 |
What I'm trying to accomplish is to have the user click on the field "New
Cust" and open a report that shows the new customers (detail) for the entire
row. The marix report has to and from date parameters that I am passing to
the second report, but the second report also has the DSM and Salesrep
parameters (each set up as a multi parameter). I want the user to be able to
click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
total line. I know this requires the InScope function, but I can't seem to
get the statment right.
Any help is greatly appreciated.
Thanks!
--
JohnWell either this was too hard or it is not possible. Either way, can someone
give me some insight?
--
John
"John" wrote:
> Hi,
> I have the following result from a matrix:
> | Week 1 | Week 2 | Week 3 |
> DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
> |New cust | 3 | 2 |
> 5 |
> Salesrep 2| Sales | $200 | $300 | $100 |
> |New cust | 2 | 1 |
> 3 |
> ---
> DSM 1 Totals | $300 | $500 | $400 |
> |New cust | 5 | 3 |
> 8 |
> What I'm trying to accomplish is to have the user click on the field "New
> Cust" and open a report that shows the new customers (detail) for the entire
> row. The marix report has to and from date parameters that I am passing to
> the second report, but the second report also has the DSM and Salesrep
> parameters (each set up as a multi parameter). I want the user to be able to
> click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
> total line. I know this requires the InScope function, but I can't seem to
> get the statment right.
> Any help is greatly appreciated.
> Thanks!
> --
> John
I have the following result from a matrix:
| Week 1 | Week 2 | Week 3 |
DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
|New cust | 3 | 2 |
5 |
Salesrep 2| Sales | $200 | $300 | $100 |
|New cust | 2 | 1 |
3 |
---
DSM 1 Totals | $300 | $500 | $400 |
|New cust | 5 | 3 |
8 |
What I'm trying to accomplish is to have the user click on the field "New
Cust" and open a report that shows the new customers (detail) for the entire
row. The marix report has to and from date parameters that I am passing to
the second report, but the second report also has the DSM and Salesrep
parameters (each set up as a multi parameter). I want the user to be able to
click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
total line. I know this requires the InScope function, but I can't seem to
get the statment right.
Any help is greatly appreciated.
Thanks!
--
JohnWell either this was too hard or it is not possible. Either way, can someone
give me some insight?
--
John
"John" wrote:
> Hi,
> I have the following result from a matrix:
> | Week 1 | Week 2 | Week 3 |
> DSM 1 | Salesrep 1| Sales | $100 | $200 | $300 |
> |New cust | 3 | 2 |
> 5 |
> Salesrep 2| Sales | $200 | $300 | $100 |
> |New cust | 2 | 1 |
> 3 |
> ---
> DSM 1 Totals | $300 | $500 | $400 |
> |New cust | 5 | 3 |
> 8 |
> What I'm trying to accomplish is to have the user click on the field "New
> Cust" and open a report that shows the new customers (detail) for the entire
> row. The marix report has to and from date parameters that I am passing to
> the second report, but the second report also has the DSM and Salesrep
> parameters (each set up as a multi parameter). I want the user to be able to
> click on the indevidual Salesrep line, the DSM subtotal Line, and the Grand
> total line. I know this requires the InScope function, but I can't seem to
> get the statment right.
> Any help is greatly appreciated.
> Thanks!
> --
> John
Subscribe to:
Posts (Atom)