Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Crystal reports using java Post Reply Post New Topic
Author Message
Justin.vp
Newbie
Newbie
Avatar

Joined: 24 Nov 2014
Online Status: Offline
Posts: 4
Quote Justin.vp Replybullet Topic: Crystal reports using java
    Posted: 24 Nov 2014 at 9:18pm
Hi, I am using crystal reports 2008 for designing the reports page.

Now I am facing issue once added new fields in the stored procedure.

1. I have added two fields in the existing stored procedure.
2. I have updated the new fields in the reports using verify database.
3. drag and drop the new fields.
4. view the print view and it is showing the results correctly.
5.The same report(.rpt) file is using in java application.
6. It is throwing exception when I am trying to call the same reports via java application.

The exception is throwing in the below line
    InputStream is = reportClientDocument.getPrintOutputController().export(reportFormat); // report format is PDF

The exception is.....

com.crystaldecisions.sdk.occa.report.lib.ReportSDKParameterFieldException: InternalFormatterException---- Error code:-2147217394 Error code name:missingParameterValueError


It will be very helpful if any one help to resolve this issue.

Thanks in Advance
Justin
Justin VP
IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 25 Nov 2014 at 12:53am

not sure about running through java, through from the error, does the Store proc have a parameter?

IP IP Logged
Justin.vp
Newbie
Newbie
Avatar

Joined: 24 Nov 2014
Online Status: Offline
Posts: 4
Quote Justin.vp Replybullet Posted: 25 Nov 2014 at 10:49am
Yes we have input parameters.

This is existing report and it is working fine.
It is not working when I add two more fields (output fields)in the existing stored procedure and add the same fields in the reports too.





Edited by Justin.vp - 25 Nov 2014 at 10:50am
Justin VP
IP IP Logged
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Posted: 25 Nov 2014 at 10:47pm
I would suggest that the java code is not passing any parapeter values when the report is running...
 
Again I have not used java coding with CR so can not really help anymore.
IP IP Logged
Justin.vp
Newbie
Newbie
Avatar

Joined: 24 Nov 2014
Online Status: Offline
Posts: 4
Quote Justin.vp Replybullet Posted: 26 Nov 2014 at 2:23am
I am using stored procedures for generating the report. I am calling the stored procedure in my .rpt file.

I am using ReportClientDocument Class.

I am getting the below exception.

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: Missing parameter values.---- Error code:-2147217394 Error code name:missingParameterValueError

I am able to set the parameters and also able to retreive their value before calling the export method but this error comes at the point where I am calling the export method of PrintOutputController class.
Justin VP
IP IP Logged
Justin.vp
Newbie
Newbie
Avatar

Joined: 24 Nov 2014
Online Status: Offline
Posts: 4
Quote Justin.vp Replybullet Posted: 11 Dec 2014 at 5:22am
Hi All,

I am trying to connect SQL server 2008r2 database with Crystal reports 2013 trial version.

when creating the connection I got the below exception.

Failed to open the connection
Details: SQL Exception:[SQL State] 08S01 [Error Message:] The server version is not supported. The target server must be SQL Server 2000 or later.

Please guide me if any one know about this error.

Justin VP
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.