Wednesday, March 7, 2012

error in execution time

hi all

i am working in sql reporting 2000.

In my report i have included field to display the execution time.

That time is not changing if i am running the report again & again.

Its only showing the time at which report was run first time in current Internet Explorer window.

how can i get current time in report?

plz help me.

In your text box, put this:

="Report Created On: " & Globals.ExecutionTime

|||

Thanks for reply.

I am already using Globals.ExecutionTime to display execution time in my report .

But if i am rexecuting the report then also time is not getting updated.

If i am running other report & after that report if i am running this report then also its showing the last time at which the report was executed.

So what is the solutin for this?

Plz help me

|||The reports might have been cached on the server if you specifically have set it to keep the last run report. So it may not be running the report, but instead getting the last cached report. I haven't tinkered with the settings, but it's an idea. You might want to check the report properties and then the execution tab..

No comments:

Post a Comment