Problem Rendering report via URL

Here's the link:
http://dvws02ms.firm.jonesday.dv:800/Reports/Pages/Report.aspx?ItemPath=%2fCLE+Reports%2ftest&rs:Command=Render&Type=O
My report is called test and it has one report parameter, Type. Somehow if
just keeps prompting me that the parameter is missing. Anybody had problems
with this before? This is the first report I've tried to run with a
parameter through a URL. RS2005............I figured this out. I wasn't pointing to the ReportViewer.aspx page...
"gdjoshua" wrote:
> Here's the link:
> http://dvws02ms.firm.jonesday.dv:800/Reports/Pages/Report.aspx?ItemPath=%2fCLE+Reports%2ftest&rs:Command=Render&Type=O
> My report is called test and it has one report parameter, Type. Somehow if
> just keeps prompting me that the parameter is missing. Anybody had problems
> with this before? This is the first report I've tried to run with a
> parameter through a URL. RS2005............

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates successfully.

Here is the URL format I am trying: http://localhost/ReportServer?/FolderName/ReportName&rs:Command=render&Year=2006&Month=6&Day=9

Currently, my parameters are all set to null for default values. They are also not multivalued, not internal, not hidden, don't allow blank, and don't allow null. I have also looked through the valid values in the drop down box for each parameter and verified that the values I supplied in the URL do exist. Also, the data types for each parameter is Integer just like the data type found in the database.

In my opinion, this problem seems directly related to using an analysis services data source. After I was getting this problem, I created a sample report using SQL Server data source, used the same three parameters, and passed them in the URL. Everything on that report worked perfectly.

Please help, I've looked thorugh almost every piece of documentation regarding parameters for Reporting Services and still no luck. Thanks!!

Are you sure those are the names of the parameters and not the prompts?

You can view the parameter names in Report Manager.

|||These are the correct names of the parameters. The prompt names match the actual parameter names.|||

Can you post the portion of the RDL which defines the parameters?

Also make sure that the value you are assigning is really a proper value, and not the label for a proper value.

|||

Actually, I just figured out the problem...

When you are working with an analysis services data source, the parameter values are different from the values listed in the database.

For example, suppose you need the parameter CalendarYear. In the database the values are 2004, 2005, 2006, etc... However, in reporting services the parameter values are actually [DimensionName].[FieldName].&[value] ... or ..... [Date Dim].[CalendarYear].&[2006]

In case you are ever unclear of a parameter value for something, just go to the "Data" tab, click the Dataset for the parameter, ie. "CalendarYear". Then click out of the Design View. Finally, click the execute query button and observe the values listed in the parameter value column. These are the list of valid values which can be used.

As a side note, when adding these parameter values in a URL, you will need to escape the ampersand character in the value expression otherwise it won't work. For example, CalendarYear=[Date Dim].[CalendarYear].%26[2006]

I hope this helps everyone. I know I spent a lot of time working on this.

Thanks!!

|||i am not sure about the answer given above as the correct date time format to acess in url is

Code Snippet
YYYY-MM-DDTHH:MM:SS

And the report that is created above is defalut to query type that should not be right

bye
arya|||

I'm experiencing a similar problem, with a special character in the FieldName part of the parameter:

Someting like:

CalendarYear=[Date Dim].[Calendar ?Year].%26[2006]

I've already tried escaping the ? and characters:

CalendarYear=[Date Dim].[Calendar %abYear%bb].%26[2006]

Any ideas ?

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take one parameters in the URL to generate a detail report. when i pass parameter as

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=123

it works fine . But i want to send master report's parameter to detail at run time which is selected in master report, then i got an error

i want to use

http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" &Parameters!p1.Value& "

but an error come i,e

" The path of the item '/UpdatedByClickTest/S,Parameters!p1.Value, "' is not valid. The full path must be less than 260 characters long, must start with slash; other restrictions apply. Check the documentation for complete set of restrictions. (rsInvalidItemPath)"

how can i pass parameter to remove this error?

plz any one help me i shall be thankfull to you

Hello Arshad,

Where are you trying to generate the URL?

If you just want to display a link, this will append your parajmeter to the URL:

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" + cStr(Parameters!p1.Value)

