SQL Expression HELP!!

[didonato]

Crystal Report 8.0
Oracle Database 8.0X
ODBC driver: CR ORACLE 8
Database has about 3000 records

I added two SQL Expressions to my report. (NVL(CALL."CUST_ID",0)) and (NVL(CALL."CALLER",0)). Both these expressions convert null values to zero. This was the only way that I could retrieve data with the LIKE pattern and have it process on the SERVER side. (I have the CONVERT NULL VALUES TO DEFAULT and the USE INDEX OR SERVER FOR SPEED options set to ON) This is what my record selection looks like:
{%sql_cust} like {?cust} and
{%sql_caller} like {?caller}
When I added the two SQL Expressions to my report, it dramatically changed the logon time for my report. Before I added the SQL Expressions this was the set of events.
1. Bring up crystal report from web page (

http://test/report.rpt).

2. Crystal Box prompts me to logon to the database (Takes 2 seconds for the logon box to display)
3. I logon
4. Report is displayed

After I added the SQL Expressions
1. Bring up crystal report from web page (

http://test/report.rpt).

2. Crystal Box prompts me to logon to the database (TAKES 1 MINUTE for the logon box to display)
3. I logon
4. Report is displayed

 

[FoxG]

Hi,

This may a consequence of the way 'page on demand' works.

With out any parameters there is no requirement for client side intervention (ie. the report can be produced, and the first page downloaded in one go.)

With parameters, the server must wait for your data before it can actually process the report on the server, and hence the apparent delay when displaying the report.

You may find that both would take as long if you had the page x of y statement in your page footer, as this would force all processing to be done before the first page could be issued.

I may be totally wrong, but it certainly sounds reasonable to me !!

Hth,
Geoff