Friday, March 30, 2012
Jump to URL's
them to open in a second and third window leaving the first open to the
orginal report. Can this be done? I have the report right now that can "jump"
to one of the links in the cell. But it uses the original window.TTT
"Robert B." wrote:
> I have a report that needs to "jump" to 2 URL's at the same time. I also need
> them to open in a second and third window leaving the first open to the
> orginal report. Can this be done? I have the report right now that can "jump"
> to one of the links in the cell. But it uses the original window.sql
Wednesday, March 28, 2012
Jump to report value for parameter, cube data
facility.
User clicking on field value in report to pass to second report. This works
with the second report showing the value of field user has selected in the
parameter box (Available Values set to non-queried) but report shows an error
of:
restrictions imposed by the constrained flag in the STRTOSET function were
violated
Have tried many settings to correct this but with no luck. Does anybody
know how to correct this problem.
Thanks
IanIn case this is helpful to others I have found that the field parameter was
causing the problem. I was using Fields!FieldName.Value and should have used
Fields!FieldName.UniqueName
Ian
"IanP" wrote:
> Have a problem with passing information between reports using Jump to report
> facility.
> User clicking on field value in report to pass to second report. This works
> with the second report showing the value of field user has selected in the
> parameter box (Available Values set to non-queried) but report shows an error
> of:
> restrictions imposed by the constrained flag in the STRTOSET function were
> violated
> Have tried many settings to correct this but with no luck. Does anybody
> know how to correct this problem.
> Thanks
> Ian
Jump To Report (specific bookmark)
Is there a way to jump from one report to a specific bookmark in the second report? I have a chart that jumps quite nicely to a filtered version of the report, but instead would like to be able to jump to the entire report at the specific location (e.g., Bookmark) related to the chart data item.
I know that it's quite easy to jump to a bookmark within the same report. What I can't quite determine is how to jump from one report to a specific section in a second report.
Thanks.
Jumping to another report (drillthrough) and to a specific bookmark at the same time is currently not supported.
-- Robert
|||Robert -
Is it possible to jump to a bookmark location on a report via a URL?
Paul
sqlJump To Report (specific bookmark)
Is there a way to jump from one report to a specific bookmark in the second report? I have a chart that jumps quite nicely to a filtered version of the report, but instead would like to be able to jump to the entire report at the specific location (e.g., Bookmark) related to the chart data item.
I know that it's quite easy to jump to a bookmark within the same report. What I can't quite determine is how to jump from one report to a specific section in a second report.
Thanks.
Jumping to another report (drillthrough) and to a specific bookmark at the same time is currently not supported.
-- Robert
|||Robert -
Is it possible to jump to a bookmark location on a report via a URL?
Paul
Friday, March 23, 2012
Joining two tables
Can anyone tell how to join two tables where first table is in db1
and second table in db2..
Looking forward for ur response..
Thanx in advance...
SELECT *
FROM [DB1].[dbo].[Table1] A
JOIN [DB2].[dbo].[Table2] B
ON A.[Key] = B.[Key]
Nik Marshall-Blank MCSD/MCDBA
"Prince" <princevictor.moses@.gmail.com> wrote in message
news:1128077633.696943.139960@.z14g2000cwz.googlegr oups.com...
> Hi all,
> Can anyone tell how to join two tables where first table is in db1
> and second table in db2..
> Looking forward for ur response..
> Thanx in advance...
>
|||Hi marshall...
Thanx for ur response...
Joining two tables
Can anyone tell how to join two tables where first table is in db1
and second table in db2..
Looking forward for ur response..
Thanx in advance...SELECT *
FROM [DB1].[dbo].[Table1] A
JOIN [DB2].[dbo].[Table2] B
ON A.[Key] = B.[Key]
Nik Marshall-Blank MCSD/MCDBA
"Prince" <princevictor.moses@.gmail.com> wrote in message
news:1128077633.696943.139960@.z14g2000cwz.googlegroups.com...
> Hi all,
> Can anyone tell how to join two tables where first table is in db1
> and second table in db2..
> Looking forward for ur response..
> Thanx in advance...
>|||Hi marshall...
Thanx for ur response...
Wednesday, March 21, 2012
Joining two tables
Can anyone tell how to join two tables where first table is in db1
and second table in db2..
Looking forward for ur response..
Thanx in advance...SELECT *
FROM [DB1].[dbo].[Table1] A
JOIN [DB2].[dbo].[Table2] B
ON A.[Key] = B.[Key]
--
Nik Marshall-Blank MCSD/MCDBA
"Prince" <princevictor.moses@.gmail.com> wrote in message
news:1128077633.696943.139960@.z14g2000cwz.googlegroups.com...
> Hi all,
> Can anyone tell how to join two tables where first table is in db1
> and second table in db2..
> Looking forward for ur response..
> Thanx in advance...
>|||Hi marshall...
Thanx for ur response...
Monday, March 12, 2012
Joining a web farm
got the first one working. When activating the second server from the first
with "rsconfig -m <RemoteMachineName> etc. I get the error message " Failure
obtaining information from remote WMI provider: Unable to find Reporting
Services WMI namespace on <machinename>. Reporting services may not be
installed."
WMI service and reportserver service is running.Dear Victoria,
We banged our heads against the wall with this problem.
At the end of the day this is what helped us
IN EXACTLY this sequence. If you get the sequence off it will not work.
1. Delete the two GUID entries from the keys table corresponding to the node
you want to reactivae.
2. transfer the symmetric key from the server that is working to the server
that is not working with the RSkeymgmt Utility.
i.e.
a. run:
RSkeymgmt -e -fc:\keys.txt
-ppassword
(this line should have only
three spaces)
on the valid server (farm member)
b. copy the keys.txt file over to the
server you are
trying to reactivate.
c. run
RSkeymgmt -a fc:\keys.txt
-ppassword
on the server you are trying to
reactivate.
d. Restart the ReportServer
e.run the rsreactivate Utility from the
server that is a valid farm member
(it should work at this point)
"Victoria" wrote:
> I have two servers in a web farm. Installation went fine on both servers and
> got the first one working. When activating the second server from the first
> with "rsconfig -m <RemoteMachineName> etc. I get the error message " Failure
> obtaining information from remote WMI provider: Unable to find Reporting
> Services WMI namespace on <machinename>. Reporting services may not be
> installed."
> WMI service and reportserver service is running.
>