Hi!

I seems know the solution, but I do nto know if it will work - need some time to try it and see if it will work at all.

Add a function call to the report somewhere that is called the first of all other things. Then prepare a temporary cursor with only one empty record for that report before report editing. When that function is called, it indicate that report is ran. From this function just run a query for that report to prepare the data. SO, when user request to preview the report, the query ran to get its data. When no requesting to preview, the data are not prepared for report at all. After query running just copy these data into the temporary cursor. Still NO running of the report, though I guess this could be used for printing too.

Really, I never knew if above works (dynamical preparing data for report "one the fly"). Though I think it worth to try if such feature is really needed (no data for report preview when user designing report in run-time). Just prepare these data when user requests to preview and thats all ;))

Well, still no good solution to cancel such thing properly - when user cancel query runnign (for example, using progress bar or just "ESCAPE" key), data will not be prepared and as a result preview will show one empty record or even no preview (blank window flashes).

HTH.


>Hi There,
>
>They talk around the subject but there is no any solution for the problem.
>
>Thanks,
>
>Doron
>
>>>
>>>When modify the report is there a way to disable the Preview option when
>>>right click on top of that report. There could be a situation that
>>>the report has no data source and I am trying to prevent running that report in this situation.
>>>
>>
>>Hi Doron,
>>
>>Take a look at Thread #552030 that discussed this topic.