Friday, March 30, 2012

jumping to a report

I have a wierd problem here.
I am using jump to a report feature and passed 2 parameters to the report.
It works fine in the review but when i see that in the webpage (i did using
reportviewer) it does not show the report and gets to the first page of the
report.
Please help me outNow I'm the report developer, not the coder, so my explanation may not
be the most detailed. It's a page post back issue. I'm assuming your
using aspx, and refreshing the page every time your report changes.
You need to include an 'ispostback = false' so the entire page doesn't
post back, just the report. It solved our issues. Hope this helps
Smith

Jumping drill-down report

I have a report with drill down grouped data and static header with
interactive sorting enabled.
1. When the user expands (by clicking + image) some groups and click on
table header for sorting, all the drill-down details which were expanded get
collapsed, can we configure the report to show the report in the same state
with expanded/collapsed data after sorted?
2. When the user click on the '+' symbol to exand the details with static
header and scrolled to the bottom, the report jumps and the selected row
gets hidden behind the header. How can we fix this?
Thanks and Regards,
SridharI also suffer with that problem and wrote the same thing to many other
places as well as this group but had no response. I have also
installed Sql Server SP2 and VS SP1.

Jump tol URL and javascript

Hi
We have a strange problem. In our report we have a picture that has
its Jump to URL property set to ="javascript:history.go(-1)".
It works fine on my developing machine but when we run the report on
server we get the following error:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
The url javascript:history.go(-1) has an invalid schema. URLs in reports may
only use http://, https://, ftp://, mailto: or news:
(rsUnsupportedURLProtocol) Get Online Help
What is wrong? Please help.
Regards
MasseThis looks like you are running RS 2000 RTM (version 08.00.0743) on the
report server. You will need SP1 or SP2 installed to allow the javascript:
protocol.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Masse" <Masse@.discussions.microsoft.com> wrote in message
news:6D8BB50B-AF74-4F17-A15E-CFA06A5185C7@.microsoft.com...
> Hi
> We have a strange problem. In our report we have a picture that has
> its Jump to URL property set to ="javascript:history.go(-1)".
> It works fine on my developing machine but when we run the report on
> server we get the following error:
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> The url javascript:history.go(-1) has an invalid schema. URLs in reports
> may
> only use http://, https://, ftp://, mailto: or news:
> (rsUnsupportedURLProtocol) Get Online Help
> What is wrong? Please help.
> Regards
> Masse
>

Jump to URL's

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.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

Jump to URL: Opens new window but.....

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?
> >
> >
>
>

Jump to URL...

