Re: Very long report loading

I have run accross the same thing.

It is like Shane and Cindy say in #1. If there is code SQL selects for the parameter screen or any select in the first report that is triggered, Reports will try to preprocess it and this takes a tremendous amount of time. I have noticed the 2nd time it is run it will be faster but not by much.

If you can, try moving those selects which access the database that are in the BeforeParm trigger, or procedure which are called here which make SQL calls, to another trigger.

I have heard that the Report Server can be moved Server Side and this may improve performance, but I have not tried it yet.

Piece or trivia: I have noticed that my same reports that take a long time to come up to the Parameter form take half as much on NT. Go figure!

Hope this helps.

Jason Ladew

In article <01bddb19$9531b4d0$528480c3_at_www>, "Danil Krasnov" <danil_at_maginfo.net> writes:

>Hello, gurus!
>
>My report file .rep initial loading takes about 2-3 minutes.
>(It is till the parameter form appears...)
>
>While I run report in report builder, this time is much shorter (2-5
>seconds).
>But when I start report from forms or from reports runtime.. I have to
>waiting much time..
>
>Does anybody knows possible reasons?
>
>Danil Krasnov
>danil_at_maginfo.net
>
>
Received on Tue Sep 15 1998 - 00:00:00 CEST