Showing posts with label url. Show all posts
Showing posts with label url. Show all posts

Wednesday, March 28, 2012

Reg URL Report Access Path Format

I'm trying to render a report created using SSRS to open in a web browser in windows form.
This is the URL used:
"http://localhost/reportserver?/C:/Documents and Settings/xsbangalore/My Documents/Visual Studio 2005/Projects/prmRpt/prmRpt&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&StartDate='01/01/2005'&EndDate='01/01/2007'";

I'm not able to see the report.
Error: Unable to link to Web page

What is missing?

The URL must refer to a report that is in the Report Server catalog database. You cannot refer to documents on disc as reports. Upload the report to the Report Server and then use Report Manager or the reportserver url to browse to the report. From there you will see how a URL is constructed.

Example:

http://localhost/reportserver?/Report Project1/report1&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&StartDate='01/01/2005'&EndDate='01/01/2007'";

|||If I dont have a report server created, what's the alternative?

OR
How do I create a resport server instance?

Saturday, February 25, 2012

reduced functionality with Web Services

I'm curious exactly what functionality is lost when you use the RS Web
Service rather than accessing the direct URL. We're evaluating RS vs Crystal
and specifically need XLS export functionality. Is this lost if you use the
RS Web Service? Is there a way to export to PDF, XLS, etc. and still use the
RS Web Service?
Regards,
David GardnerIf you render using the web service, you loose the nice html toolbar you
get with URL access:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_intro_0pr6.asp
You can pass a format string to the Render method of the web service. It
supports multiple formats (including Excel, PDF...)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_6x0z.asp
Make sure you have Reporting Services SP1 installed, as there were a number
of fixes to the rendering extensions included in that service pack.
--
Adrian M.
MCP
"David Gardner" <David.Gardner-Logan@.REMOVECAPSrrd.com> wrote in message
news:6CD498D5-ED27-4626-89CF-49DC8E61DAB6@.microsoft.com...
> I'm curious exactly what functionality is lost when you use the RS Web
> Service rather than accessing the direct URL. We're evaluating RS vs
> Crystal
> and specifically need XLS export functionality. Is this lost if you use
> the
> RS Web Service? Is there a way to export to PDF, XLS, etc. and still use
> the
> RS Web Service?
> Regards,
> David Gardner