Hope this helps.

Jarret

|||

Thanks Jarret its working now i m using

="http://marshad/ReportServer?/UpdatedByClickTest/S&rs:Command=Render&P1=" & Parameters!p1.Value

now i want to use global server name becuase i will have to deploy reports to different servers e,g DEV, QA and Production

i m using code like

=Globals!ReportServerUrl & "?/UpdatedByClickTest/S&rs:Command=Render&P1="&Parameters!p1.Value

but its not working plz send me ur code.

|||

That should work, but not while you are designing the report. I tried what you posted and it worked when I deployed the report. When you deploy it to the server and run it from there, you should see the ReportServerURL showing correctly.

Jarret

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates successfully.

Here is the URL format I am trying: http://localhost/ReportServer?/FolderName/ReportName&rs:Command=render&Year=2006&Month=6&Day=9

Currently, my parameters are all set to null for default values. They are also not multivalued, not internal, not hidden, don't allow blank, and don't allow null. I have also looked through the valid values in the drop down box for each parameter and verified that the values I supplied in the URL do exist. Also, the data types for each parameter is Integer just like the data type found in the database.

In my opinion, this problem seems directly related to using an analysis services data source. After I was getting this problem, I created a sample report using SQL Server data source, used the same three parameters, and passed them in the URL. Everything on that report worked perfectly.

Please help, I've looked thorugh almost every piece of documentation regarding parameters for Reporting Services and still no luck. Thanks!!

Are you sure those are the names of the parameters and not the prompts?

You can view the parameter names in Report Manager.

|||These are the correct names of the parameters. The prompt names match the actual parameter names.|||

Can you post the portion of the RDL which defines the parameters?

Also make sure that the value you are assigning is really a proper value, and not the label for a proper value.

|||

Actually, I just figured out the problem...

When you are working with an analysis services data source, the parameter values are different from the values listed in the database.

For example, suppose you need the parameter CalendarYear. In the database the values are 2004, 2005, 2006, etc... However, in reporting services the parameter values are actually [DimensionName].[FieldName].&[value] ... or ..... [Date Dim].[CalendarYear].&[2006]

In case you are ever unclear of a parameter value for something, just go to the "Data" tab, click the Dataset for the parameter, ie. "CalendarYear". Then click out of the Design View. Finally, click the execute query button and observe the values listed in the parameter value column. These are the list of valid values which can be used.

As a side note, when adding these parameter values in a URL, you will need to escape the ampersand character in the value expression otherwise it won't work. For example, CalendarYear=[Date Dim].[CalendarYear].%26[2006]

I hope this helps everyone. I know I spent a lot of time working on this.

Thanks!!

|||i am not sure about the answer given above as the correct date time format to acess in url is

Code Snippet
YYYY-MM-DDTHH:MM:SS

And the report that is created above is defalut to query type that should not be right

bye
arya|||

I'm experiencing a similar problem, with a special character in the FieldName part of the parameter:

Someting like:

CalendarYear=[Date Dim].[Calendar ?Year].%26[2006]

I've already tried escaping the ? and characters:

CalendarYear=[Date Dim].[Calendar %abYear%bb].%26[2006]

Any ideas ?

Problem Passing Report Parameters in URL

I'm currently trying to create a report that will take three parameters in the URL to generate a report: year, month, and day. The report is using an analysis services data source in RS 2005. Now, my problem is that the parameters being passed in the URL are not being selected in the drop down boxes for the parameters. The report does not throw any exceptions, and after the user selects values for the year, month, and day everything generates successfully.

Here is the URL format I am trying: http://localhost/ReportServer?/FolderName/ReportName&rs:Command=render&Year=2006&Month=6&Day=9

Currently, my parameters are all set to null for default values. They are also not multivalued, not internal, not hidden, don't allow blank, and don't allow null. I have also looked through the valid values in the drop down box for each parameter and verified that the values I supplied in the URL do exist. Also, the data types for each parameter is Integer just like the data type found in the database.

In my opinion, this problem seems directly related to using an analysis services data source. After I was getting this problem, I created a sample report using SQL Server data source, used the same three parameters, and passed them in the URL. Everything on that report worked perfectly.

