Inline Prompt Stops Working After Drill

[andy_mason_84]

Hi All,

I have a RS report based on a Dynamic Cube.

In the Rows of the Crosstab I have a Data item that is called [Rows] which has the folling expression:

filter(#'[CUBE].'+prompt('Rows', 'token','[Dimension].[Dimension].[Company]')# ,[Measure] is not null)

Then in the report I have a Value Prompt that has the following values:

Use Value                                                       Display Value
[Dimension].[Dimension].[Company]              Company
[Dimension].[Dimension].[Supplier]                Supplier
[Dimension].[Dimension].[Product]                Product


I run my report and when I change the value in the prompt the rows change accordingly which is perfect.

However if I then drill down on a Company to see the departments under that company and then change the Prompt to Supplier then the rows no longer change.  If i click Rerun at the top then it does but I dont want to have to add a refilter button, I want the auto submit to do it.

Any advice?

Cheers,

AM.