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.