Environment:
First of all we do NOT use the Crystal Reports for Eclipse plugin to create reports we use the Crystal Report 2008 designer.
In our web application, we are using the JRC component with the Eclipse 2.0 Release Update 2 runtime files to display the report
to the users. Our application runs on both Windows and Linux servers using an Oracle 10g database.
Usage:
In our program we list the reports available on the system via a web page. The user selects the desired report and we then
read a properties file to determine the server name and other connection information. We then replace the connection information
stored in the report and launch the viewer. Our reports are always based on our own SQL which oftens includes sub-selects contained in
the Command table. Our sub-select statements will often include report parameters which must be resolved for the SQL to work properly.
Problem:
In general this approach works fine but often we are experiencing odd behaviour i.e. unless we create a report with saved data the report
will fail to display the required parameter prompt but instead will display a database login window containing the original connection
information which should have been overridden prior to launching the viewer. We have noticed that the problem seems to be date related.
The SQL contained in our Command table is similar to this;
Select * from expense where
Expense.Expense_DT >= to_date('01-' || (to_char((Select start_month from region_limit where fk_st_prov_cd='VT' and target_year = {?RptYear}))) || '-2009','DD-MM-YYYY')
Does anyone have any idea what's going on?