.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Pankaj Mishra
alex morco
Imran Ghani
Post New Web Links

Emailed Report not emailed...

Posted By:      Posted Date: October 01, 2010    Points: 0   Category :Sql Server

I have an SSRS 08 server which has many report subscriptions..

The ones that fire off on the morning work fine and email the report. Any report scheduled for later then the morninf just says 'new subscription' and doesn't send the report.

If I go in to one of the working report subscriptions and add a new subscription - and save it to send me the report in five minutes - it executes and says that it emailed me...but it always says "new subscription' NOT 'emailed to blah blah'..

I've checked the logs on the server...any ideas where to look? I'm stuck...


View Complete Post

More Related Resource Links

Security for emailed xls files

I want to email a spreadsheet showing a graph with a slider control but do not want the recipient to be able to access the calculations. Is this possible in my version of Excel which is 2003?

SharePoint 2010 email enabled list with workflow has incorrect User ID when items are emailed to the

I have set up an approval workflow for a document library that has email enabled. Emails come into the document library fine, however, if an item is emailed to the library the workflow kicks off with the initiator as "System Account" rather than the person who submitted the email. This makes the error of "The e-mail message cannot be sent. Make sure the e-mail has a valid recipient." come up. If someone submits a document directly to the library (by logging into sharepoint and submitting) everything works fine. The person submitting by email is a valid sharepoint user and the profile shows the correct email address. The Created by and Modified by fields show the correct person (rather than System Account), it's only the workflow User ID that shows incorrectly if document is emailed to library. Any help or ideas would be appreciated. Thanks

sql maintance job log emailed to user even it completed normally

Hi I have a maintenance job to backup and cleanup sharepoint database in sql 2008 r2 server daily at 2:00 AM.  This operation has been running for a copy weeks now.  We have just setup dbmail a day ago.   We have setup a few maintenance job and added "exec sp_send_dbmail @recipients='xyz@xyz.com', @subject='Sharepoint backup plan completed at SQL', @body='Sharepoint backup completed'" as the last step of the maintenance plan. I do recieve the email properly but our helpdesk recieve an email too for the full maintenance job log.  I checked the sql setup for all jobs and I cannot found anywhere that we know we are sending the maintenance log to helpdesk.  Any suggestion? below is part of the log/email: **************************************************** To: helpdesk Subject: SQL Server Message   Microsoft(R) Server Maintenance Utility (Unicode) Version 10.50.1600 Report was generated on "sql". Maintenance Plan: MaintenancePlan_Sharepoint_db_backup Duration: 00:00:27 Status: Succeeded. Details: Back Up Database (Full) (sql) Backup Database on Local server connection Databases: Bdc_Service_DB_007f3ba9b498493984af24119275bf4d,SharePoint_AdminContent_b57e62bd-1137-4e62-88de-fe28b2b268c7,SharePoint_Config,WSS_Content,WSS_Logging Type: Full Append existing Task start: 2010-09-16T02:00:01. Task end: 2010-09-16T02:00:25

SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than


We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.


It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)


So I quer

Can SharePoint accept emailed web forms?


Our school needs online web forms from our public web site (hosted elsewhere) to be sent to our SharePoint 2010 Enterprise internal site.  Once received by SharePoint, we want these forms to trigger workflows.

Is it possible to have the form submitted by email (from the public internet web site), emailed directly to the internal 2010 SharePoint site - or do I have to have the forms emailed to a secretary and then have her upload the forms to the internal SharePoint site, thus triggering the workflow?

I don't necessarily need SharePoint to read the form and take the data from the form and enter it into a list - I'll be happy if the emailed form just gets put in a Forms Library, where it can trigger a workflow just by being added to the library.


Thanks for any help you can give me!



How to be emailed about Scheduled end date on a document list item

I have configured a sharepoint document library to allow users to use scheduling and so it can be published and un-published on a given date. I need users to be able to set an alert to be informed about when scheduled end dates are reached. I tried using the out of the box alerts but this does not seem to be triggered. Can anyone suggest the best approach?

