An Update on the problem below.
I've taken a look at my server.log for the JBoss server we're running on and I'm getting an access denied error.
(css@192.168.0.19) (Using password:NO)
We've got a mirror server running on 192.168.0.35, I went and changed the datasource location for my SQL command to 192.168.0.35. Went and changed the password for the database on 192.168.0.35 to blank (NO password) re run the report and now it runs fine through the Crystal Report Viewer
Why is it not using a password for my SQL command? It makes no sense. Any help would be appreciated!
Original Post==========================================
I'm using Crystal X.
I've designed a report that is functioning correctly.
Recently I needed to add a SQL Expression (the ones you add as a new command in the Database Expert) which does a simple select statement with a join.
SELECT COUNT(*) FROM TARIFFEDINVOICELINE JOIN COMMERCIALINVOICE ON COMMERCIALINVOICE.CI_BATCHID = TARIFFEDINVOICELINE.TILM_INVBATCHID WHERE COMMERCIALINVOICE.CI_BATCHKEYREF = 'JB0001/07'
It works perfectly in the crystal reports designer. When I try run the report through my Java application using the Crystal Report Viewer (v10) I get the following error:
com.crystaldecisions.report.web.viewer.CrystalReportViewer
For input string: "*"
I tried to alter the select statement to refer to a specific column:
SELECT COUNT(TARIFFEDINVOICELINE.TILM_TARIFFCODE) FROM TARIFFEDINVOICELINE JOIN COMMERCIALINVOICE ON COMMERCIALINVOICE.CI_BATCHID = TARIFFEDINVOICELINE.TILM_INVBATCHID WHERE COMMERCIALINVOICE.CI_BATCHKEYREF = 'JB0001/07'
It previews perfectly in the Crystal report designer but again when I try view in my Java application using Crystal report view I get this error:
com.crystaldecisions.report.web.viewer.CrystalReportViewer
java.lang.NullPointerException
I've got no idea what could be causing this.
Does anyone have any ideas, any advice will be appreciated!!!!
Michael
Edited by michaelwl - 03 Aug 2007 at 12:22am
IP Logged
