Skip to Content
0
Former Member
May 14, 2010 at 09:13 PM

problem with CR-XIR2 and nvarchar fields

50 Views

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