Question about Reporting Services...

I used Visual Studio 2003 to create several reports and those reports are
saved to a virtual directory at the IIS server. At present I can only open
those reports using the Report Manager came with the Reporting Services. I
wonder if I can open those reports straight from the web site with a
hyperlink and without opening the Report ManagerUI. If it is the case how
dose it work to connect to the SQL database? My understanding is the
connection/other information associated with the report is saved in a table
"Report Server" at the SQL database. Can I attach this connection string
information in a file at IIS or can it be attached right to the report
itself? Also how will it work in printing those reports in different file
formats as shown in the Reporting Manager if I allow to by-pass using the
Report Manager UI? Thank you for your infor.Hi Paul,
I assume when you mean "open" reports, you mean you want to retrieve a rendered
copy of the report (not retrieve the report definition, etc).
You can access the reports by URL quite easily. If say you have a report
"Purchase Order" in the folder "Demos" (/Demos/Purchase Order). Use this
URL:
http://<yourServer>/ReportServer/?/Demos/Purchase+Order
Then you can attach various URL parameters to control what happens. To render
the report in PDF, use this URL:
http://<yourServer>/ReportServer/?/Demos/Purchase+Order&rs:Command=Render&rs:Format=PDF
All of the database connection information is either stored in the RDL file
on the server, or as part of a Shared Data Source. So, there's no need to
send that info through the URL. If you have additional report parameters,
append them like you would any other URL querystring value. For example,
if you have a parameter "SalesYear":
http://<yourServer>/ReportServer/?/Demos/Purchase+Order&rs:Command=Render&rs:Format=PDF&SalesYear=2005
You can also use the RS web-services API:
http://support.microsoft.com/?kbid=875447
I've always thought that this was the way MSFT intended for users to get
to reports... built seamlessly into web applications, while Report Manager
was for report management/administration.
-Chris @. SoftArtisans
> I used Visual Studio 2003 to create several reports and those reports
> are saved to a virtual directory at the IIS server. At present I can
> only open those reports using the Report Manager came with the
> Reporting Services. I wonder if I can open those reports straight from
> the web site with a hyperlink and without opening the Report
> ManagerUI. If it is the case how dose it work to connect to the SQL
> database? My understanding is the connection/other information
> associated with the report is saved in a table "Report Server" at the
> SQL database. Can I attach this connection string information in a
> file at IIS or can it be attached right to the report itself? Also how
> will it work in printing those reports in different file formats as
> shown in the Reporting Manager if I allow to by-pass using the Report
> Manager UI? Thank you for your infor.
>

question about IIS Virtual Directory Management for MS SQL server 2000

Hi,

I installed the MS SQL Server 2000 trial version in my computer. The Operating System is WinXP. It seems everything is OK, the MSSQLserver is running after I restart the computer.

Then I tried to create a few virtual directories following these steps:
Choose start => programs => Microsoft SQL server => Configure SQL XML Support in IIS

What I can see is the icon " IIS virtual Directory Management for SQL Server" in the left pane, and nothing in the right pane. Is this normal?

I right clicked the icon, selected the "connect", typed in the computer name as it required. But it showed that an error occurred connecting to the computer. The reason is "this server does not exist or is unavailable". It is quite strange that actually the SQL server is running at this time.

Is there anybody who can tell me what 's wrong with it? Do I have to do some special configuration?

Thanks a lot

Johnwhen u see this icon: IIS virtual Directory Management for SQL Server

click it, at least you should see the computer where the sql server is intalled in right pane. then u can drill down to see the default web site.

if nothing ... try to connect to the computer ur got sql server installed. make sure u have installed IIS.

if still cant, dont know whether it has anything to do with the trial version. i am using personal edition, and everything is fine.|||Thanks.

I made a stupid mistake. I didn't install IIS. :-(