Monday, February 20, 2012

problem with url in microsoft server 2005

Hi,
I have a problem:

When i enter in the iis i have two virtual directory:
Reportsr$sqlexpress
ReportServer$sqlexpress

I try to run the report by browsing home.aspx and going to my
report.The url that i got is:

http://localhost/Reports$SQLExpress/Pages/Report.aspx?ItemPath=%2fReportInventory%2fReportTotalCounting

Now, i enter the parameter wanted and click on export to pdf file
it works fine :it opens the report in a pdf file ,i got a url like
this:

http://localhost/Reports$SQLExpress/Reserved.ReportViewerWebControl.axd?ReportSession=a52f1o55wy00wq454pq0jp45&ControlID=f8672382-3d09-430f-a308-9bf42b850184&Culture=1037&UICulture=9&ReportStack=1&OpType=Export&FileName=ReportTotalCounting&ContentDisposition=OnlyHtmlInline&Format=PDF

but the probem is that i think the url is encrript because i don't see the parameters i entered in that url!

what i would like to have is an url like this:

http://localhost/Reports$SQLExpress?%2fReportInventory%2fReportTotalCounting&Parameter_WarehouseID=12&rs%3aCommand=Render&rs%3AFormat=PDF

but this url doesn't work it return me to the url:
http://localhost/Reports$SQLExpress/Pages/Folder.aspx

how can i have a url that work fine so i can pass the paramerter(a url not encript)?

is there somewere where i have to set if the url is encript or not?

help me please why the url does'nt work?
thanks in advance

The Report Manager virtual directory does not have a URL access interface. If you wish to pass parameters and other directives via URL, you must use the Report Server virtual directory:

http://localhost/ReportServer$SQLExpress/Pages/ReportViewer.aspx?%2fReport1&rs%3aCommand=Render

|||

You can pass the parameter in url by accessing the report server. Try http://localhost/ReportServer$sqlexpress/... instead.

http://msdn2.microsoft.com/en-us/library/aa256630(SQL.80).aspx

No comments:

Post a Comment