Re: Progress Bar in Reports.

Playmaker wrote:

>First of all I would like to thank you for your quick response.
>
>I am sorry but I just don't seem to quite grasp what you are saying.
>I have created a form which in turn calls the report and passes the
>corresponding parameters to this report. Once the report is triggered
>through the form, the control is given to the report. In order for the
>progress bar to exist in the form, there must be a way to know before
>hand how many records the report is going to fetch, correct? In
>addition to this, there should also exist some kind of continuous
>communication among the form and the report in order to update the
>progress bar. Is that possible or am I missing something?
>
>Thanks again for your time.
>
>
Please reread my response. The only way to accomplish what you want is to NOT pass control to the report until the data is staged.

Use the form to stage the data. Run 100% of the report data into a table holding the result set and only pass control to the report after the data is completely prepared. Then there is no delay time before printing begins. Thus the form executes the SQL statement currently in the report and the report consists of nothing but a SQL statement in the form:

SELECT * FROM .... Based on a single table with no WHERE clause.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)