March 19, 2012 at 3:05 pm
Hi All,
I'm trying to trouble-shoot this event. I have a SQL 2005 report that uses a single datetime parameter. There is a query in the report that takes GetDate() and then grabs the Previous Business Day from a calendar table. That works fine and loads quickly when the report renders.
However, if the user wants to look at a different date, the calendar control does not operate properly. Instead of displaying dates, the screen flashes as if the whole page was being re-loaded and then the report refreshes showing the same default date and associated data.
Here's the thing: After several minutes, the calendar control becomes active and operates properly! :w00t: There is no problem with the speed of loading the report data, it is only the operation of the control that is wubby.
Does anyone have any ideas what is causing this? I am running SQL 2005 64 bit Enterprise Manager SP3.
Thanks,
Elliott
March 20, 2012 at 1:48 pm
Did you use the query to set the Available Values for the Parameter, or just the Default Value? Default should be fine. Might be a problem if you used it for Available Values, since it is only returning a single value.
March 20, 2012 at 2:00 pm
No. I only set the default value. The calendar control is used to obtain a value indicated by the user.
The delay in activation of the calendar control almost looks like a page needs to be loaded, and that process is taking several minutes. Meanwhile the main report with the default value (the previous business day) loads quickly and accurately.
Elliott
February 24, 2014 at 8:15 pm
Quite new in SQL and first time to hear about this question. I've also know for C# calendar control for a long time and I've read a lot on the calendar guide tutorial, but I even feel so hard to give any idea here. I came to realize query is not an easy thing.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply