Open or Download a file in Sql Reports Resources using Report Service API

Using the reporting service web service to get the file path for a reports and the report viewer control on a Web page, it is possible to view reports. This works fine. I built a tree view that shows the reports. I also show resource files ( like .xls or .doc files ) that a user may have uploaded to the report directory. I show these filenames in the treeview as well as actual sql reports. If the user clicks on a report name, I set the path in the report viewer control and the report is rendered.

Now I would also like the user to be able to download or open any xls or doc file that may also be in the report directory from this web application.

Is this possible?

Normally in the Report Manager it uses Resources.aspx to download or open the file.

Is there any way to access these files programatically?

thanks

-Barb

Okay I found the answer, it is using the Report Web ServicegetResourceContents()

-Barb

Open Connection

Hi to all,
I know that we should close sql connection when it's complete its job for
performance and sql server's resources. But i can't find article or text
for
this subject on the internet. Or i know not true?
Could you share with me if you have like this article ?For internet applications you should use connection pooling, and close your
connection as soon as you are finished. The provider (or driver) will
automatically keep the connection open for you and re-use it if you open
another connection using the same connection string within the connection
pool timeout period. Just search for "SQL Server connection pooling" and
I'm sure you will find more information
"Erencan SAIROLU" <erencans@.hotmail.com> wrote in message
news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
> Hi to all,
> I know that we should close sql connection when it's complete its job for
> performance and sql server's resources. But i can't find article or text
> for
> this subject on the internet. Or i know not true?
> Could you share with me if you have like this article ?
>|||Thank you Brain
"Brian Pursley" <bp@.cinlogic.com> wrote in message
news:eS5EPNj%23GHA.4800@.TK2MSFTNGP05.phx.gbl...
> For internet applications you should use connection pooling, and close
> your connection as soon as you are finished. The provider (or driver)
> will automatically keep the connection open for you and re-use it if you
> open another connection using the same connection string within the
> connection pool timeout period. Just search for "SQL Server connection
> pooling" and I'm sure you will find more information
> "Erencan SAIROLU" <erencans@.hotmail.com> wrote in message
> news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
>

Open Connection

Hi to all,
I know that we should close sql connection when it's complete its job for
performance and sql server's resources. But i can't find article or text
for
this subject on the internet. Or i know not true?
Could you share with me if you have like this article ?For internet applications you should use connection pooling, and close your
connection as soon as you are finished. The provider (or driver) will
automatically keep the connection open for you and re-use it if you open
another connection using the same connection string within the connection
pool timeout period. Just search for "SQL Server connection pooling" and
I'm sure you will find more information
"Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
> Hi to all,
> I know that we should close sql connection when it's complete its job for
> performance and sql server's resources. But i can't find article or text
> for
> this subject on the internet. Or i know not true?
> Could you share with me if you have like this article ?
>|||Thank you Brain
"Brian Pursley" <bp@.cinlogic.com> wrote in message
news:eS5EPNj%23GHA.4800@.TK2MSFTNGP05.phx.gbl...
> For internet applications you should use connection pooling, and close
> your connection as soon as you are finished. The provider (or driver)
> will automatically keep the connection open for you and re-use it if you
> open another connection using the same connection string within the
> connection pool timeout period. Just search for "SQL Server connection
> pooling" and I'm sure you will find more information
> "Erencan SAÐIROÐLU" <erencans@.hotmail.com> wrote in message
> news:uaeY1jc%23GHA.5092@.TK2MSFTNGP04.phx.gbl...
>> Hi to all,
>> I know that we should close sql connection when it's complete its job for
>> performance and sql server's resources. But i can't find article or text
>> for
>> this subject on the internet. Or i know not true?
>> Could you share with me if you have like this article ?
>

Online SQL Server resources?

I'm working on some research on online resources for SQL Server programming
and design. If you'd be willing to help, please follow the link below and
take the survey -- it's only 4 questions!
http://www.surveymonkey.com/s.asp?u=98075334236
Many thanks,
John"John Moody" <john@.wishtracker.com> wrote in message
news:e2qx0lpvDHA.2248@.TK2MSFTNGP09.phx.gbl...
> I'm working on some research on online resources for SQL Server
programming
> and design. If you'd be willing to help, please follow the link below and
> take the survey -- it's only 4 questions!
> http://www.surveymonkey.com/s.asp?u=98075334236
>
which asks
"How much would you be willing to pay for an online service that helped with
SQL Server database problems (design, programming, query construction) if
the service came with a 100% money-back guarantee?"
I believe microsoft.public.sqlserver.server already comes with a money-back
guarantee.
User ^
Expertise |
|
|
|
|
Problem Difficulty
David|||"John Moody" <john@.wishtracker.com> wrote in message
news:e2qx0lpvDHA.2248@.TK2MSFTNGP09.phx.gbl...
> I'm working on some research on online resources for SQL Server
programming
> and design. If you'd be willing to help, please follow the link below and
> take the survey -- it's only 4 questions!
> http://www.surveymonkey.com/s.asp?u=98075334236
> Many thanks,
> John
>
oops.
Meant to say that I once a problem is hard enough to merit a per-incident
fee, it may already be too hard so solve online.
David