SSRS Mail subscription
In SSRS i have configured and subscribed mail correctly and when i was sending report through mail subcription its showing as mail sent successfully and its not showing in my mail box. There is no error showing in SSRS or in SSRS report manager. GSKR
December 20th, 2012 6:56am

Hi, Please check your email name first, and then make sure your mail server is working. I hope this is helpful.Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem Elmozamil Elamir Hamid MCTS: SQL Server Administration/Development MyBlog
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2012 9:10am

Hi Elamir, Thanks for your reply. email name and configurations are ok. mail server is working fine. .EML files(outlook files) are storing in c:\inetpub\mailroot\pickup. i am not able to see any out mail in sent box and any errors in SSRS.GSKR
December 20th, 2012 9:38am

the mails that have been sent will not be stored in your sent box it will be sent by the server with a sender ID that has been configured in the server. Pass your id in To section of the email subscription then you will get to know. http://gaurangpatel.net/setting-up-email-subscriptions-in-ssrs Regards,Eshwar.--Please use Marked as Answer if my post solved your problem and use Vote As Helpful if the post was useful.
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2012 10:21am

Hi Eshwar, I have already given the ID in TO box. but still am not getting any emails from SSRS. GSKR
December 20th, 2012 1:07pm

any suggestions...GSKR
Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2013 1:06am

Dear all, i have one problem in ssrs.i need to display sales report customer wise [sales and budget and variance and variance percentage] from different databases but in single server.it will be there detailes in multiple databases.i need to display detailes in single report.could you please anyone help me.for example we are maintaining 2010,2011 databases so i need to display customer no,sales,budget,variance,variance percentage in single report ... year from 2012 year to 2013 date filter 01-01-12..31-12-13 Customer No. Sales -2012 Budget-2012 Variance-2012 Variance %-2012 Sales -2013 Budget-2013 Variance-2013 Variance %-2013 i need details like this in one report using multiple databases.please anyone help me. navya krishna katta
January 23rd, 2013 2:03am

What is the version are you using? if it is 2008r2. you can u lookup function here is similiar post How to calculate two or more datasets in reporting services(report design) GSKR
Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2013 2:23am

yes i am using 2008 r2.could you please how to write look up code.already i wrote but it's not working.
January 23rd, 2013 9:11am

Woah talk about thread hijacking^^ GSKR - Have you looked in your junk mail folder? I recently got RS email semi-working and they were being delivered there until it was added as a safe sender in my outlook
Free Windows Admin Tool Kit Click here and download it now
January 23rd, 2013 9:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics