[Solved]Static Choice Help

[zenith]

hi

I have a requirement as follows
I need to build a crosstab report with a single prompt on measures
eg Unit cost and Quantity from Go Sales
I need to display these in the prompt and whenever i select Quantity from the prompt it should display only the Quantity and same for Unit cost
Any Ideas

Zenith

[Abhijit]

Zenith
You first take a value prompt with static choices as "Quantity" and " Unit Cost" and with a parameter say "?Choice?"
Include both the columns ( Unit Cost & Quantity ) in Tabular model.
In Defination of "Unit Cost" , write:

Ã,  If (?Choice?='Unit Cost')
Ã,  Then (<Database.Unit Cost>)Ã,  Ã,  Ã,  Ã, ----Column from Database
Ã,  Else(0)


In Defination of "Quantity" , write:

Ã,  If (?Choice?='Quantity')
Ã,  Then (<Database.Quantity>)Ã,  Ã,  Ã,  Ã, ----Column from Database
Ã,  Else(0)

Goto Report Page, & insert a calculated column (Mes Column)Ã,  as Measure in crosstab With the defination as
Mes Column= [Unit Cost]+[Quantity]Ã,  ----- Columns from Query Items

Now try the report output,
Let me know, its working or not...?

Abhijit

[zenith]

Yes thanks a lot it has helped   ;D