I have a Parameter called 'Group By'. There are 3 choices in a dropdown on the report for which the user can select one and the report will be grouped differently. I did this using bindings.
My problem comes with the values of the dropdown. We have a user defined function set up that accepts an organizations id and culture then returns a certain value. For example, some orgs use 'Goal' and some use 'Strategy' to refer to the same thing. I want the dropdown to change depending on the value of this function.
The select statement for my data source goes as follows:
select
1 as GroupById
,'Epm.Reports.ReportLibrary.TermCache.GetData("FOCUS_AREA", Parameters.OwnerCode.Value, Parameters.CultureName.Value)' as GroupDisplay
UNION
select
2 as GroupById
,'Epm.Reports.ReportLibrary.TermCache.GetData("FUNCTION_AREA", Parameters.OwnerCode.Value, Parameters.CultureName.Value)' as GroupDisplay
UNION
select
3 as GroupById
,'Epm.Reports.ReportLibrary.TermCache.GetData("GOAL", Parameters.OwnerCode.Value, Parameters.CultureName.Value)' as GroupDisplay
The Display Value for my parameter is GroupDisplay. I would like these to display the word that is pulled from my function. But the dropdown is filled with the full text 'Epm.Reports.ReportLibrary.TermCache.GetData("GOAL", Parameters.OwnerCode.Value, Parameters.CultureName.Value)'. The function works elsewhere in the report so I know it is not that. Any ideas?
Thanks,
Phillip