Skip to Content
0
Former Member
Jul 18, 2008 at 08:51 AM

Crystal Report display funny/special characters

480 Views

Hi,

Good Day !

I am using Eclipse (Eclipse-jee-europa-fall2-win32-with-CR4E-v.1.0.4), JAVA 1.6 swing GUI to create a crystal report.

below is the code

ReportClientDocument reportClientDoc = new ReportClientDocument();

reportClientDoc.open(REPORT_NAME, 0);

POJOResultSetFactory factory = new POJOResultSetFactory(Pay.class);

POJOResultSet resultSet = factory.createResultSet(paylist);

String tableAlias = reportClientDoc.getDatabaseController().getDatabase().getTables().getTable(0).getAlias();

reportClientDoc.getDatabaseController().setDataSource(resultSet, tableAlias, tableAlias);

ParameterFieldController paramFieldController = reportClientDoc.getDataDefController().getParameterFieldController();

paramFieldController.setCurrentValue("", "userId", userId);

new ReportViewerFrame(reportClientDoc);

but one of the string field display funny/special character.

For example, input value from GUI is "This is a long long long string",

the database will store as "This is a long long long string", no problem.

BUT

the crystal report will display "This is a lon[][][][][]???", some special characters will display.

Even set the string field can grow, still the same error.

Please advice.

regards,

John Vun