SQL Bit Data Type parameters -- sql server reporting services

Support Mechanic
7/6/2005 2:19:02 PM

I am trying to use a stored procedure that is of data type of bit, however
SQL Reporting Services does not have this as a valid data type. I have added
the parameters to the report and have tried all the possible combinations but
keep getting error about converting string to the bit datatype.

RManion
7/6/2005 3:01:02 PM

Have you tried using a Boolean data type when setting up your report parameter?

[quoted text, click to view]

Support Mechanic
7/6/2005 3:09:02 PM

I have tried using the Boolean DataType and the Integer Data Type for the
Parameter in the report. Both still give the same error message about unable
to convert String to Boolean. Looking on the web I can find the error message
but as it relates to general programming and not to SQL Reporting Service.

I am using a vendors stored procedure so I can not modify the stored
procedure itself to change the data type to match what is available in MS
Reporting Services.

[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

sql server reporting services : SQL Bit Data Type parameters