hi,

I am using AS2005 and when I am trying to set the Parameters in Cube
Report Actions, I find that I can not see the Report Actions anymore.

If there is no Parameters set, the report action works fine. However if I
set the Parameters, the report actions just disappear ... Would you please
help me on this problem? Thanks a lot.

What make it worse, I find that once I define the parameters, I can not
delete them ! I need to delete the whole action and define it again from the
beginning. Is that true?

Does this problem occur with even a single parameter - if so, can you
give an idea of the parameter value? If it's an MDX expression, did you
check it first with a constant value, and did you check the syntax of
the expression?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi, Deepak

Thanks for help! I have only tried a single parameter at this moment.
And I am now using the constant value for parameters, for example, a string
such as "Year 2004". Do you think there is anything wrong with this syntax to
be a parameter?

Thanks again.

"Deepak Puri" wrote:

Hi, Deepak

I have tried to set the Parameter value as "2006" instead of 2006 and it
seems the cube action is OK now. When I click the report action, it will link
to the address such as :http://host/Reports/Pages/Report.aspx?Itempath=......
&Report_Parameter_1=2006&rs:Command=Render..... .

However, the report page still shows an error : The 'Report_Parameter_1'
parameter is missing a value.

I have tried to set the Report Parameter both to Internal and Hidden but
no use, would you please tell me what else do I need to set to pass the
parameter from the cube action to my report? Thanks!



"jimmy" wrote:

Setting the Report Parameter as Internal will prevent passing it in the
action URL, which is not what you want:

http://msdn2.microsoft.com/en-us/library/aa337234.aspx

Creating Report Parameters and Setting Report Parameter Properties
...
Hidden and Internal Parameters

You can set options that control parameter visibility in the published
report. Setting the Hidden and Internal options provides different
levels of visibility. You can hide the parameter on the parameter input
area of the published report, yet set values for it on a report URL or
in a subscription definition. If you set a parameter to internal-only,
it is not exposed in any way except in the report definition.

Referring to the configuration of the "Sales Reason Comparisons" Report
Action in Adventure Works, values of the following properties should be
checked:

- Report Path: ReportServer?/AdventureWorks Sample Reports/Sales Reason
Comparisons

- Parameter ProductCategory: UrlEscapeFragment(
[Product].[Category].CurrentMember.UniqueName )


You could first directly confirm the syntax of the Report URL with a
passed parameter in a browser, and then compare this working URL with
the URL generated by the cube action:

http://msdn2.microsoft.com/en-us/library/ms154042.aspx

URL Access Syntax
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi, Deepak

Thanks for your referred information. I have read them and I tried to
access my report by an URL link such as:
http://127.0.0.1/Reports/Pages/Repor...meter _0=2003

However, the report still shows the error:
The 'Report_Parameter_0' parameter is missing a value

It is very strange because I have totally followed the steps in your
article and still no use. This time I only select the option "Hidden" for the
report parameter. Would you please have a look at this? Thanks again.


"Deepak Puri" wrote:

Hi, Deepak

I found the reason now. I forget to use ReportServer website instead of
the Report site. I think they are a little bit confusing. Anyway, thanks.