Hey All,
I have a report that tells the user all of the applied published fixes
that are out there. The report has an ODBC connect to a .txt file on a
defferent server. That is finally working great (i hate permissions
:)). Now I have to take the Fix_nbr field (which is a calculated field)
and add a hyperlink to it. User is to click on the fix number in the
report and it should go to the defferent server and pick up the HTM
file about that particular fix number and display it to the user. What
happens is when I click on the fix number, the sign in box for the
defferent server comes up, I sign in...then I get "Page Cannot be
Found...HTTP Error 404 - File or directory not found."
The expression below is what I am using and I have tried different
variations of this.
="http://cmbsssharrisdev/Fixes/Applied - Published/" &
Fields!Fix_Nbr.Value & ".htm"
Anyone have any suggestions of why this might be happening, any help
would be great!
I have to have this done by EOD tomorrow.
Thanks in advance!!!!
KerrieCheck in the IIS logs of the different server and see what URL you are
actually attempting to view. Could it be that you need to put %20 in for the
spaces in the url?
"Kerrie" wrote:
> Hey All,
> I have a report that tells the user all of the applied published fixes
> that are out there. The report has an ODBC connect to a .txt file on a
> defferent server. That is finally working great (i hate permissions
> :)). Now I have to take the Fix_nbr field (which is a calculated field)
> and add a hyperlink to it. User is to click on the fix number in the
> report and it should go to the defferent server and pick up the HTM
> file about that particular fix number and display it to the user. What
> happens is when I click on the fix number, the sign in box for the
> defferent server comes up, I sign in...then I get "Page Cannot be
> Found...HTTP Error 404 - File or directory not found."
> The expression below is what I am using and I have tried different
> variations of this.
> ="http://cmbsssharrisdev/Fixes/Applied - Published/" &
> Fields!Fix_Nbr.Value & ".htm"
> Anyone have any suggestions of why this might be happening, any help
> would be great!
> I have to have this done by EOD tomorrow.
> Thanks in advance!!!!
> Kerrie
>|||I tried what you have suggested and it did not help. Any other
suggestions?
Do you think maybe that it is a HTM file i am trying to get from a
shared folder from a different server?
lsmithmier wrote:
> Check in the IIS logs of the different server and see what URL you are
> actually attempting to view. Could it be that you need to put %20 in for the
> spaces in the url?
> "Kerrie" wrote:
> > Hey All,
> >
> > I have a report that tells the user all of the applied published fixes
> > that are out there. The report has an ODBC connect to a .txt file on a
> > defferent server. That is finally working great (i hate permissions
> > :)). Now I have to take the Fix_nbr field (which is a calculated field)
> > and add a hyperlink to it. User is to click on the fix number in the
> > report and it should go to the defferent server and pick up the HTM
> > file about that particular fix number and display it to the user. What
> > happens is when I click on the fix number, the sign in box for the
> > defferent server comes up, I sign in...then I get "Page Cannot be
> > Found...HTTP Error 404 - File or directory not found."
> >
> > The expression below is what I am using and I have tried different
> > variations of this.
> >
> > ="http://cmbsssharrisdev/Fixes/Applied - Published/" &
> > Fields!Fix_Nbr.Value & ".htm"
> >
> > Anyone have any suggestions of why this might be happening, any help
> > would be great!
> > I have to have this done by EOD tomorrow.
> >
> > Thanks in advance!!!!
> > Kerrie
> >
> >|||NEVERMIND...I GOT IT WORKING! The directory was not regisiter through
IIS!!!
THANKS SO MUCH FOR THE SUGGESTION!
Kerrie wrote:
> I tried what you have suggested and it did not help. Any other
> suggestions?
> Do you think maybe that it is a HTM file i am trying to get from a
> shared folder from a different server?
>
> lsmithmier wrote:
> > Check in the IIS logs of the different server and see what URL you are
> > actually attempting to view. Could it be that you need to put %20 in for the
> > spaces in the url?
> >
> > "Kerrie" wrote:
> >
> > > Hey All,
> > >
> > > I have a report that tells the user all of the applied published fixes
> > > that are out there. The report has an ODBC connect to a .txt file on a
> > > defferent server. That is finally working great (i hate permissions
> > > :)). Now I have to take the Fix_nbr field (which is a calculated field)
> > > and add a hyperlink to it. User is to click on the fix number in the
> > > report and it should go to the defferent server and pick up the HTM
> > > file about that particular fix number and display it to the user. What
> > > happens is when I click on the fix number, the sign in box for the
> > > defferent server comes up, I sign in...then I get "Page Cannot be
> > > Found...HTTP Error 404 - File or directory not found."
> > >
> > > The expression below is what I am using and I have tried different
> > > variations of this.
> > >
> > > ="http://cmbsssharrisdev/Fixes/Applied - Published/" &
> > > Fields!Fix_Nbr.Value & ".htm"
> > >
> > > Anyone have any suggestions of why this might be happening, any help
> > > would be great!
> > > I have to have this done by EOD tomorrow.
> > >
> > > Thanks in advance!!!!
> > > Kerrie
> > >
> > >

Jump to URL with new window

How can I jump to URL with new window?
Is anyway can do this?
I'm try to use &rc:targetlink=new
but it dosen't work.
how can I do this?
Thanks for any advice!
AngiHere is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
You need SP1 or SP2 if using SQL Server 2000 (this feature was added with
the release of SP1)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Angi" <enchiw@.msn.com> wrote in message
news:%236aWVy1CGHA.3876@.tk2msftngp13.phx.gbl...
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>|||Try the following URL
How to open hyperlink in a new window in Reporting Services Report (RS with
SP1 or higher)
http://binaryworld.net/Main/CodeDetail.aspx?CodeId=4012
--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform
"Angi" wrote:
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>
>|||Thanks Bruce & Nayan!
And now I have a new way for Jump to URL, for you refernce!
="javascript:void(window.open('http://Domain/ReportServer/Pages/ReportViewer.aspx?%2fBIGS%2f02bar&rs:Command=Render&rc:Toolbar=false','_blank',
'toolbar=no,location=no,directories=no,status=yes,menubar=no,scrollbar=yes,resizable=yes,copyhistory=no'))"
No IE toolbar and RS toolbar.
Thanks again!
Angi
"Angi" <enchiw@.msn.com> ¼¶¼g©ó¶l¥ó·s»D:%236aWVy1CGHA.3876@.tk2msftngp13.phx.gbl...
> How can I jump to URL with new window?
> Is anyway can do this?
> I'm try to use &rc:targetlink=new
> but it dosen't work.
> how can I do this?
> Thanks for any advice!
> Angi
>