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
1 Answer, 1 is accepted
.Reports.ReportLibrary.TermCache.GetData() is a user-defined function which can be used only inside Expressions. It is not possible to use this function inside an SQL query, such as your select statement.
You can use the result of the SQL query and append the user function result inside a similar expression:
= Fields.GroupDisplay + .Reports.ReportLibrary.TermCache.GetData()
or you can pass the data field to the user function inside the expression:
= .Reports.ReportLibrary.TermCache.GetData(Fields.GroupDisplay)
Regards,
Nasko
Telerik