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