|
|
You're in the
sql server reporting services
group:Click Through report/jump to a location
sql server reporting services:
report when you open it. Here's my situation. I have a summary commission report, that when you click on the Sales reps name, it takes you to a detailed report about the reps invoices. This report needs to have all reps on it, but i want it to jump to the location of the rep that was clicked on in the original report. Is this possible?
Christhe, I think you are looking for an anchor function. I don't think there is one, unless you create your custom Report viewer. However, if you change your report structure a bit, you may get the same effect. Click on the name, call the same report with name parameter and display the results at the bottom. By default, do not show any data related to sales. How does it sound? Let me know, if you find a another solution for your problem. Thanks. Cem Demircioglu [quoted text, click to view] "ChristheGreat" <cfelkey@gmail.com> wrote in message news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > Anyone know how to make a report jump to a particular part of the > report when you open it. > > Here's my situation. I have a summary commission report, that when you > click on the Sales reps name, it takes you to a detailed report about > the reps invoices. This report needs to have all reps on it, but i > want it to jump to the location of the rep that was clicked on in the > original report. Is this possible? >
There is a way to set and jump to a bookmark once you are in the report, the
question is whether this bookmark can be specified on the URL. This has gotten me curious and I am going to investigate it. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Cem Demircioglu" <cem@nospam.com> wrote in message news:OE40e$M9EHA.2540@TK2MSFTNGP09.phx.gbl... > > Christhe, > I think you are looking for an anchor function. I don't think there is one, > unless you create your custom Report viewer. However, if you change your > report structure a bit, you may get the same effect. Click on the name, call > the same report with name parameter and display the results at the bottom. > By default, do not show any data related to sales. > > How does it sound? Let me know, if you find a another solution for your > problem. > > Thanks. > Cem Demircioglu > > "ChristheGreat" <cfelkey@gmail.com> wrote in message > news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > > Anyone know how to make a report jump to a particular part of the > > report when you open it. > > > > Here's my situation. I have a summary commission report, that when you > > click on the Sales reps name, it takes you to a detailed report about > > the reps invoices. This report needs to have all reps on it, but i > > want it to jump to the location of the rep that was clicked on in the > > original report. Is this possible? > > > >
Have you had any luck w/ this ? I saw in the reporting services books online
documentation that there is a "BookmarkID" property as an HTML device setting when rendering to HTML. I would like to just specify a BookMarkId using URL access something like - : http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508 but it expects the BookmarkID as a report parameter. [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> There is a way to set and jump to a bookmark once you are in the report, the > question is whether this bookmark can be specified on the URL. This has > gotten me curious and I am going to investigate it. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Cem Demircioglu" <cem@nospam.com> wrote in message > news:OE40e$M9EHA.2540@TK2MSFTNGP09.phx.gbl... > > > > Christhe, > > I think you are looking for an anchor function. I don't think there is > one, > > unless you create your custom Report viewer. However, if you change your > > report structure a bit, you may get the same effect. Click on the name, > call > > the same report with name parameter and display the results at the bottom. > > By default, do not show any data related to sales. > > > > How does it sound? Let me know, if you find a another solution for your > > problem. > > > > Thanks. > > Cem Demircioglu > > > > "ChristheGreat" <cfelkey@gmail.com> wrote in message > > news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > > > Anyone know how to make a report jump to a particular part of the > > > report when you open it. > > > > > > Here's my situation. I have a summary commission report, that when you > > > click on the Sales reps name, it takes you to a detailed report about > > > the reps invoices. This report needs to have all reps on it, but i > > > want it to jump to the location of the rep that was clicked on in the > > > original report. Is this possible? > > > > > > > > >
got it! - need to put "&rc%3a" in front of "BookmarkID=704-591-2508"
This will get you to top of the page of the BookMark you are looking for, but I suppose scrolling down to it on with browser would require client scripting. I will experiment with the Document map ID parameter to see if this works any better. [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I thought this should be possible but same as you I was not able to get it > to work. I'll try my MS contacts and see if there is a way to do this. > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "jj#10" <jj10@discussions.microsoft.com> wrote in message > news:C2A778A3-352F-4E89-86B2-4A58044889BE@microsoft.com... > > Have you had any luck w/ this ? I saw in the reporting services books > online > > documentation that there is a "BookmarkID" property as an HTML device > setting > > when rendering to HTML. > > > > I would like to just specify a BookMarkId using URL access something > like - : > > > > > http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508 > > > > but it expects the BookmarkID as a report parameter. > > > > "Bruce L-C [MVP]" wrote: > > > > > There is a way to set and jump to a bookmark once you are in the report, > the > > > question is whether this bookmark can be specified on the URL. This has > > > gotten me curious and I am going to investigate it. > > > > > > -- > > > Bruce Loehle-Conger > > > MVP SQL Server Reporting Services > > > > > > "Cem Demircioglu" <cem@nospam.com> wrote in message > > > news:OE40e$M9EHA.2540@TK2MSFTNGP09.phx.gbl... > > > > > > > > Christhe, > > > > I think you are looking for an anchor function. I don't think there is > > > one, > > > > unless you create your custom Report viewer. However, if you change > your > > > > report structure a bit, you may get the same effect. Click on the > name, > > > call > > > > the same report with name parameter and display the results at the > bottom. > > > > By default, do not show any data related to sales. > > > > > > > > How does it sound? Let me know, if you find a another solution for > your > > > > problem. > > > > > > > > Thanks. > > > > Cem Demircioglu > > > > > > > > "ChristheGreat" <cfelkey@gmail.com> wrote in message > > > > news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > > > > > Anyone know how to make a report jump to a particular part of the > > > > > report when you open it. > > > > > > > > > > Here's my situation. I have a summary commission report, that when > you > > > > > click on the Sales reps name, it takes you to a detailed report > about > > > > > the reps invoices. This report needs to have all reps on it, but i > > > > > want it to jump to the location of the rep that was clicked on in > the > > > > > original report. Is this possible? > > > > > > > > > > > > > > > > > > > > > > > >
I thought this should be possible but same as you I was not able to get it
to work. I'll try my MS contacts and see if there is a way to do this. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "jj#10" <jj10@discussions.microsoft.com> wrote in message news:C2A778A3-352F-4E89-86B2-4A58044889BE@microsoft.com... > Have you had any luck w/ this ? I saw in the reporting services books online > documentation that there is a "BookmarkID" property as an HTML device setting > when rendering to HTML. > > I would like to just specify a BookMarkId using URL access something like - : > > http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508 > > but it expects the BookmarkID as a report parameter. > > "Bruce L-C [MVP]" wrote: > > > There is a way to set and jump to a bookmark once you are in the report, the > > question is whether this bookmark can be specified on the URL. This has > > gotten me curious and I am going to investigate it. > > > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > > > "Cem Demircioglu" <cem@nospam.com> wrote in message > > news:OE40e$M9EHA.2540@TK2MSFTNGP09.phx.gbl... > > > > > > Christhe, > > > I think you are looking for an anchor function. I don't think there is > > one, > > > unless you create your custom Report viewer. However, if you change your > > > report structure a bit, you may get the same effect. Click on the name, > > call > > > the same report with name parameter and display the results at the bottom. > > > By default, do not show any data related to sales. > > > > > > How does it sound? Let me know, if you find a another solution for your > > > problem. > > > > > > Thanks. > > > Cem Demircioglu > > > > > > "ChristheGreat" <cfelkey@gmail.com> wrote in message > > > news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > > > > Anyone know how to make a report jump to a particular part of the > > > > report when you open it. > > > > > > > > Here's my situation. I have a summary commission report, that when you > > > > click on the Sales reps name, it takes you to a detailed report about > > > > the reps invoices. This report needs to have all reps on it, but i > > > > want it to jump to the location of the rep that was clicked on in the > > > > original report. Is this possible? > > > > > > > > > > > > > > > >
I was having a single page in my tests and expected it to go to the bookmark
which it did not. So it sounds like it is partially implemented, that it brought it to the appropriate page. Well, that is something. Let me know what you find out with Document map if you don't mind. Thanks, -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "jj#10" <jj10@discussions.microsoft.com> wrote in message news:33692470-7120-4A1B-A055-321F4C288B78@microsoft.com... > got it! - need to put "&rc%3a" in front of "BookmarkID=704-591-2508" > > This will get you to top of the page of the BookMark you are looking for, > but I suppose scrolling down to it on with browser would require client > scripting. > > I will experiment with the Document map ID parameter to see if this works > any better. > > "Bruce L-C [MVP]" wrote: > > > I thought this should be possible but same as you I was not able to get it > > to work. I'll try my MS contacts and see if there is a way to do this. > > > > -- > > Bruce Loehle-Conger > > MVP SQL Server Reporting Services > > > > "jj#10" <jj10@discussions.microsoft.com> wrote in message > > news:C2A778A3-352F-4E89-86B2-4A58044889BE@microsoft.com... > > > Have you had any luck w/ this ? I saw in the reporting services books > > online > > > documentation that there is a "BookmarkID" property as an HTML device > > setting > > > when rendering to HTML. > > > > > > I would like to just specify a BookMarkId using URL access something > > like - : > > > > > > > > http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508 > > > > > > but it expects the BookmarkID as a report parameter. > > > > > > "Bruce L-C [MVP]" wrote: > > > > > > > There is a way to set and jump to a bookmark once you are in the report, > > the > > > > question is whether this bookmark can be specified on the URL. This has > > > > gotten me curious and I am going to investigate it. > > > > > > > > -- > > > > Bruce Loehle-Conger > > > > MVP SQL Server Reporting Services > > > > > > > > "Cem Demircioglu" <cem@nospam.com> wrote in message > > > > news:OE40e$M9EHA.2540@TK2MSFTNGP09.phx.gbl... > > > > > > > > > > Christhe, > > > > > I think you are looking for an anchor function. I don't think there is > > > > one, > > > > > unless you create your custom Report viewer. However, if you change > > your > > > > > report structure a bit, you may get the same effect. Click on the > > name, > > > > call > > > > > the same report with name parameter and display the results at the > > bottom. > > > > > By default, do not show any data related to sales. > > > > > > > > > > How does it sound? Let me know, if you find a another solution for > > your > > > > > problem. > > > > > > > > > > Thanks. > > > > > Cem Demircioglu > > > > > > > > > > "ChristheGreat" <cfelkey@gmail.com> wrote in message > > > > > news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > > > > > > Anyone know how to make a report jump to a particular part of the > > > > > > report when you open it. > > > > > > > > > > > > Here's my situation. I have a summary commission report, that when > > you > > > > > > click on the Sales reps name, it takes you to a detailed report > > about > > > > > > the reps invoices. This report needs to have all reps on it, but i > > > > > > want it to jump to the location of the rep that was clicked on in > > the > > > > > > original report. Is this possible? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
I can't get the Doc Map Id to work at all. Not sure what I'm doing wrong - I
utilized it in the same way as the BooMarkID. I'll probably stick with the BookMarkID. [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I was having a single page in my tests and expected it to go to the bookmark > which it did not. So it sounds like it is partially implemented, that it > brought it to the appropriate page. Well, that is something. Let me know > what you find out with Document map if you don't mind. Thanks, > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "jj#10" <jj10@discussions.microsoft.com> wrote in message > news:33692470-7120-4A1B-A055-321F4C288B78@microsoft.com... > > got it! - need to put "&rc%3a" in front of "BookmarkID=704-591-2508" > > > > This will get you to top of the page of the BookMark you are looking for, > > but I suppose scrolling down to it on with browser would require client > > scripting. > > > > I will experiment with the Document map ID parameter to see if this works > > any better. > > > > "Bruce L-C [MVP]" wrote: > > > > > I thought this should be possible but same as you I was not able to get > it > > > to work. I'll try my MS contacts and see if there is a way to do this. > > > > > > -- > > > Bruce Loehle-Conger > > > MVP SQL Server Reporting Services > > > > > > "jj#10" <jj10@discussions.microsoft.com> wrote in message > > > news:C2A778A3-352F-4E89-86B2-4A58044889BE@microsoft.com... > > > > Have you had any luck w/ this ? I saw in the reporting services books > > > online > > > > documentation that there is a "BookmarkID" property as an HTML device > > > setting > > > > when rendering to HTML. > > > > > > > > I would like to just specify a BookMarkId using URL access something > > > like - : > > > > > > > > > > > > http://itmgmt/ReportServer?%2fONE_BILL%2falltel&dept_head_key=B3C95052-28F1-4318-A4CB-020008B960CA&department_number=ALL&bill_month=12/1/04&rs%3aParameterLanguage=&rc%3aParameters=FALSE&BookmarkID=704-591-2508 > > > > > > > > but it expects the BookmarkID as a report parameter. > > > > > > > > "Bruce L-C [MVP]" wrote: > > > > > > > > > There is a way to set and jump to a bookmark once you are in the > report, > > > the > > > > > question is whether this bookmark can be specified on the URL. This > has > > > > > gotten me curious and I am going to investigate it. > > > > > > > > > > -- > > > > > Bruce Loehle-Conger > > > > > MVP SQL Server Reporting Services > > > > > > > > > > "Cem Demircioglu" <cem@nospam.com> wrote in message > > > > > news:OE40e$M9EHA.2540@TK2MSFTNGP09.phx.gbl... > > > > > > > > > > > > Christhe, > > > > > > I think you are looking for an anchor function. I don't think > there is > > > > > one, > > > > > > unless you create your custom Report viewer. However, if you > change > > > your > > > > > > report structure a bit, you may get the same effect. Click on the > > > name, > > > > > call > > > > > > the same report with name parameter and display the results at the > > > bottom. > > > > > > By default, do not show any data related to sales. > > > > > > > > > > > > How does it sound? Let me know, if you find a another solution for > > > your > > > > > > problem. > > > > > > > > > > > > Thanks. > > > > > > Cem Demircioglu > > > > > > > > > > > > "ChristheGreat" <cfelkey@gmail.com> wrote in message > > > > > > news:1105052689.824503.90710@z14g2000cwz.googlegroups.com... > > > > > > > Anyone know how to make a report jump to a particular part of > the > > > > > > > report when you open it. > > > > > > > > > > > > > > Here's my situation. I have a summary commission report, that > when > > > you > > > > > > > click on the Sales reps name, it takes you to a detailed report > > > about > > > > > > > the reps invoices. This report needs to have all reps on it, > but i > > > > > > > want it to jump to the location of the rep that was clicked on > in > > > the > > > > > > > original report. Is this possible? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |