Thank you Bruce L-C [MVP], as you replied to one of my post: how to open web
page in new window using Jump to URL.
= "javascript:window.open('http://www.google.com')"
This works fine. It opens new window for google; but the main page where
reports were listed loses its data and shows "[object]".
When I click "Back" button, it again lists reports.
Any Idea?Try this:
= "javascript:void(window.open('http://www.google.com'))"
"RA" wrote:
> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
web
> page in new window using Jump to URL.
> = "javascript:window.open('http://www.google.com')"
> This works fine. It opens new window for google; but the main page where
> reports were listed loses its data and shows "[object]".
> When I click "Back" button, it again lists reports.
> Any Idea?|||Thanks a lot,
That worked.
"goinoutwest" <goinoutwest@.hotmail.com> wrote in message
news:u$7mzEbzEHA.260@.TK2MSFTNGP11.phx.gbl...
> Try this:
> = "javascript:void(window.open('http://www.google.com'))"
>
> "RA" wrote:
>> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
> web
>> page in new window using Jump to URL.
>> = "javascript:window.open('http://www.google.com')"
>> This works fine. It opens new window for google; but the main page where
>> reports were listed loses its data and shows "[object]".
>> When I click "Back" button, it again lists reports.
>> Any Idea?
>|||This works only on the reportserver, i.e. when i view reports
http://servername/reportserver/... but the java scrip doesnt work when i view
reports on the report manager like this http://servername/reports/..
Plz suggest somethng
"RA" wrote:
> Thanks a lot,
> That worked.
> "goinoutwest" <goinoutwest@.hotmail.com> wrote in message
> news:u$7mzEbzEHA.260@.TK2MSFTNGP11.phx.gbl...
> > Try this:
> >
> > = "javascript:void(window.open('http://www.google.com'))"
> >
> >
> > "RA" wrote:
> >> Thank you Bruce L-C [MVP], as you replied to one of my post: how to open
> > web
> >> page in new window using Jump to URL.
> >>
> >> = "javascript:window.open('http://www.google.com')"
> >>
> >> This works fine. It opens new window for google; but the main page where
> >> reports were listed loses its data and shows "[object]".
> >>
> >> When I click "Back" button, it again lists reports.
> >>
> >> Any Idea?
> >
> >
>
>
Showing posts with label web. Show all posts
Showing posts with label web. Show all posts
Friday, March 30, 2012
Jump to URL
Hi,
I want to navigate to a webpage from my report. On clicking a report field that web page should be opened. I have written the following code,
Function OpenWindow (ByVal DealerId as Integer,ByVal CustomerNo as string,ByVal InvoiceNo as string, ByVal CustomerType as string,ByVal CustomerStatus as string,ByVal AppilcationName as string,ByVal UserId as string,ByVal CallStatus as string)as String
Dim strURL as String
Dim strTargetURL as String
Dim strFeatures as String
If CustomerType = "EXTERNAL" and CustomerStatus <> "Completed"
strURL = AppilcationName & "?" & "DealerId="& DealerId &"&CustomerNo="&CustomerNo &"&InvoiceNo="&InvoiceNo & "&UserId=" & UserId & "&CallStatus=" &CallStatus
strTargetURL = "javascript:void(window.open('"
strTargetURL = strTargetURL & strURL & "'"
strTargetURL = strTargetURL & ",'',"
strFeatures = "' width=1000,height=720,scrollbars=yes, status=no, toolbar=no, resizable=no, left=0, top=0'"
strTargetURL = strTargetURL & strFeatures
strTargetURL = strTargetURL & ",'_blank'));"
End If
Return strTargetURL
End Function
Now If I click the report field my web page is opening in a new page. But if I select the option "Open in New Window" an empty page as well as my web page is being opened. How to avoid the opening of empty page.
Help of any kind to this problem is welcome
Thanks in Advance,
Sivaatzenith
It seems that you should maybe just assign the href of the url, and not use the javascript. Personally, I don't like it when a site wants to size and/or position a window with/without various options... I guess I kookie like that :)
|||Hi Ben,
Thanks for your reply
Can you pls give a sample containing the href in jump to url code
Regards
Sivaatzenith
|||
Sivaatzenith,
My thought was that in your OpenWindow code, you omit the javascript code...
So perhaps:
strTargetURL = "javascript:void(window.open('"
strTargetURL = strTargetURL & strURL & "'"
strTargetURL = strTargetURL & ",'',"
strFeatures = "' width=1000,height=720,scrollbars=yes, status=no, toolbar=no, resizable=no, left=0, top=0'"
strTargetURL = strTargetURL & strFeatures
strTargetURL = strTargetURL & ",'_blank'));"
becomes:
strTargetURL = strURL
I am not really sure if this will work in Sql Reporting Services or not...
Good Luck
|||hi,
Thanks for ur reply... First I had given the following code in jump to URL
STRURL ="http:mail.yahoo.com"
Mine is a web application. The reports will be launched by web application which is in .net.These reports will be shown in report viewer ctrl. This report will also contain subreport, which will be displayed on clicking of a textbox. When I click this textbox to view the sub report and after that press the link (jump to url) I am getting a java script error... Actually thats a problem with report viewer after googling I found out that microsoft has provided a hot fix for this which is extra money. So I tried this.
Any other solution is welcome.. I tired using <a href also. but of no use... I am getting a run time error.
Thanks in advance
Sivaatzenith
|||
I apologize that I am not more familiar with reporting services, what is your specific javascript error?
|||hi Ben,
If I click the link, my desired web page is opened in a new browser. But If I select the option "Open in a new page" an empty browser as well as my page is opened. I need to avoid this empty page.
Thanks in Advance,
Sivaatzenith.
Monday, March 19, 2012
Joining one database table with other database table in stroed procedures.
Hi All,
I need to perform a join on table1 of database1 with table2 or database2, in a stored procedure and return to my web application.. For this I'm providing execute permission on stored procedure, in database1 and "SELECT" permission on database2 table 2, to my database webuser.
Is there any way ( Another stored procedure in database2), i can get join on two tables without SELECT permission right on table2 ( or table1).
Purely using stored procedures. If so how?Normally you only need to grant execute permission on a stored procedure not select permission on the underlying tables.
Past that I would setup a sp to on database1 to return the data and make sure the webuser has an a security path from database1 to database2. How do yo uhave security setup for this user on databse1 and database2?|||Hi Paul,
Thanks, What is meant by security path? I didnot get ur point.
User have only public permission on both databases. Is it not enough? I do have execute permission on sp1 (Stored Procedure) in database1.
but in sp1 I have a select statement which is a join on database2 table-'table2'. When I tried to execute sp1 from web application only with execute permission on sp1-
I got an error as Webuser does not have 'SELECT' permission on table2 of database2. So I provided it and sp1 worked fine. But I don't want to use a SELECT permission- What is alternate, for the join.
sp1 has simple
SELECT *
FROM database1.dbo.table1 t1
INNER JOIN database2.dbo.table2 t2
ON (t1.col1 = t2.col1)
Originally posted by Paul Young
Normally you only need to grant execute permission on a stored procedure not select permission on the underlying tables.
Past that I would setup a sp to on database1 to return the data and make sure the webuser has an a security path from database1 to database2. How do yo uhave security setup for this user on databse1 and database2?|||by security path I was refering to how a user gets authenticated on server2 when making a connection from server1.
You might try using OPENQUERY to call a stored procedure on server2 and use the results to join to a table on server1. I haven't had the need for this in the past so I am working on theory here. Check BOL for usage on OPENQUERY, they have some good examples.|||When calling a stored proc from database 1, you need execute privs on the proc. You do not need to give the user privs on the table itself as long as it is in database 1, too. If database 2 is owned by the same user that is the owner of database 1, you do not need explicit permissions on the object in table 2 accessed by the proc. However, if the database owners are different for the two databases, the user calling the proc must have explicit permissions in the second database.
If need be, you can change the database owner by:
EXEC sp_changedbowner 'username'
Execute this in the database you want to change.|||Well Both databases are on same server. Is OPENQUERY solve in this case too?|||Originally posted by soumyag
Well Both databases are on same server.
It doesn't matter what server they are on, the owner of the databases is what matters. You can have multiple databases on the same server with different owners. In query analyzer, run:
sp_helpdb
It will list the owner for each of the databases. If the owner is different, run sp_changedbowner to set them the same.|||Hi,
Both are on same server, but owned by different users. And I don't have any right to change the dbowners But how it will help in writing a join on tables. What is other alternative way to solve this problem.
Thanks.
Originally posted by bglass
It doesn't matter what server they are on, the owner of the databases is what matters. You can have multiple databases on the same server with different owners. In query analyzer, run:
sp_helpdb
It will list the owner for each of the databases. If the owner is different, run sp_changedbowner to set them the same.
I need to perform a join on table1 of database1 with table2 or database2, in a stored procedure and return to my web application.. For this I'm providing execute permission on stored procedure, in database1 and "SELECT" permission on database2 table 2, to my database webuser.
Is there any way ( Another stored procedure in database2), i can get join on two tables without SELECT permission right on table2 ( or table1).
Purely using stored procedures. If so how?Normally you only need to grant execute permission on a stored procedure not select permission on the underlying tables.
Past that I would setup a sp to on database1 to return the data and make sure the webuser has an a security path from database1 to database2. How do yo uhave security setup for this user on databse1 and database2?|||Hi Paul,
Thanks, What is meant by security path? I didnot get ur point.
User have only public permission on both databases. Is it not enough? I do have execute permission on sp1 (Stored Procedure) in database1.
but in sp1 I have a select statement which is a join on database2 table-'table2'. When I tried to execute sp1 from web application only with execute permission on sp1-
I got an error as Webuser does not have 'SELECT' permission on table2 of database2. So I provided it and sp1 worked fine. But I don't want to use a SELECT permission- What is alternate, for the join.
sp1 has simple
SELECT *
FROM database1.dbo.table1 t1
INNER JOIN database2.dbo.table2 t2
ON (t1.col1 = t2.col1)
Originally posted by Paul Young
Normally you only need to grant execute permission on a stored procedure not select permission on the underlying tables.
Past that I would setup a sp to on database1 to return the data and make sure the webuser has an a security path from database1 to database2. How do yo uhave security setup for this user on databse1 and database2?|||by security path I was refering to how a user gets authenticated on server2 when making a connection from server1.
You might try using OPENQUERY to call a stored procedure on server2 and use the results to join to a table on server1. I haven't had the need for this in the past so I am working on theory here. Check BOL for usage on OPENQUERY, they have some good examples.|||When calling a stored proc from database 1, you need execute privs on the proc. You do not need to give the user privs on the table itself as long as it is in database 1, too. If database 2 is owned by the same user that is the owner of database 1, you do not need explicit permissions on the object in table 2 accessed by the proc. However, if the database owners are different for the two databases, the user calling the proc must have explicit permissions in the second database.
If need be, you can change the database owner by:
EXEC sp_changedbowner 'username'
Execute this in the database you want to change.|||Well Both databases are on same server. Is OPENQUERY solve in this case too?|||Originally posted by soumyag
Well Both databases are on same server.
It doesn't matter what server they are on, the owner of the databases is what matters. You can have multiple databases on the same server with different owners. In query analyzer, run:
sp_helpdb
It will list the owner for each of the databases. If the owner is different, run sp_changedbowner to set them the same.|||Hi,
Both are on same server, but owned by different users. And I don't have any right to change the dbowners But how it will help in writing a join on tables. What is other alternative way to solve this problem.
Thanks.
Originally posted by bglass
It doesn't matter what server they are on, the owner of the databases is what matters. You can have multiple databases on the same server with different owners. In query analyzer, run:
sp_helpdb
It will list the owner for each of the databases. If the owner is different, run sp_changedbowner to set them the same.
Monday, March 12, 2012
Joining a web farm
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.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.
>
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.
>
Friday, March 9, 2012
JOIN two Datasets?
I would like to perform an inner join on two seperate datasets. One dataset
gets its data from SQL server, the other gets its data from a XML web
service.Can't do this. You might consider using a sub report. A sub report can be
put into the table object cells.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jeff Richardson" <BobcatRidge@.newsgroups.nospam> wrote in message
news:O63%23UQuxGHA.3464@.TK2MSFTNGP03.phx.gbl...
>I would like to perform an inner join on two seperate datasets. One
>dataset gets its data from SQL server, the other gets its data from a XML
>web service.
>|||Thanks.
I have not tried the sub-report route because I assumed that you would get
all rows from the parent dataset even if the sub-report contained no rows.
Is there a way to that the parent rows are only displayed when the
sub-report has rows?
Thanks
Jeff.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u1qBZauxGHA.3456@.TK2MSFTNGP03.phx.gbl...
> Can't do this. You might consider using a sub report. A sub report can be
> put into the table object cells.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jeff Richardson" <BobcatRidge@.newsgroups.nospam> wrote in message
> news:O63%23UQuxGHA.3464@.TK2MSFTNGP03.phx.gbl...
>>I would like to perform an inner join on two seperate datasets. One
>>dataset gets its data from SQL server, the other gets its data from a XML
>>web service.
>|||Hi Jeff,
Although you could not control the visibility of a textbox with the
Subreport, you could add another dataset to control the visibility.
The dataset should be the same as the the one you use in the sub report.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
gets its data from SQL server, the other gets its data from a XML web
service.Can't do this. You might consider using a sub report. A sub report can be
put into the table object cells.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jeff Richardson" <BobcatRidge@.newsgroups.nospam> wrote in message
news:O63%23UQuxGHA.3464@.TK2MSFTNGP03.phx.gbl...
>I would like to perform an inner join on two seperate datasets. One
>dataset gets its data from SQL server, the other gets its data from a XML
>web service.
>|||Thanks.
I have not tried the sub-report route because I assumed that you would get
all rows from the parent dataset even if the sub-report contained no rows.
Is there a way to that the parent rows are only displayed when the
sub-report has rows?
Thanks
Jeff.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u1qBZauxGHA.3456@.TK2MSFTNGP03.phx.gbl...
> Can't do this. You might consider using a sub report. A sub report can be
> put into the table object cells.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jeff Richardson" <BobcatRidge@.newsgroups.nospam> wrote in message
> news:O63%23UQuxGHA.3464@.TK2MSFTNGP03.phx.gbl...
>>I would like to perform an inner join on two seperate datasets. One
>>dataset gets its data from SQL server, the other gets its data from a XML
>>web service.
>|||Hi Jeff,
Although you could not control the visibility of a textbox with the
Subreport, you could add another dataset to control the visibility.
The dataset should be the same as the the one you use in the sub report.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)