Report Page Prompt Error

[MelissaK]

I have built a report in Report Studio 10 that has a prompt page wth three cascading value prompts and these work very well.  I have the same prompts on the report page so that my clients can change their selections without going back to the prompt page.  When I select the first/top value prompt, I get an error message: RSV-VAL-0032  The following expression is not valid: ([Query1].[PipelineStatusCreate] contains "TargetMet").  If the item exists in a query but is not refrenced in the layout, add it to a property list. CRX-API-0005 An error occurred at or near the position '1&#30);.  The variable named [Query1].[PipelineStatusCreate]' is invalid. 

However, this error does not make sense.  The three prompts on the prompt page and on the report page are the same:  Required = Yes; Multi-Select = No; Auto-Submit = Yes.  There is another prompt on the report page that is not required and is based on a completely different variable than the three prompts previously mentioned.  Could this be where the problem lies?

[RKMI]

Hi Melissa,

I doubt it's the prompt, I think it's some conditional formatting/ layout calucation which is not written correctly. Are doing something like that? Under tools> manage conditional styles it should show you all the styles for the report and you can verify where you used this statement ([Query1].[PipelineStatusCreate] contains 'TargetMet').  you make want to delete it and test if the prompt works as expected after which go down the line of correcting your conditional statement. Hope this makes sense.

Thanks,
RK

[MelissaK]

Thank you.  I removed the conditional formatting and the prompts now work.  Now, the problem is that it expects a separate prompt that I have within the report to be selected before the prompts at the top of the report page will change the filter on the data.  Is there a way to separate out this additional prompt so it is not required when I change the three prompts that filter the data?  I've got is marked as not required, but the report will not update with the new filters unless something has been selected.  Not a major issue, but I'm afraid my clients will get confused when they have to select an item that is not related to the selection of data segments.

[MelissaK]

I think I have the solution.  I created a query for the prompt within the report and now it does not need to have a selection with the other prompts,