Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter values to different email addresses

  • Hi Guys,

    Can anyone tell me how to Email a report Using Reporting Services in SQL Server 2005 Standard Edition with different parameter values to(having) different email addresses using standard subscriptions.

    Note:Standard Edition is not having the datadriven subscription.

    Any Help is greately appreciated

    Thanks

    Narayana

  • http://www.sqlservercentral.com/articles/Development/2824/

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Hi Jason,

    Thanks for the response.

    I ran this procedure in cursor so that i can generate reports for all the records in result set of the cursor.

    and the time delay is different for every record.For some records its taking less time and for some records its take more time.

    So the time delay code "WaitFor Dealy '00:00:02'" causing a problem. If i put small delay its giving error message

    ---------

    Msg 22022, Level 16, State 1, Line 0

    SQLServerAgent Error: Request to run job C5E96594-9876-42FE-9324-5F6DF8F5CC0B (from User Narayana) refused because the job already has a pending request from User Narayana.

    ---------

    I dont want to put more delay for small reports which takes vary less time.

    How could i resolve this problem

    Please help me in this issue

    Thanks

    Narayana

  • Hi Jason,

    else

    Is it possible to do like this

    untill current session job executes successfully

    start loop

    waitfor delay '00:00:02'

    check the jobstatus of current session

    end loop

    and the next record excutes procedure and generates report with its values

  • your second approach seems more effective.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg
  • Hello Narayana,

    You might want to check out our notification framework called Boomerang. With this framework you can create notifications (by emailing, faxing, printing etc.) that are static or dynamic with just a few lines of SQL code. The framework also offers a service oriented infrastructure to manage all your outgoing and incoming notifications. You can learn more on here.

    Good luck

    Michael

    Fuel9

Viewing 6 posts - 1 through 5 (of 5 total)

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