Skip to Content
0
Former Member
Dec 03, 2009 at 04:49 PM

Login Page displayed instead of parameter prompt

43 Views

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?