IBM Support

CRX-YXX-4010 Parsing error on or around position 0 in the expression

Troubleshooting


Problem

Following the Proven Practices document 'Leveraging multi-valued LDAP attributes as session Parameters' and placing the expression #sq(csv(@account.parameters.department))# in a Text item referencing a Report Expression throws an error message when running the report.

Symptom

CRX-YXX-4010 Parsing error on or around position 0 in the expression: '#csv(@account.parameters.department)#

Resolving The Problem

Place the expression in a Query Calculation rather than in a Text item.
Steps:
  1. Delete the Text item from the report.
  2. Select the Tool Box tab under Insertable Objects
  3. Drag a Query Calculation onto the report.
  4. Set the Name property for the Query Calculation as desired.
  5. Set the Expression for the Query Calculation to '#csv (@account.parameters.department)#' or '#sq(csv (@account.parameters.department))# as required.'
  6. Validate the expression.
  7. Click OK
  8. Run the report.
  9. If following the Proven Practices document Leveraging multi-valued LDAP attributes as session Parameters then the report should return as expected with the values '3','9','12','22

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2;10.2.1;10.2.1.1;10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1037457

Document Information

Modified date:
20 March 2020

UID

swg21342579

Page Feedback