Hi all,
We have the following problem with CR-XIR2 and nvarchar fields
1. The report runs fine from Crystal Designer
2. It fails when we run it through the report viewer web application in Tomcat
The context:
We changed server columns from varchar to nvarchar to allow I18n characters
The environment:
-Crystal Report XIR2 for java , running in a servlet container (as a web application)
-MSSQL 2005
-jdbc4 driver.
Exceptions
When the report uses a formula on an u2018nvarcharu2019 field, Crystal Report throws this exception:
15:28:48,984 ERROR [reportdefinition] com.crystaldecisions.reports.formulas.ak: Exception in formula '{@PEMemberName}' at '({member.login_name})':
This field''s value cannot be used in a formula: .
15:28:49,015 ERROR [dataengine] Formula error: recompile formulas failed
When I delete this formula from report, Crystal report still fails on the nvarchar field:
JRCAgent5 detected an exception: java.lang.IndexOutOfBoundsException
So questions are:
1. Can we use nvarchar field in the formula
2. Can Crystal Reports java viewer display/render nvarchar fields
Thanks in advance