Works in IE, not in VS.NET. (Type mismatch error?) -- sql server reporting services

sql server reporting services : Works in IE, not in VS.NET. (Type mismatch error?)

adolf garlic
3/14/2007 6:09:00 AM

Report works in IE (deploy to report server, view with browser) but is not
working in the VS.NET report designer preview.

As soon as I select the first report parameter, the following error is
displayed in the preview pane:

"An error occured during local report processing. The value provided for the
report parameter X is not valid for its type"

I have check the value expected by this parameter, it is an integer and this
is what is being passed in.

Has anyone else experienced this problem? Is this a caching issue? How many

EMartinez
3/14/2007 12:19:26 PM

On Mar 14, 8:09 am, adolf garlic
[quoted text, click to view]

I have seen the error before; however, for me it was a type-casting
problem (i.e., I needed to change the parameter type). Are you sure
that you have not revised the report after it was posted to the Report
Server (since it works fine there) or that your local parameter is
based on something in a table that has a different datatype in
production?

Regards,

Enrique Martinez
Sr. SQL Server Developer

adolf garlic
4/27/2007 12:04:01 AM

I've deleted the .data files.
It is using the same datasource/db as the report server version.
Same report in both places.
Still doesn't work

[quoted text, click to view]

Lisa Slater Nicholls
5/17/2007 9:06:08 AM

Have you set a default for this parameter? Just a guess that things might be
read in a different order when deployed than they do in the designer
preview. I've certainly experienced that.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn