Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter report with a prompt value and member value

Status
Not open for further replies.

agante

Technical User
Jan 9, 2008
1
VE
I need to filter values for the version dimension in a report. The report should show values for two especific versions. One is the version with actuals and the other sholud be selected by user through a prompt (budget, preview or forecast).

When I create the filter I use the following expressions:
example 1:
[Consolidado de real y reformulación].[ESCENARIO].[ESCENARIO].[ESCENARIO].[ESCENARIO] =[ACTUAL]
or
[Consolidado de real y reformulación].[ESCENARIO].[ESCENARIO].[ESCENARIO].[ESCENARIO] =?p_version?

example 2:
[Consolidado de real y reformulación].[ESCENARIO].[ESCENARIO].[ESCENARIO].[ESCENARIO] in (?p_version, [ACTUAL])


but I get errors when running the report.

I've tried several combinations but haven't been able to get the report running.


 
Are you talking about cascading prompt? Like, you have a source prompt A with a list of values. When a user select a value for prompt A, they see a list of values for prompt B where user can select multiple values for prompt B, then run report.

?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top