Is it possible to launch a report rendered in excel or pdf instead of report viewer?

On my reporting services website, I would like to browse to a report,
click on it and have it render to excel or pdf by instead of report
viewer. Is this possible? I know that I can create rs scripts that run
a report and render to excel, but would like to users to experience
this on the web if possible. I couldn't find this option.you can try to send the format you want in the URL:
http://localhost/......&rs:Format=Excel
"steve" <stevensherman@.comcast.net> wrote in message
news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> On my reporting services website, I would like to browse to a report,
> click on it and have it render to excel or pdf by instead of report
> viewer. Is this possible? I know that I can create rs scripts that run
> a report and render to excel, but would like to users to experience
> this on the web if possible. I couldn't find this option.
>|||Putting the format in the url works nicely. Thanks for the reply - that
helps. I was hoping that the report manager would have a configuration
setting for a report that would indicate how to render it.
Jeje wrote:
> you can try to send the format you want in the URL:
> http://localhost/......&rs:Format=Excel
>
> "steve" <stevensherman@.comcast.net> wrote in message
> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
> > On my reporting services website, I would like to browse to a report,
> > click on it and have it render to excel or pdf by instead of report
> > viewer. Is this possible? I know that I can create rs scripts that run
> > a report and render to excel, but would like to users to experience
> > this on the web if possible. I couldn't find this option.
> >|||I'm not sure, maybe you'll found in the config files of your reporting
services installation the default rendering format.
I'm sure there is a list of authorized formats, so I presume there is a
default rendering option.
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>|||Report manager is not configurable that way. You have to create your own
portal if you want to do that. I recommend against doing this. HTML is much
much faster and having all your reports default to PDF is just not a good
idea.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"steve" <stevensherman@.comcast.net> wrote in message
news:1165768599.615241.90010@.j44g2000cwa.googlegroups.com...
> Putting the format in the url works nicely. Thanks for the reply - that
> helps. I was hoping that the report manager would have a configuration
> setting for a report that would indicate how to render it.
>
> Jeje wrote:
>> you can try to send the format you want in the URL:
>> http://localhost/......&rs:Format=Excel
>>
>> "steve" <stevensherman@.comcast.net> wrote in message
>> news:1165705966.309429.275880@.16g2000cwy.googlegroups.com...
>> > On my reporting services website, I would like to browse to a report,
>> > click on it and have it render to excel or pdf by instead of report
>> > viewer. Is this possible? I know that I can create rs scripts that run
>> > a report and render to excel, but would like to users to experience
>> > this on the web if possible. I couldn't find this option.
>> >
>sql

Is it possible to keep the page header at top of browser page with drill enabled?

When I click a drilldown [+] on a report in the browser the page starts
at the point where I start (click) the drill. Everything above the
click-point is above and I have to scroll up to see it. Is there a way
to keep the heading visible on a report using drill?RS 2005 will provide floating headers on table or matrix which may be close
to what you are looking for. For RS 2000 I can't think of anything that
would do it - unless you try to write your own "report viewing" application
which shows the required context information outside the boundaries where
you show the report contents.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Merkin" <flyin_merkin@.yahoo.com> wrote in message
news:1112206546.496405.301270@.f14g2000cwb.googlegroups.com...
> When I click a drilldown [+] on a report in the browser the page starts
> at the point where I start (click) the drill. Everything above the
> click-point is above and I have to scroll up to see it. Is there a way
> to keep the heading visible on a report using drill?
>

Is it possible to hide the report parameters after click on the view report button?

