Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts

Tuesday, August 9, 2011

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Invalid column name 'AwaitingFirstExecution'.

Today when I resorted our reporstserver databases of SSRS to the newly formatted server I came across the below error as


An internal error occurred on the report server. See the error log for more details. (rsInternalError) Invalid column name 'AwaitingFirstExecution'.

After a lot of googling I found that the above error occurs when there is a difference between version of the reporting server and the report server databases .The solution for this error is as below

1) Stop the reporting server

2) Restore the Reporstserver and ReportServerTempDB databses.

3) Restart reportingsverever.

Tuesday, March 9, 2010

How to Show a SSRS Report in a Windows Application?

Requesting a Server Report
reportViewer.ProcessingMode =
Microsoft.Reporting.WinForms.ProcessingMode.Remote;
// Get the Report Server endpoint from the application
// config file
reportViewer.ServerReport.ReportServerUrl = new
Uri(Settings.Default.ReportServerEndPoint);
reportViewer.ServerReport.ReportPath ="/Prologika/Customer Orders";
reportViewer.RefreshReport();
Handling Report Parameters
ReportParameter[] parameters = new ReportParameter[2];
parameters[0] = new ReportParameter("Date", "1/1/2003");
parameters[1] = new ReportParameter("CustomerID",
new string[] { "14335", "15094" });
reportViewer.ServerReport.SetParameters(parameters);