Problem in report developed with excel as datasource

[Former Member]

I have a report developed with excel and oracle as datasource.

when i try to view in crystal reoprt viewer using java sdk.

Its throwing unexpected database connector error.

If i remove the excel file and check its working fine.

It doesnt show any trace also.

My questions are

1) How to find trace for unexpected database connector error

2) Is it possible to use 2 different datasource in a single report.

[ted_ueda]

What SDK are you using? Crystal Reports Java only supports Java-based data sources, and not native Excel.

Sincerely,

Ted Ueda

[Former Member]

hi,

I am using crystal reports for java version 3.5.

Is it possible to give text file as datasource using java

Also hoew to find the stacktrace for unexpected DB connector error

[ted_ueda]

You'd need to define a POJO or JavaBeans (ResultSet) backed by the text file.

Enable Log4J logging for detailed stack trace.

Sincerely,

Ted Ueda

[Former Member]

is it possible to use array of values returned as resultset from java source