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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

About the scheduling of a report execution

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server


I need to exceute a SSRS 2005 report in batch with the SQL Server Agent. This report has some parameters. How can I do know to SQL Server Agent which are these parameters? I don't want to write the values in the settings of report subscription.

Is it possible to do to read a table containing the report parameters or to save to a table the parameters when the user launches the report in the report manager? Many thanks

View Complete Post

More Related Resource Links

IE cannot display the webpage during report execution

Hi. I have a problem with a report having some T-SQL and MDX queries. When I execute it during the working hours I have an error about that Internet Explorer cannot display the web page, but in the other hours the execution is completed successfully. I have a look inside RS log but I cannot find any errors; no timeout is set about report execution inside the Report Manager. Any ideas to solve this issue, please? Many thanks

Job Execution times / statistics report ...

We have several sites (countries if you may call them) and each site has its own set of ERP databases (Progress database). We have designed ETL layers that are open and which can be invoked for each of these sites. On top of the ETL layers, we scheduled the SSIS packages via SQL jobs for each site and scheduled them to run at various times of the day based on the site operating hours. I want to now present the amount of time it takes to copy data from the ERP system into our SQL 2008 Staging and finally into our DataWarehouse. I can manually right click on the SQL jobs and get the timings, however, I want to automate this report so that we can look at it initially weekly and maybe monthly when things start to run smoothly. Any pointers or ideas? I know I can run SQL Profiler and capture the SQL behind this report, would it actually work? ThanksJagannathan Santhanam

Error with Scheduling a Report to run in SSRS 2000


Getting the below error when trying to schedule the report to run.

I can run the report just fine as a stand-alone and not thru the scheduler.

I have several others that run just fine in the same way.

ReportingServicesService!processing!5d4!8/24/2010-01:15:02:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DataSource1'., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DataSource1'. ---> System.Data.Odbc.OdbcException: ERROR [01004] [AcuCorp, Inc.][AcuODBC Driver][ISAM]Unable to open xfd file
  at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
  at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method)
  at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
  at System.Data.Odbc.OdbcCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
  at Microsoft.ReportingServices.DataExtensions.CommandWrapper.ExecuteReader(CommandBehavior behavior)
  at Microsoft.ReportingServices.ReportProcessing.a1.v()
  --- End of inner exception stack trace ---

Issue - The report execution has expired or cannot be found. (rsExecutionNotFound)


Hello Experts,

I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,

"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.

I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.

Please help me to know what are these issue, are these two issues related and how to fix it?


Multiple report execution is not in parallel


Hi everybody,

I experienced an issue with Sharepoint Foundation 2010. (Server 2008 and Sharepoint Foundation 2010 64bit)

When I use multiple Reportviewer Web parts on one page, the rendering (and most likely the Query itself) is not executed in parallel, i.e. every web part waits for its predecessor to finish.

I made two screenshots to show the difference in behavior (both are on the exact same hardware)

Sharepoint 2010 (Total execution Time 32 sec) : http://img807.imageshack.us/img807/6712/sp2010.jpg

Report Execution Time Out/Delayed


I have a report i have developed in Bids sourcing from AS cube. Whe I execute the report inside BIDS, i get the results within couple of seconds. But when i run the same report from Report Manager Site, It process for a long time and then generate the following error. Any ideas gues?

An error occurred during client rendering. An error has occurred during report processing. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


Report Execution error when View page in VPN


I only have 1 user that cannot see reports. I even did a gotomeeting and we clicked refresh serveral times and we get the Report Execution Session died.


Every other user works on VPN. The rest of the wqeb site also works fine.


Does any have some pointers on find a resolution for this user. He is windows authenticated and using a VPN. ( I have 1 user out of at least 50 have worked fine with a report viewer over VPN.



Ideas appreciated. 

Dynamics AX Report call a function at the begin of report execution


I need a way to call a function at begin of execution of the report, and to call another function when execution ends.


I need to connect to SQL to call a stored procedure.

Valid Credentials for Report Execution Web Service


I've had an application running for some time which accesses reports via the reportingservices web service.   Recently I had a request to directly stream the reports for download rather than viewing them through the report viewer.  I facillitated this using the reportexecutionservice web service and in testing, everything went fine.  When deployed however, the downloads mysteriously failed to occur.

The issue traced to a 401 unauthorized error, which implies my network credentials were rejected.   Easy, right?  Well, the problem I'm having is that I'm using the same credentials for both the reportingservices web service and the reportexecutionservice web service and I had expected that what was sufficient for one was sufficient for the other. 

The credentials I'm passing are for a user which is a member of the SQLServerReportServerUser group on the machine hosting the web service.  Is this insufficient to run the reportexecutionservice, and if so, what do I need to do to adjust the security permissions of this user to grant them access to reportexecutionservice?

Page expired after report execution



I have created a complex SSRS 2005 report that queries a large dwh and a SSAS 2005 cube. Now, when I launch the report, the rendering takes more two hours and when I click to navigate on a drill-down report I have an error about the page is expired.

Any idea to solve this issue? Thanks

Strategies to schedule a report execution in SSRS 2005



I have implemented in SSRS 2005 a main report and some drill-down report created as a separate rdl. These reports have a parameter set in order to execute them. I need to organize a schedule stratey. I think to create a table to contain these parameters, with each record for each valid parameter set. This table could have more one record and so it has to be possible to execute the reports more times. I think to create a schedule for the main report, and one schedule for each drill-down reports. If I have f.e. ten records in the parameter table, the main and the drill-down report should be executed ten times, isn't it? After the entire elaboration, I think to cancel the parameters record in the parameter table.

Moreover, if any records isn't present in the parameter table any executions shouldn't start and any errors shouldn't be generated.

Any helps to me to organize the right strategy in order to solve this issue, please? Many thanks.

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

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