"Carl Henthorn" wrote:

> I am trying to re-create a report I had semi-running earlier. I create a new
> project in VS2005, add a data source. all is ok so far. In the query builder,
> I add the stored procedure call to run the report
> "Exec GetConsumer @agency" with @agency being an Int parameter that is
> passed in at report runtime. The query builder wont take it!!! I cannot get
> past this and am very stuck!
> the error is "There is an error in the query. Implicit conversion from data
> type sql_variant to int is not allowed. Use the CONVERT function to run this
> query."
> This is complete BS since the sproc runs fine in sql 2000 and sql 2005.
>
> What can I do to get around this?