all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

passing olap parameters in url


passing olap parameters in url TinaWina
10/19/2005 11:33:03 PM
sql server reporting services: hi. could anyone pls tell me how to pass parameter values on url to an olap
RS 2005 report? i tried to do it as such and got an error.
parameter name is AbsenceTypesAbsenceTypes
parameter value is =[Absence Types].[Absence Types].[Absence Type].&[Absent
Days]

this is the link:
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fCA_Reports%2fcAtt_01&rs:Command=Render&AbsenceTypesAbsenceTypes=[Absence
Types].[Absence Types].[Absence Type].&[Absent Days]

this is the error:
The path of the item "/CA_Reports/cAtt_01,[Absent Days]" is not valid. The
path must be less than 260 characters long and must not start with slash.
Other restrictions apply.

it's obvious that the & in the value of the parameter is causing this
problem.

also if somebody knows of a site where i can find help on this subject. i've
searched a lot and none talks about the current version of RS with olap.

Re: passing olap parameters in url Robert Bruckner [MSFT]
10/21/2005 6:41:24 PM
URL parameter values always must be encoded. E.g. & needs to be encoded as
%26, [ would be %5B, ] would be %5D.
Lookup the HttpUtility class on MSDN - it provides a static method
HttpUtility.HtmlEncode to perform this encoding.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.



[quoted text, click to view]

Re: passing olap parameters in url TinaWina
10/22/2005 2:46:03 AM
Thank you very much.
It worked:)

[quoted text, click to view]
AddThis Social Bookmark Button