Error generating production report - Reportviewer Version 11

Asked

Viewed 158 times

2

I am working with webforms and generating a report in reportviewer locally, the report accepts parameters and has a dataset

// Parametros
List<ReportParameter> parametersReport = new List<ReportParameter>();
parametersReport.Add(new ReportParameter("Nome", "Nome Teste TI"));
parametersReport.Add(new ReportParameter("Idade", "25"));

// DataSet
RecursoDeGlosaDataSet recursoDataSet = new RecursoDeGlosaDataSet();

// recursosFinalizados **vem do banco
recursosFinalizados.ToList().ForEach(y =>
{
     recursoDataSet.Recurso.AddRecursoRow(
                y.DataInicioRealizacao.ToString("dd/MM/yyyy"),
                y.DataFim.Value.ToString("dd/MM/yyyy"),
                y.CodigoTabela,
                y.CodigoProcedimento,
                y.DescricaoProcedimento,
                y.GrauParticipacao,
                y.CodigoItem,
                y.ValorRecursado.ToString(),
                y.Justificativaitem,
                y.ValorAcatado.ToString(),
                y.JustificativaCliente);
});

ReportViewer ReportViewer = new ReportViewer();

ReportViewer.ProcessingMode = ProcessingMode.Local;
eportViewer.LocalReport.ReportPath = "caminhoDoRelatorio"; // o caminho está ok

ReportViewer.LocalReport.DataSources.Add(
new Microsoft.Reporting.WebForms.ReportDataSource("RecursoDeGlosaDataSet",
(System.Data.DataTable)recursoDataSet.RecursoGlosa));

ReportViewer.LocalReport.SetParameters(parametersReport);

string mimeType = "";
string encoding = "";
string filenameExtension = "";
string[] streams = null;
Microsoft.Reporting.WebForms.Warning[] warnings = null;
string theDeviceSettings = "<DeviceInfo> 
<HumanReadablePDF>True</HumanReadablePDF></DeviceInfo>";

byte[] bytes = ReportViewer.LocalReport.Render("PDF", theDeviceSettings, 
out mimeType, out encoding, out filenameExtension, out streams, out 
warnings);

Now I go to error: report runs perfectly on my machine but when putting on PRODUCTION fell into the following error :

Ocorreu um erro durante o processamento de relatórios local.     
at Microsoft.Reporting.WebForms.LocalReport.EnsureExecutionSession()     at 
Microsoft.Reporting.WebForms.LocalReport.SetParameters(IEnumerable`1 
parameters)

*Note: I installed reportviewer by nuget, so the following dlls are in production (Install-Package Microsoft.Report.Viewer -Version 11.0.0)

  • Microsoft.ReportViewer.Common.dll
  • Microsoft.ReportViewer.Processingobjectmodel.dll
  • Microsoft.ReportViewer.Webforms.dll

1 answer

1


Some DLL’s are required on the server for the operation of Report Viewer, when deploying in addition to the DLL’s you have already included try adding the following:

  1. Microsoft.ReportViewer.Datavisualization.dll
  2. Microsoft.SqlServer.Types.dll
  • Amazing guy, saved my day vlw msm !!!

Browser other questions tagged

You are not signed in. Login or sign up in order to post.