Hi ,

Actually my task is to send report to different clients to their email address using respective parameter values

The cursor will give a result set with columns like clientno, emailadddress, depot

need to generate a report using values client1,depot1,email1 and to send mail to email1

similarly

need to generate a report using values client2,depot2,email2 and to send mail to email2

need to generate a report using values client3,depot3,email3 and to send mail to email3

Parameter values changes with clientno. and report format is same, data is different to different clients

I am looping the job with records because.

I created a email delivery subscription to email a report in reporting services.

and i observed that a subscription creates a job and with parameter fields and values in the subscriptions table.

I want to send a report to different clients having different parameter values, email address.

To do this for every record i am overwriting the parameter values in subscription table and then executing the job.

so that i can generate the reports with different parameters.

Same like data driven subscription.

And we are using the STANDARD EDITION of sql server.

Please help if you know any other way to do this task. LIKE using webservices or any other method to email reports to different clients

Any help is appreciated

Narayana