i am working in SQL Reporting services 2005. i had a requirement that
after selecting all the report paramters and click on the view report
button, i need to turn off or hide the report parameters.
please let me know is it possible to implement to do this.
any suggesstion
Thanks
VinodThere is a button the right side of the page of the reports browser
that look like to arrows on top of each other, click that and it will
hide the parameters. There are actually two sets, one for the
parameters and one for the web page header. Hope that helps.
Vinod wrote:
> i am working in SQL Reporting services 2005. i had a requirement that
> after selecting all the report paramters and click on the view report
> button, i need to turn off or hide the report parameters.
> please let me know is it possible to implement to do this.
> any suggesstion
> Thanks
> Vinod|||Thanks for the reply Kerrie.
i have seen the hide button icon in the report layout.but my
requirement is that i need to hide the parameters when i click on the
view report button in the report layout after selecting the all the
report parameters.
if user wants to modify the criteria again, he needs to click on the
hide icon in the report layout. then select the criteria and view the
report.
please let me know if you are not clear
Thanks
vinod
Kerrie wrote:
> There is a button the right side of the page of the reports browser
> that look like to arrows on top of each other, click that and it will
> hide the parameters. There are actually two sets, one for the
> parameters and one for the web page header. Hope that helps.
>
> Vinod wrote:
> > i am working in SQL Reporting services 2005. i had a requirement that
> > after selecting all the report paramters and click on the view report
> > button, i need to turn off or hide the report parameters.
> >
> > please let me know is it possible to implement to do this.
> >
> > any suggesstion
> >
> > Thanks
> > Vinod|||I'm pretty sure there's no function like that in RS out of the box. But I'm
thinking that if you can modify the View Report button's code, you could add
a java script that redirects to a url with parameters toolbar=false and the
chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
how easy that is.
Alternatively, create a aspx. page that creates the parameters to be chosen,
and send the users to a report using the same paramtererized url as
suggested above.
Kaisa M. Lindahl Lervik
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> Thanks for the reply Kerrie.
> i have seen the hide button icon in the report layout.but my
> requirement is that i need to hide the parameters when i click on the
> view report button in the report layout after selecting the all the
> report parameters.
> if user wants to modify the criteria again, he needs to click on the
> hide icon in the report layout. then select the criteria and view the
> report.
> please let me know if you are not clear
> Thanks
> vinod
>
> Kerrie wrote:
>> There is a button the right side of the page of the reports browser
>> that look like to arrows on top of each other, click that and it will
>> hide the parameters. There are actually two sets, one for the
>> parameters and one for the web page header. Hope that helps.
>>
>> Vinod wrote:
>> > i am working in SQL Reporting services 2005. i had a requirement that
>> > after selecting all the report paramters and click on the view report
>> > button, i need to turn off or hide the report parameters.
>> >
>> > please let me know is it possible to implement to do this.
>> >
>> > any suggesstion
>> >
>> > Thanks
>> > Vinod
>|||Thanks for the reply Kaisa.
i am not creating a aspx page for criteria. i have added 15 report
parameters in the report layout iteself. everything is fine upto this
point.
but my client requriment is that we dont want to show the report
parameters in the report layout after clicking on the view report
button. it should be hided.
let me know is it possible.
Thanks
Vinod
Kaisa M. Lindahl Lervik wrote:
> I'm pretty sure there's no function like that in RS out of the box. But I'm
> thinking that if you can modify the View Report button's code, you could add
> a java script that redirects to a url with parameters toolbar=false and the
> chosen parameters. You'd have to tweek the RS GUI to do it, and I don't know
> how easy that is.
> Alternatively, create a aspx. page that creates the parameters to be chosen,
> and send the users to a report using the same paramtererized url as
> suggested above.
> Kaisa M. Lindahl Lervik
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161352815.498895.319680@.h48g2000cwc.googlegroups.com...
> > Thanks for the reply Kerrie.
> >
> > i have seen the hide button icon in the report layout.but my
> > requirement is that i need to hide the parameters when i click on the
> > view report button in the report layout after selecting the all the
> > report parameters.
> >
> > if user wants to modify the criteria again, he needs to click on the
> > hide icon in the report layout. then select the criteria and view the
> > report.
> >
> > please let me know if you are not clear
> >
> > Thanks
> > vinod
> >
> >
> > Kerrie wrote:
> >> There is a button the right side of the page of the reports browser
> >> that look like to arrows on top of each other, click that and it will
> >> hide the parameters. There are actually two sets, one for the
> >> parameters and one for the web page header. Hope that helps.
> >>
> >>
> >> Vinod wrote:
> >> > i am working in SQL Reporting services 2005. i had a requirement that
> >> > after selecting all the report paramters and click on the view report
> >> > button, i need to turn off or hide the report parameters.
> >> >
> >> > please let me know is it possible to implement to do this.
> >> >
> >> > any suggesstion
> >> >
> >> > Thanks
> >> > Vinod
> >

Is it possible to access data associated with a hyperlink in SSIS?

I need to be able to to extract the data that is returned by clicking a hyperlink. I click the link and it displays the data.

I know that SSIS has a web services task, and that appears to be a neat feature, but the link I am connecting to does not have a WSDL file or anything like that. So I think I cannot use this task.

Does anyone have a suggestion about how I might do this?

Thanks for your help,

Harold

What data that is returned by clicking a hyperlink?

What is the hyperlink hosted in?

What defines or restricts this data?

What do you expect to happen to this extracted data?

SSIS is a backend ETL tool, I cannot work out what you would expect it to do for you, in what I am guessing is some kind of web UI

|||

Hello Darren,

Thanks for responding to my post.

I want to read the data that are displayed when I click a hyperlink.

When the package is executed, it should go to the hyperlink (URL) and get the data it displays.

The data that are displayed are:

var imgRates = {"ThirtyFixed":"6.298","FifteenFixed":"5.926","ThirtyFixedJumbo":"6.339","FiveOneARM":"5.831"};

I want to read that string into my package. I will then parse and store it.

Do you know if this can be done?

Thanks,

Harold

|||Your data looks to be a line of code. It doesn;t look very big, and not really what i woudl expct for an ETL source. Just write this in your programming language of choice, forget about SSIS.|||Here is some code that will go to a URL that you provide and read the content into a string.

Code Snippet

Dim webRequest As System.Net.WebRequest = System.Net.HttpWebRequest.Create(Dts.Variables("Url").Value.ToString())
Dim webResponse As System.Net.WebResponse = webRequest.GetResponse()
Dim stream As System.IO.Stream = webResponse.GetResponseStream()
Dim streamReader As New System.IO.StreamReader(stream)
Dim content As String = streamReader.ReadToEnd()

|||

Hello Jay,

The code snippet was just what I needed!

Thanks for your help, and for the others who took time to repond.

Harold