Wednesday, March 21, 2012

Dataset cannot be generated error

When editing the data driven subscription query I SOMETIMES get the following error: The dataset cannot be generated. An error occurred while connecting to a data

source, or the query is not valid for the data source. (rsCannotPrepareQuery) Invalid object name '##XX'. The datasource is ok, authentication also, the query works... Why can't it see the temporary table?

How would I make it work with a temporary table? To update the problem:

when I validate the query I get the error described above however if I

run the same stored procedure that is used in a query in let's say

management studio and leave it open, the query in data driven

subscription web interface is validated succesfully. I'm running RS2005

on a Win2003Server.|||I really woul appreciate any suggestions, cause it's basically messing with my report server stability...thanks|||

Did you ever find a solution? I have the same problem. My data set involves concatenated SQL which causes the SP to not return the columns, but if I don't do it this way, I will be creating a monumental amount of work to have individual tables.