Can this be done? Comments on a task emailed to a different user


Currently I am using the built-in Approval workflow for a document library.  When a document is rejected, or a change is requested, I want the comments that the approver enters in the Task window Comments box to be sent to a user not on the list of approvers.


Eg:  Bill uploads a document.  Sally approves the document.  Sally requests a change.  Bill gets notified of Sally's change request.  I want Tom to get notified also and to be able to read the requested change comments.

Normally, the comments are just provided for the person who initiates the task by uploading the document.

Is there any way to grab these comments and add a separate workflow, or customize the built-in Approval workflow that would send these comments to a different user - I'd be happy to even send them to a different approver on the list of approvers.


Thanks in advance!


Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

How to use report viewer 2010 in VS 2008


I downloaded report viewer 2010 from here


Now I want to actually use it in a website.  How do I do that?  Do I have to modify some part of web.config?  Specifically, what do I need to change?


populate report viewer by code


Hi all

I have a button "Show Report" to show some data from table

what I should write under this button to populate the reports ?

A connection could not be made to the report server http://localhost/ReportServer.



  • I created a Report using Business Intelligence Studio. Its working working well, i can able to view records. But when i try to deploy the report an error occurs specifying that "A connection could not be made to the report server http://localhost/ReportServer. (Microsoft Report Designer)".
  • I open the IIS 7 and find out virtual directories "Reports" and "ReportServer" are available.
  • I check on the browser and type "http://localhost/reports".  I find the browser direct to this url: http://localhost/reports/Pages/Folder.aspx and find error specifying the following one:

         Error:The report server is not responding. Verify that the report server is running and can be accessed from this computer.

  • when i type http://localhost/reportmanager, i found the error:

    HTTP Error 404.0 - Not Found

    The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.


Stop Sorting Cross Tab Report Header


Dear, I want to stop sorting in cross tab report header. And also want to sort in specific order. How can i do that? Please help me. Its urgent


May i use the collapse and expand feature (like tree menu) in Report ?


HI all,

May i use the collapse and expand feature (like tree menu) at Report iam using the Report viewer  Control for displaying the Report on my Asp.net Page .


I have number records and each record have detail as i clicked or expand the record then details will be shown is it possible with report viewer control 
If any one have experince before please share the ideas.


Best Regards

Cannot Display Image in Report


 I have a report using an image control that needs to display an image inside subfolder "Images\InstitutionLogos\".

On properties of image control i have the following properties set:

MIMEType= "image/png"

Source      = Database

Value        ="\Images\InstitutionLogos\" +Fields!InstitutionID.Value+".png"

Inside subfolder "Images\InstitutionLogos\" each image is named with a number which represents Fields!InstitutionID.,(ex, 1.png, 2.png, 10.png)

However, when i run the report the image just displays an X, what am i missing?

Dynamic Report in reportviewer


HI I m sorry to say this But this task too urgent.

 Ex- i have two tables in my db name called Comdetails, deptdetails.

TCS is a one company name stored in ComDetails and Company_ID took as primany key,

TCS having 10 department stored in deptdetails and Company_ID as foreign key.

so now in DB we have available one company with 10 departments.

so now i need to generate report , i m using report.rdlc and reportviewer.

i hope upto now its clear.

my task-

1- i have two pages in a report in page 1 i m doing designing report like top i  need to show companydetails, middle frist department details in deptdetails table , and bottom some calculation part leave about calculation part. in report page 2 on  top i need to show second department details from deptdetails next below the design again same design i did here i need to show 3 department details from deptdetails next below the design again same design i did here i need to show 4 department details from deptdetails next below again calculation part design leave about calculation part. so up to now i shown 4 department details here still i need to show 6 department details , for this programatically after 4 department details finish next generate dynamatically page 2 of re

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Report viewer error


  • An error has occurred during report processing.
    • A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1".

  • i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend