data driven subscription

Question

data driven subscription

dva2007

SSCertifiable

Points: 7707
More actions
December 23, 2008 at 8:46 am

#195370

Hi,
i have some weird error in data driven subscription set up. I have worked before on this and it works fine with other reports. I have set up one report and i am writing simple query to get recepient but giving some error like below:
I am writing simple query like:
select email, code from table where code = cons
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) Get Online Help Invalid column name 'cons'.
I can see that there is a parameter name calles 'CONS' and it shows below the query but it doesnt like it.
Any suggestion please?
thanks,
vijay

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

mRainey Right there with Babe Points: 796 More actions · Answer 1

You are not able to pass parameters into the Data Driven Subscription query. Reporting Services thinks that "cons" is a column and doesn't recognize it.

Enjoy!

Michael R.

dva2007 SSCertifiable Points: 7707 More actions · Answer 2

I have passed the report parameter into query before and it worked fine. In the set up window itself it shows that report takes following parameter: cons.....so report knows that cons is a parameter then how come it cant recognize? THIS IS WEIRD.

dva2007 SSCertifiable Points: 7707 More actions · Answer 3

I have sorted this. The reason is the parameter name of the report and the field name of the table should be same. It works with the same name. I dont know why it doesnt recognize the parameter name and if it is same with the field name then it does.