error with rdlc and mvc4 RSS

• • Reply
  

  namhaivolam

  Member

  6 Points

  19 Posts

  error with rdlc and mvc4

  Nov 11, 2012 06:16 PM|LINK

  i have tried to code follow the post : 

  http://weblogs.asp.net/rajbk/archive/2009/11/25/rendering-an-rdlc-directly-to-the-response-stream-in-asp-net-mvc.aspx

  and i use mvc4  with vs2012 ,try to crete printable document such as : pdf,word,.... 

  this is class to get customers from northwind database  :

  namespace MvcApplicationRpt2.Models
  {
      public class CustomerRpt
      {
          static public IEnumerable<Customer> GetAllCustomers()
          {
              var db = new NorthwindEntities();
              return db.Customers.AsEnumerable().ToList();
          }
      }
  }

  the rdlc i use wizad mode, choose the DataSource: NorthWindDataSet  and DataSet: DataSetCustomer 

  http://s756.beta.photobucket.com/user/namhaivolam/media/Untitled.png.html?sort=3&o=0

  and the controller :

   public ActionResult Index()
          {
              var localReport = new LocalReport { ReportPath = Server.MapPath("~/Reports/Report1.rdlc") };
              var reportDataSource = new ReportDataSource("Customers", CustomerRpt.GetAllCustomers());
  
              localReport.DataSources.Add(reportDataSource);
              const string reportType = "PDF";
              string mimeType;
              string encoding;
              string fileNameExtension;
              const string deviceInfo = "<DeviceInfo>" +
                                        "  <OutputFormat>PDF</OutputFormat>" +
                                        "  <PageWidth>8.5in</PageWidth>" +
                                        "  <PageHeight>11in</PageHeight>" +
                                        "  <MarginTop>0.5in</MarginTop>" +
                                        "  <MarginLeft>1in</MarginLeft>" +
                                        "  <MarginRight>1in</MarginRight>" +
                                        "  <MarginBottom>0.5in</MarginBottom>" +
                                        "</DeviceInfo>";
  
              Warning[] warnings;
              string[] streams;
  
              //Render the report
              byte[] renderedBytes = localReport.Render(
                  reportType,
                  deviceInfo,
                  out mimeType,
                  out encoding,
                  out fileNameExtension,
                  out streams,
                  out warnings);
  
              return File(renderedBytes, mimeType);
  
          }
  

  
  
  
  

  and when i try to use link 

  http://localhost:8640/getcustomerreport

  it throw exception:

  Server Error in '/' Application.
  Cannot create a data reader for dataset 'DataSetCustomer'.
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
  
  Exception Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a data reader for dataset 'DataSetCustomer'.
  
  Source Error:
  
  
  Line 41: 
  Line 42:             //Render the report
  Line 43:             byte[] renderedBytes = localReport.Render(
  Line 44:                 reportType,
  Line 45:                 deviceInfo,
  
  
  Source File: c:\Users\HaiNam\Documents\Visual Studio 2012\Projects\MvcApplicationRpt2\MvcApplicationRpt2\Controllers\GetCustomerReportController.cs    Line: 43
  
  Stack Trace:
  
  
  [ReportProcessingException: Cannot create a data reader for dataset 'DataSetCustomer'.]
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues) +6549
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQueryAndProcessAsIRowConsumer(Boolean processAsIRowConsumer) +2031
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunDataSetQuery() +33
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.InitializeAndRunLiveQuery() +59
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.InitializeRowSourceAndProcessRows() +71
     Microsoft.ReportingServices.OnDemandProcessing.TablixProcessing.RuntimeOnDemandDataSet.InitializeRowSourceAndProcessRows() +38
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.Process() +145
     Microsoft.ReportingServices.OnDemandProcessing.RuntimeAtomicDataSet.ProcessConcurrent(Object threadSet) +343
  
  [ProcessingAbortedException: An error has occurred during report processing.]
     Microsoft.ReportingServices.OnDemandProcessing.AbortHelper.ThrowAbortException(String uniqueName) +89
     Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.CheckAndThrowIfAborted() +131
     Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.FetchData() +588
     Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.PrefetchData(ReportInstance reportInstance, ParameterInfoCollection parameters, Boolean mergeTran) +699
     Microsoft.ReportingServices.OnDemandProcessing.Merge.FetchData(ReportInstance reportInstance, Boolean mergeTransaction) +259
     Microsoft.ReportingServices.ReportProcessing.Execution.ProcessReportOdpInitial.PreProcessSnapshot(OnDemandProcessingContext odpContext, Merge odpMerge, ReportInstance reportInstance, ReportSnapshot reportSnapshot) +301
     Microsoft.ReportingServices.ReportProcessing.Execution.ProcessReportOdp.Execute(OnDemandProcessingContext& odpContext) +615
     Microsoft.ReportingServices.ReportProcessing.Execution.RenderReportOdpInitial.ProcessReport(ProcessingErrorContext errorContext, ExecutionLogContext executionLogContext, UserProfileState& userProfileState) +224
     Microsoft.ReportingServices.ReportProcessing.Execution.RenderReport.Execute(IRenderingExtension newRenderer) +1093
     Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition) +242
     Microsoft.Reporting.LocalService.CreateSnapshotAndRender(ReportProcessing repProc, IRenderingExtension renderer, ProcessingContext pc, RenderingContext rc, SubreportCallbackHandler subreportHandler, ParameterInfoCollection parameters, DatasourceCredentialsCollection credentials) +93
     Microsoft.Reporting.LocalService.Render(String format, String deviceInfo, String paginationMode, Boolean allowInternalRenderers, IEnumerable dataSources, CreateAndRegisterStream createStreamCallback) +841
     Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +302
  
  [LocalProcessingException: An error occurred during local report processing.]
     Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) +354
     Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +162
     Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +65
     Microsoft.Reporting.WebForms.Report.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) +64
     MvcApplicationRpt2.Controllers.GetCustomerReportController.Index() in c:\Users\HaiNam\Documents\Visual Studio 2012\Projects\MvcApplicationRpt2\MvcApplicationRpt2\Controllers\GetCustomerReportController.cs:43
     lambda_method(Closure , ControllerBase , Object[] ) +101
     System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14
     System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +211
     System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
     System.Web.Mvc.Async.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41() +28
     System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +10
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57
     System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +48
     System.Web.Mvc.Async.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33() +57
     System.Web.Mvc.Async.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49() +223
     System.Web.Mvc.Async.<>c__DisplayClass37.<BeginInvokeActionMethodWithFilters>b__36(IAsyncResult asyncResult) +10
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57
     System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +48
     System.Web.Mvc.Async.<>c__DisplayClass2a.<BeginInvokeAction>b__20() +24
     System.Web.Mvc.Async.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult) +102
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +57
     System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +43
     System.Web.Mvc.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult) +14
     System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
     System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +57
     System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
     System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +47
     System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
     System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult) +25
     System.Web.Mvc.Async.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar) +23
     System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
     System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +47
     System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
     System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9629708
     System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
  

  How can you help me to solve this problem
  
  

• • Reply
  

  namhaivolam

  Member

  6 Points

  19 Posts

  Re: error with rdlc and mvc4

  Nov 12, 2012 02:13 AM|LINK

  i ve found the answer the name of ReportDataSource(x,...) x same name of dataset  in datasets refrence in data tool opreation !

  • Marked as answer by Young Yang - MSFT on Nov 25, 2012 12:06 PM
• • Reply
  

  Stuartq

  Member

  2 Points

  2 Posts

  Re: error with rdlc and mvc4

  Dec 21, 2012 12:06 AM|LINK

  Please can you elaborate on the solution?  I am having the same problem, but I'm not sure what you mean.  I have tried varying the first parameter passed in to match or differ to the dataset defined in the report, but to no avail.  What did you do to get it working?

     ReportDataSource reportDataSource = new ReportDataSource("datasetname", dataset);