Cognos report error

[raviahuja21]

Hi Folks,

I am getting this erorr while trying to validate the cognos report.
My report consist of certain display variables which basically displays the list column based on what the user selected, this is done by using the render variable & style variables.

My report also consist of certain parameter which comes with a '*' embedded which indicates that I have to apply starts with condition.

A couple of conditions is as follows:

Code Select Expand


(?FPFN? contains '*' and [Presentation Layer].[Patient].[First Name] starts with substring(?FPFN?,1,position('*',?FPFN?))) or
(?FPFN?<>'' and [Presentation Layer].[Patient].[First Name]  = ?FPFN?)


RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: com.cognos.xqe.data.values.VarcharValue incompatible with com.cognos.xqe.data.values.IAddable