RE: Taking a long time to load prompts in crystal report

[allyne]

Hello,

I'm using SAP Crystal Reports 2013 and It uses a stored procedure in which uses PL SQL. The Crystal reports has a couple of dynamic parameters. I'm using the time to load prompts in crystal repoRecord Selection Formula Eeditor to link the Stored Procedure to the parameters for example: {SP_procedure.Loc_ID} in {?Location - Auth_Loc_ID}and sp_procedure.Porc_ID in {?Owner}. The Parameters take a very long time to pop up to enter the information. Does anyone know why this is taking so long and how to make this a quicker process?

Thanks for all your help!

 

[kenhamady]

If you are taking the parameters directly from the SP, then it has to run the entire SP to load the parameters list. The delay might be the time it takes to run the SP.

Maybe you can get the list for that parameter from a table or a simpler query. You can add a table or SQL Command to the report just to feed the parameter. The trick is not to use any fields from that table/command anywhere else in the report. That will force CR to try to link the SP to that object and slow the report down.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/