Report Designer: Refreshing Fields VERY Slow

I have a query that uses temp tables, and the query seems to execute and
refresh fields fine, but as soon as I put in a parameter for a DateTime field
the query will run but the Refresh Fields button takes forever...like 2
hours! I think it is running my rather lengthy query without the parameters
which because of the size of the tables takes a long time.
I have tried changing the data type for the parameter from String to
DateTime and neither seem to refresh the fields quickly.
Can anything be done to refresh the fields list quicker?I thought my MSDN Universal Subscription entitled me to a response within two
days... I guess not.
"Chance" wrote:
> I have a query that uses temp tables, and the query seems to execute and
> refresh fields fine, but as soon as I put in a parameter for a DateTime field
> the query will run but the Refresh Fields button takes forever...like 2
> hours! I think it is running my rather lengthy query without the parameters
> which because of the size of the tables takes a long time.
> I have tried changing the data type for the parameter from String to
> DateTime and neither seem to refresh the fields quickly.
> Can anything be done to refresh the fields list quicker?
>

Report DateTime Parameters in UK date format

I have a report that I've developed that accepts several datetime parameters.
In the Report properties, I've set the report Language to English (United
Kingdom).
I am calling my report via the Web Service from an ASP.Net application. The
ASP.Net application Culture and UICulture are set for en-GB.
What is happening is that when a date is passed to one of the report
parameters (gEndDate) as "14/12/2004" (December 14), I get the following
error:
The value provided for the report parameter 'gEndDate' is not valid for its
typeI should also point out that my Visual Studio .Net 2003 environment is in
en-US and my computer is in the United States English setting.
The development environment I am testing (where I got the error) is a
Virtual PC environment set up as English UK in the Control Panel.
"AdamB" wrote:
> I have a report that I've developed that accepts several datetime parameters.
> In the Report properties, I've set the report Language to English (United
> Kingdom).
> I am calling my report via the Web Service from an ASP.Net application. The
> ASP.Net application Culture and UICulture are set for en-GB.
> What is happening is that when a date is passed to one of the report
> parameters (gEndDate) as "14/12/2004" (December 14), I get the following
> error:
> The value provided for the report parameter 'gEndDate' is not valid for its
> type
>