What is the best way to setup and configure a clusterd
environment of SQL Server in terms of RAID, data file
location, log file location, backup etc. I guess in
separate drives for data and logfile.Great question. The bad answer is always "it depends."
You must be doing something like a SAN or DAS right? In very general terms,
split the data, logs, and temp db all out on different raid configs, i.e.,
LUNs. I like RAID 1+0 (or said RAID 10) because of the speed and high
tolerance of multiple disk failures at once, not to mention when you need
more disk space, adding new spindles is easy. If performance is more
important than money, then spread out over as many spindles as feasable.
You achieve more I/Os this way. This means, go for more disks of lower size
than few disks of higher size.
I believe on the SQL disk there is a VB6 application called database hammer
which you can use to test your config.
hth, Eric
"Aboki" <waco361@.hotmail.com> wrote in message
news:0afe01c36b38$2ab80730$a001280a@.phx.gbl...
> What is the best way to setup and configure a clusterd
> environment of SQL Server in terms of RAID, data file
> location, log file location, backup etc. I guess in
> separate drives for data and logfile.sqlsql
Showing posts with label location. Show all posts
Showing posts with label location. Show all posts
Tuesday, March 20, 2012
Cluster and Mirroring with 2005
I am looking for some advice on the following problem.
I need a redundant SQL solution at our main location and a warm site in
a different, off site location. The warm site would only become a hot
site if we had a complete failure at the main location.
What I was thinking was to create a failover cluster at our main
location incase of simple hardware failure, the other server could take
over. At the warm site I would have a witness server and have the
database mirrored to a sql server there. I am going to be using sql
server 2005.
Is this a possible solution? If not, can you please point me in the
right direction. $$$ is not really an issue.
That is certainly a possible scenario. Remember that mirroring works at the
database level, not at the server level. You will have to do some
customization if you want to make it work for multiple databases. There are
also performance, latency, and network bandwidth costs for mirroring. The
lower your tolerance for data loss and outage time, the higher those costs.
If money really isn't an issue, you may want to look at SAN-level data
replication technologies. Since you will have a SAN for the cluster anyway,
this may be a better option. Make sure the SAN vendor can keep multiple
LUNS in synch or you may end up with mismatched data and log partitions,
causing a corrupt and unusable database.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
>I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
|||I noticed that you said 'warm site'. By 'warm', I assume you can afford
losing some data during a site failover. If you can afford data loss of up
to 15 minutes or so, the plain old log shipping may be the simplest and
cheapest solution to consider. I'd keep it simple if a simple solution is
enough.
Linchi
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
>I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
|||Database mirroring is certainly an option, but so would be log shipping,
remote mirroring, or stretch clustering.
You might want to check out the following. Although for SS2K, most of the
information still applies, with the exception of DB mirroring.
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
SQL Server 2000 High Availability Series
Implementing Remote Mirroring and Stretch Clustering
http://www.microsoft.com/technet/pro...y/hasog05.mspx
SQL Server 2005 Mission Critical High Availability
http://www.microsoft.com/technet/pro...s/default.mspx
Sincerely,
Anthony Thomas
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
> I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
I need a redundant SQL solution at our main location and a warm site in
a different, off site location. The warm site would only become a hot
site if we had a complete failure at the main location.
What I was thinking was to create a failover cluster at our main
location incase of simple hardware failure, the other server could take
over. At the warm site I would have a witness server and have the
database mirrored to a sql server there. I am going to be using sql
server 2005.
Is this a possible solution? If not, can you please point me in the
right direction. $$$ is not really an issue.
That is certainly a possible scenario. Remember that mirroring works at the
database level, not at the server level. You will have to do some
customization if you want to make it work for multiple databases. There are
also performance, latency, and network bandwidth costs for mirroring. The
lower your tolerance for data loss and outage time, the higher those costs.
If money really isn't an issue, you may want to look at SAN-level data
replication technologies. Since you will have a SAN for the cluster anyway,
this may be a better option. Make sure the SAN vendor can keep multiple
LUNS in synch or you may end up with mismatched data and log partitions,
causing a corrupt and unusable database.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
>I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
|||I noticed that you said 'warm site'. By 'warm', I assume you can afford
losing some data during a site failover. If you can afford data loss of up
to 15 minutes or so, the plain old log shipping may be the simplest and
cheapest solution to consider. I'd keep it simple if a simple solution is
enough.
Linchi
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
>I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
|||Database mirroring is certainly an option, but so would be log shipping,
remote mirroring, or stretch clustering.
You might want to check out the following. Although for SS2K, most of the
information still applies, with the exception of DB mirroring.
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
SQL Server 2000 High Availability Series
Implementing Remote Mirroring and Stretch Clustering
http://www.microsoft.com/technet/pro...y/hasog05.mspx
SQL Server 2005 Mission Critical High Availability
http://www.microsoft.com/technet/pro...s/default.mspx
Sincerely,
Anthony Thomas
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
> I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
Wednesday, March 7, 2012
Closest Time in SQL Table
Hi. I have 2 tables which have the following formats:
TABLE A
PLC_TIME TAGNAME STATUS LOCATION
-- -- -- --
TABLE B
PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
-- -- --
-- --
Both tables will be inserted with records by a software continuously
with the PLC_TIME of Table B null, ie
PLC_TIME is not inserted with records. For eg,
TABLE_A
PLC_TIME TAGNAME STATUS LOCATION
-- -- -- --
07-05-2007 1:00:32pm TAG.A ON SITEA
07-05-2007 1:40:11pm TAG.A OFF SITEA
07-05-2007 1:10:31pm TAG.A ON SITEA
07-05-2007 2:10:11pm TAG.B NORMAL SITEB
TABLE_B
PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
-- -- --
-- --
null 07-05-2007 1:00:39pm TAG.A ON SITEA
null 07-05-2007 1:41:22pm TAG.A OFF SITEA
null 07-05-2007 2:10:12pm TAG.B NORMAL SITEB
I'm required to update PLC_TIME of TABLE B with the PLC_TIME from
table A
which both of them have the same TAGNAME and STATUS and the PLC_TIME
from table A must be
the CLOSEST to the PCVUE_TIME in table b. PLC_TIME is also always
earlier than PCVUE_TIME.
I have used the following SQL command in my VB program to update the
CLOSEST PLC_TIME of TABLE_B:
UPDATE TABLE_B SET PLC_TIME = (SELECT MAX(PLC_TIME) FROM TABLE_A WHERE
TAGNAME = TABLE_B.TAGNAME AND STATUS = TABLE_B.STATUS
AND PLC_TIME<TABLE_B.PCVUE_TIME AND
ABS(DATEDIFF(MINUTE,PLC_TIME,PCVUE_TIME))<31)
(Note: 31 is just an estimation of the maximum difference of PLC_TIME
and PCVUE_TIME in normal case.)
Since both TABLE_A and TABLE_B are updated randomly and the timing may
not be in order, i.e. Some earlier records may be inserted into
TABLE_A and TABLE_B
by the software, my VB program needs to "update TABLE_B set PLC_TIME"
constantly until the CLOSEST PLC_TIME is updated.
What i can think of is DATEDIFF() but DATEDIFF has a limitation that
it only compares the specific MINUTE of
PCVUE_TIME and PLC_TIME if i use DATEDIFF(minute,PLC_TIME, PCVUE_TIME)
and this will have a problem for 1:59pm and 2:00pm in which 2:00pm
will be treated
as earlier than 1:59pm. Also i may need to have multiple DATEDIFF
which compares YEAR, MONTH, DAY, HOUR and so on... which is not
feasible.
What correct SQL command can i use to update TABLE_B until the CLOSEST
PLC_TIME is updated into TABLE_B?You can try something like this:
UPDATE TABLE_B SET PLC_TIME = A.PLC_TIME
FROM TABLE_B B
INNER JOIN
(SELECT MAX(TABLE_A.PLC_TIME) PLC_TIME, TABLE_A.TAGNAME, TABLE_A.STATUS
FROM TABLE_A
INNER JOIN TABLE_B
ON TABLE_A.TAGNAME = TABLE_B.TAGNAME AND TABLE_A.STATUS = TABLE_B.STATUS
WHERE TABLE_A.PLC_TIME<TABLE_B.PCVUE_TIME
GROUP BY TABLE_A.TAGNAME, TABLE_A.STATUS) A
ON A.TAGNAME = B.TAGNAME AND A.STATUS = B.STATUS
"albertleng" <albertleng@.gmail.com> wrote in message
news:1180449709.930509.45380@.r19g2000prf.googlegroups.com...
> Hi. I have 2 tables which have the following formats:
> TABLE A
> PLC_TIME TAGNAME STATUS LOCATION
> -- -- -- --
> TABLE B
> PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
> -- -- --
> -- --
> Both tables will be inserted with records by a software continuously
> with the PLC_TIME of Table B null, ie
> PLC_TIME is not inserted with records. For eg,
> TABLE_A
> PLC_TIME TAGNAME STATUS LOCATION
> -- -- -- --
> 07-05-2007 1:00:32pm TAG.A ON SITEA
> 07-05-2007 1:40:11pm TAG.A OFF SITEA
> 07-05-2007 1:10:31pm TAG.A ON SITEA
> 07-05-2007 2:10:11pm TAG.B NORMAL SITEB
>
> TABLE_B
> PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
> -- -- --
> -- --
> null 07-05-2007 1:00:39pm TAG.A ON SITEA
> null 07-05-2007 1:41:22pm TAG.A OFF SITEA
> null 07-05-2007 2:10:12pm TAG.B NORMAL SITEB
> I'm required to update PLC_TIME of TABLE B with the PLC_TIME from
> table A
> which both of them have the same TAGNAME and STATUS and the PLC_TIME
> from table A must be
> the CLOSEST to the PCVUE_TIME in table b. PLC_TIME is also always
> earlier than PCVUE_TIME.
> I have used the following SQL command in my VB program to update the
> CLOSEST PLC_TIME of TABLE_B:
> UPDATE TABLE_B SET PLC_TIME = (SELECT MAX(PLC_TIME) FROM TABLE_A WHERE
> TAGNAME = TABLE_B.TAGNAME AND STATUS = TABLE_B.STATUS
> AND PLC_TIME<TABLE_B.PCVUE_TIME AND
> ABS(DATEDIFF(MINUTE,PLC_TIME,PCVUE_TIME))<31)
> (Note: 31 is just an estimation of the maximum difference of PLC_TIME
> and PCVUE_TIME in normal case.)
> Since both TABLE_A and TABLE_B are updated randomly and the timing may
> not be in order, i.e. Some earlier records may be inserted into
> TABLE_A and TABLE_B
> by the software, my VB program needs to "update TABLE_B set PLC_TIME"
> constantly until the CLOSEST PLC_TIME is updated.
> What i can think of is DATEDIFF() but DATEDIFF has a limitation that
> it only compares the specific MINUTE of
> PCVUE_TIME and PLC_TIME if i use DATEDIFF(minute,PLC_TIME, PCVUE_TIME)
> and this will have a problem for 1:59pm and 2:00pm in which 2:00pm
> will be treated
> as earlier than 1:59pm. Also i may need to have multiple DATEDIFF
> which compares YEAR, MONTH, DAY, HOUR and so on... which is not
> feasible.
>
> What correct SQL command can i use to update TABLE_B until the CLOSEST
> PLC_TIME is updated into TABLE_B?
>|||Hi
"Quentin Ran" wrote:
> You can try something like this:
> UPDATE TABLE_B SET PLC_TIME = A.PLC_TIME
> FROM TABLE_B B
> INNER JOIN
> (SELECT MAX(TABLE_A.PLC_TIME) PLC_TIME, TABLE_A.TAGNAME, TABLE_A.STATUS
> FROM TABLE_A
> INNER JOIN TABLE_B
> ON TABLE_A.TAGNAME = TABLE_B.TAGNAME AND TABLE_A.STATUS = TABLE_B.STATUS
> WHERE TABLE_A.PLC_TIME<TABLE_B.PCVUE_TIME
> GROUP BY TABLE_A.TAGNAME, TABLE_A.STATUS) A
> ON A.TAGNAME = B.TAGNAME AND A.STATUS = B.STATUS
>
You should also have
WHERE B.PLC_TIME IS NULL
to both the derived table and update statement to eliminate records already
updated
i.e.
UPDATE B
SET PLC_TIME = A.PLC_TIME
FROM TABLE_B B
JOIN (SELECT MAX(C.PLC_TIME) AS PLC_TIME, C.TAGNAME, C.STATUS
FROM TABLE_A C
JOIN TABLE_B D ON C.TAGNAME = D.TAGNAME AND C.STATUS = D.STATUS
AND C.PLC_TIME< D.PCVUE_TIME AND D.PLC_TIME IS NULL
GROUP BY C.TAGNAME, C.STATUS) A
ON A.TAGNAME = B.TAGNAME AND A.STATUS = B.STATUS
WHERE B.PLC_TIME IS NULL
John
TABLE A
PLC_TIME TAGNAME STATUS LOCATION
-- -- -- --
TABLE B
PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
-- -- --
-- --
Both tables will be inserted with records by a software continuously
with the PLC_TIME of Table B null, ie
PLC_TIME is not inserted with records. For eg,
TABLE_A
PLC_TIME TAGNAME STATUS LOCATION
-- -- -- --
07-05-2007 1:00:32pm TAG.A ON SITEA
07-05-2007 1:40:11pm TAG.A OFF SITEA
07-05-2007 1:10:31pm TAG.A ON SITEA
07-05-2007 2:10:11pm TAG.B NORMAL SITEB
TABLE_B
PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
-- -- --
-- --
null 07-05-2007 1:00:39pm TAG.A ON SITEA
null 07-05-2007 1:41:22pm TAG.A OFF SITEA
null 07-05-2007 2:10:12pm TAG.B NORMAL SITEB
I'm required to update PLC_TIME of TABLE B with the PLC_TIME from
table A
which both of them have the same TAGNAME and STATUS and the PLC_TIME
from table A must be
the CLOSEST to the PCVUE_TIME in table b. PLC_TIME is also always
earlier than PCVUE_TIME.
I have used the following SQL command in my VB program to update the
CLOSEST PLC_TIME of TABLE_B:
UPDATE TABLE_B SET PLC_TIME = (SELECT MAX(PLC_TIME) FROM TABLE_A WHERE
TAGNAME = TABLE_B.TAGNAME AND STATUS = TABLE_B.STATUS
AND PLC_TIME<TABLE_B.PCVUE_TIME AND
ABS(DATEDIFF(MINUTE,PLC_TIME,PCVUE_TIME))<31)
(Note: 31 is just an estimation of the maximum difference of PLC_TIME
and PCVUE_TIME in normal case.)
Since both TABLE_A and TABLE_B are updated randomly and the timing may
not be in order, i.e. Some earlier records may be inserted into
TABLE_A and TABLE_B
by the software, my VB program needs to "update TABLE_B set PLC_TIME"
constantly until the CLOSEST PLC_TIME is updated.
What i can think of is DATEDIFF() but DATEDIFF has a limitation that
it only compares the specific MINUTE of
PCVUE_TIME and PLC_TIME if i use DATEDIFF(minute,PLC_TIME, PCVUE_TIME)
and this will have a problem for 1:59pm and 2:00pm in which 2:00pm
will be treated
as earlier than 1:59pm. Also i may need to have multiple DATEDIFF
which compares YEAR, MONTH, DAY, HOUR and so on... which is not
feasible.
What correct SQL command can i use to update TABLE_B until the CLOSEST
PLC_TIME is updated into TABLE_B?You can try something like this:
UPDATE TABLE_B SET PLC_TIME = A.PLC_TIME
FROM TABLE_B B
INNER JOIN
(SELECT MAX(TABLE_A.PLC_TIME) PLC_TIME, TABLE_A.TAGNAME, TABLE_A.STATUS
FROM TABLE_A
INNER JOIN TABLE_B
ON TABLE_A.TAGNAME = TABLE_B.TAGNAME AND TABLE_A.STATUS = TABLE_B.STATUS
WHERE TABLE_A.PLC_TIME<TABLE_B.PCVUE_TIME
GROUP BY TABLE_A.TAGNAME, TABLE_A.STATUS) A
ON A.TAGNAME = B.TAGNAME AND A.STATUS = B.STATUS
"albertleng" <albertleng@.gmail.com> wrote in message
news:1180449709.930509.45380@.r19g2000prf.googlegroups.com...
> Hi. I have 2 tables which have the following formats:
> TABLE A
> PLC_TIME TAGNAME STATUS LOCATION
> -- -- -- --
> TABLE B
> PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
> -- -- --
> -- --
> Both tables will be inserted with records by a software continuously
> with the PLC_TIME of Table B null, ie
> PLC_TIME is not inserted with records. For eg,
> TABLE_A
> PLC_TIME TAGNAME STATUS LOCATION
> -- -- -- --
> 07-05-2007 1:00:32pm TAG.A ON SITEA
> 07-05-2007 1:40:11pm TAG.A OFF SITEA
> 07-05-2007 1:10:31pm TAG.A ON SITEA
> 07-05-2007 2:10:11pm TAG.B NORMAL SITEB
>
> TABLE_B
> PLC_TIME PCVUE_TIME TAGNAME STATUS LOCATION
> -- -- --
> -- --
> null 07-05-2007 1:00:39pm TAG.A ON SITEA
> null 07-05-2007 1:41:22pm TAG.A OFF SITEA
> null 07-05-2007 2:10:12pm TAG.B NORMAL SITEB
> I'm required to update PLC_TIME of TABLE B with the PLC_TIME from
> table A
> which both of them have the same TAGNAME and STATUS and the PLC_TIME
> from table A must be
> the CLOSEST to the PCVUE_TIME in table b. PLC_TIME is also always
> earlier than PCVUE_TIME.
> I have used the following SQL command in my VB program to update the
> CLOSEST PLC_TIME of TABLE_B:
> UPDATE TABLE_B SET PLC_TIME = (SELECT MAX(PLC_TIME) FROM TABLE_A WHERE
> TAGNAME = TABLE_B.TAGNAME AND STATUS = TABLE_B.STATUS
> AND PLC_TIME<TABLE_B.PCVUE_TIME AND
> ABS(DATEDIFF(MINUTE,PLC_TIME,PCVUE_TIME))<31)
> (Note: 31 is just an estimation of the maximum difference of PLC_TIME
> and PCVUE_TIME in normal case.)
> Since both TABLE_A and TABLE_B are updated randomly and the timing may
> not be in order, i.e. Some earlier records may be inserted into
> TABLE_A and TABLE_B
> by the software, my VB program needs to "update TABLE_B set PLC_TIME"
> constantly until the CLOSEST PLC_TIME is updated.
> What i can think of is DATEDIFF() but DATEDIFF has a limitation that
> it only compares the specific MINUTE of
> PCVUE_TIME and PLC_TIME if i use DATEDIFF(minute,PLC_TIME, PCVUE_TIME)
> and this will have a problem for 1:59pm and 2:00pm in which 2:00pm
> will be treated
> as earlier than 1:59pm. Also i may need to have multiple DATEDIFF
> which compares YEAR, MONTH, DAY, HOUR and so on... which is not
> feasible.
>
> What correct SQL command can i use to update TABLE_B until the CLOSEST
> PLC_TIME is updated into TABLE_B?
>|||Hi
"Quentin Ran" wrote:
> You can try something like this:
> UPDATE TABLE_B SET PLC_TIME = A.PLC_TIME
> FROM TABLE_B B
> INNER JOIN
> (SELECT MAX(TABLE_A.PLC_TIME) PLC_TIME, TABLE_A.TAGNAME, TABLE_A.STATUS
> FROM TABLE_A
> INNER JOIN TABLE_B
> ON TABLE_A.TAGNAME = TABLE_B.TAGNAME AND TABLE_A.STATUS = TABLE_B.STATUS
> WHERE TABLE_A.PLC_TIME<TABLE_B.PCVUE_TIME
> GROUP BY TABLE_A.TAGNAME, TABLE_A.STATUS) A
> ON A.TAGNAME = B.TAGNAME AND A.STATUS = B.STATUS
>
You should also have
WHERE B.PLC_TIME IS NULL
to both the derived table and update statement to eliminate records already
updated
i.e.
UPDATE B
SET PLC_TIME = A.PLC_TIME
FROM TABLE_B B
JOIN (SELECT MAX(C.PLC_TIME) AS PLC_TIME, C.TAGNAME, C.STATUS
FROM TABLE_A C
JOIN TABLE_B D ON C.TAGNAME = D.TAGNAME AND C.STATUS = D.STATUS
AND C.PLC_TIME< D.PCVUE_TIME AND D.PLC_TIME IS NULL
GROUP BY C.TAGNAME, C.STATUS) A
ON A.TAGNAME = B.TAGNAME AND A.STATUS = B.STATUS
WHERE B.PLC_TIME IS NULL
John
Sunday, February 12, 2012
Click Through report/jump to a location
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?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?
>|||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?
> >
>|||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
"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?
> > > >
> > >
> > >
> >
> >
> >|||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 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?
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||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.
"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?
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
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
"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
"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.
"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
"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?
> > > >
> > >
> > >
> >
> >
> >|||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 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?
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||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.
"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?
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
Subscribe to:
Posts (Atom)