Please help, I've looked thorugh almost every piece of documentation regarding parameters for Reporting Services and still no luck. Thanks!!

Are you sure those are the names of the parameters and not the prompts?

You can view the parameter names in Report Manager.

|||These are the correct names of the parameters. The prompt names match the actual parameter names.|||

Can you post the portion of the RDL which defines the parameters?

Also make sure that the value you are assigning is really a proper value, and not the label for a proper value.

|||

Actually, I just figured out the problem...

When you are working with an analysis services data source, the parameter values are different from the values listed in the database.

For example, suppose you need the parameter CalendarYear. In the database the values are 2004, 2005, 2006, etc... However, in reporting services the parameter values are actually [DimensionName].[FieldName].&[value] ... or ..... [Date Dim].[CalendarYear].&[2006]

In case you are ever unclear of a parameter value for something, just go to the "Data" tab, click the Dataset for the parameter, ie. "CalendarYear". Then click out of the Design View. Finally, click the execute query button and observe the values listed in the parameter value column. These are the list of valid values which can be used.

As a side note, when adding these parameter values in a URL, you will need to escape the ampersand character in the value expression otherwise it won't work. For example, CalendarYear=[Date Dim].[CalendarYear].%26[2006]

I hope this helps everyone. I know I spent a lot of time working on this.

Thanks!!

|||i am not sure about the answer given above as the correct date time format to acess in url is

Code Snippet
YYYY-MM-DDTHH:MM:SS

And the report that is created above is defalut to query type that should not be right

bye
arya|||

I'm experiencing a similar problem, with a special character in the FieldName part of the parameter:

Someting like:

CalendarYear=[Date Dim].[Calendar ?Year].%26[2006]

I've already tried escaping the ? and characters:

CalendarYear=[Date Dim].[Calendar %abYear%bb].%26[2006]

Any ideas ?

sql

Problem passing a parameter in URL to a report

Hi all.
I have that problem. I need to pass a parameter to a report. That parameter
is a user in a windows domain, so I have the problem that is stored in
"DOMAIN\USER" format, and I can't pass the backslash to the url.
How can I solve that?
--
Regards,
Diego F.I ask myself. I can encode \ with %5C.
I'm embarrased for that stupid question...
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OUA34HxMGHA.344@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> I have that problem. I need to pass a parameter to a report. That
> parameter is a user in a windows domain, so I have the problem that is
> stored in "DOMAIN\USER" format, and I can't pass the backslash to the url.
> How can I solve that?
> --
> Regards,
> Diego F.
>
>|||Also, you might not even need to do this. Look at the global variables in
the expression builder User!UserID, it is the user running the report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OTaydMxMGHA.720@.TK2MSFTNGP14.phx.gbl...
>I ask myself. I can encode \ with %5C.
> I'm embarrased for that stupid question...
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OUA34HxMGHA.344@.TK2MSFTNGP11.phx.gbl...
>> Hi all.
>> I have that problem. I need to pass a parameter to a report. That
>> parameter is a user in a windows domain, so I have the problem that is
>> stored in "DOMAIN\USER" format, and I can't pass the backslash to the
>> url.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>|||... or you can use POST instead of GET. In other words, you can pass
parameters in a form instead of passing by querystring.

Problem on hiding toolbar when report is being rendered

I'm using url access to preview report and added a rc:Toolbar=false. When I
preview the report, the toolbar still shows. Please help.What is the full URL you are using to access the report? Does the report
have any required parameters? What browser (version)? Can you hide other
HTML Viewer items like "Parameters"
&rc:Parameters=False
?
Rodney Landrum
"Randy Gadingan" <RandyGadingan@.discussions.microsoft.com> wrote in message
news:62610906-32E3-4BCD-B477-607AB8355237@.microsoft.com...
> I'm using url access to preview report and added a rc:Toolbar=false. When
> I
> preview the report, the toolbar still shows. Please help.
>|||make sure you add it to the end of your report and the you have the "&"
included.
like this:
&rs:Command=Render&rc:Toolbar=False
"Randy Gadingan" wrote:
> I'm using url access to preview report and added a rc:Toolbar=false. When I
> preview the report, the toolbar still shows. Please help.
>