Hi...I am trying to run the report by passing the parameters using url. Please see the url below and let me know what I am doing wrong here

http://servername/ReportServer/Pages/ReportViewer.aspx?/ReportDirectory/ReportName&rs:Command=Render&Detail=Yes&Consolidated=No&Year= [Date].[Year].&[2011]

I get the error when I add the "Year" parameter in the above url, after adding this I get error "The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath) "

Can you please let me know?

 

Hi Gaurav,

You should also try to encode square brackets in your URL with MDX, so please modify your URL from http://servername/ReportServer/Pages/ReportViewer.aspx?/ReportDirectory/ReportName&rs:Command=Render&Detail=Yes&Consolidated=No&Year= [Date].[Year].&[2011]

To below:

http://servername/ReportServer/Pages/ReportViewer.aspx?/ReportDirectory/ReportName&rs:Command=Render&Detail=Yes&Consolidated=No&Year= %5BDate%5D.%5BYear%5D.%26%5B2011%5D

Thanks,
Challen Fu

Forum Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

Hi,

It works well with single selection but multi selection, could you please give me an advice

https://portal.abc.local/bi/_vti_bin/reportserver?https://portal.abc.local/bi/Report Library/Reports/CTRL002.rdl&pFromDate=1/1/2015&pToDate=6/1/2015

&pOrganization=%5BOrganization%5D.%5BOrganizations%5D.%26%5B2%5D.DATAMEMBER%2C%5BOrganization%5D.%5BOrganizations%5D.%26%5B3%5D

&pAccount=%5BAccount%5D.%5BAccounts%5D.%26%5B300%5D&pAccountLevel=1&pMeasure=%5BMeasures%5D.%5B%25%20IST/Net%20Revenue%5D

&rs:Command=Render&rs:Format=EXCEL

• Edited by WilliamNguyen15 3 hours 21 minutes ago update issue