Jump to content
Changes to the Jaspersoft community edition download ×

Problem running compiled Jasper report


2004 IR Help

Recommended Posts

By: AMV8 - amv8

Problem running compiled Jasper report

2005-09-07 07:49

Report has been compiled in V 0.5. We then use in an OpenReports application on browser (IE6). Report runs fine in iReports but when run in Openreports we get message:

'Error creating report: Error executing SQL statement for report :'

Same report ran fine in older versions of iReports/OpenReports but fails when recompiled in latest version.

We have other reports with very similar SQL queries that run with no problem after being recompiled and SQL runs fine if we run it on its own in SQL Server. We have also tried removing all parameters and hardcoding values into report but still does not run in Browser.

Does anyone have same experience or idea as to what problem may be?

 

 

 

 

 

By: AMV8 - amv8

RE: Problem running compiled Jasper report

2005-09-08 03:46

We have done some experimentation and it appears that the latest version (we are using 0.9.0) of Openreports has trouble in handling Declared Variables that rely on their own SQL statement to set them. Removing the declared variable and using the SQL to set the variable within the body of the main SQL statement works fine- very time consuming and makes SQL complicated to read though.

Strange that it works in older versions of Openreports but not 0.9.0?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...