Hi,
While running a report,prompt page is taking very longtime to display the data, tried to run prompt page individually its also taking longtime but "view tabular data" of prompt query is coming very fast,any one has idea reg problem ? need the solution urgently.Please reply ASAP.
how many values are you displaying at a time?
how many prompts are there?
do the prompts calculate/filter report data before displaying values?
These factors to long run time for prompt. the tabular data just looks for first page values.