public JsonResult SaveToExcel( int?cropId, string searchFromDate, string searchToDate) { List <Crop_Details> cropDetailsData = CropDetailsManager.SearchCropData( cropId.GetValueOrDefault(), DateTime.Parse(searchFromDate), DateTime.Parse(searchToDate)); ReportingManager.GenerateReport(cropDetailsData); return(Json("Report Generated!")); }
private void Export() { DocsPaWR.PrintReportRequest request = new DocsPaWR.PrintReportRequest(); // Parametri requesti request.Title = "Registro degli Accessi - " + UserManager.getInfoAmmCorrente(UserManager.GetInfoUser().idAmministrazione).Descrizione; request.ContextName = "RegistroAccessiExport"; request.ReportKey = "RegistroAccessiExport"; request.SearchFilters = this.SetFilters(); switch (this.ddlFormatoPreReport.SelectedValue) { case "XLS": request.ReportType = DocsPaWR.ReportTypeEnum.Excel; break; case "ODS": request.ReportType = DocsPaWR.ReportTypeEnum.ODS; break; } DocsPaWR.FileDocumento fileDoc = ReportingManager.GenerateReport(request); if (fileDoc != null && fileDoc.content != null && fileDoc.content.Length > 0) { this.UpPnlDocumentData.Visible = true; this.FileDoc = fileDoc; this.frame.Attributes["src"] = "../Document/AttachmentViewer.aspx"; this.UpPnlDocumentData.Update(); this.UpPnlContentDxSx.Update(); } else { string msg = "ProceedingsReportNoDataFound"; ScriptManager.RegisterStartupScript(this, this.GetType(), "ajaxDialogModal", "if (parent.fra_main) {parent.fra_main.ajaxDialogModal('" + msg.Replace("'", @"\'") + "', 'warning', '');} else {parent.ajaxDialogModal('" + msg.Replace("'", @"\'") + "', 'warning', '');}", true); this.UpPnlDocumentData.Visible = false; this.UpPnlDocumentData.Update(); this.UpPnlContentDxSx.Update(); } }
private FileDocumento GenerateReport(String contextName, String reportKey, String title, String subtitle, ReportTypeEnum reportType, FiltroRicerca[] filters) { PrintReportRequest request = new PrintReportRequest() { ContextName = contextName, ReportKey = reportKey, ReportType = reportType, SubTitle = subtitle, Title = title, SearchFilters = filters, UserInfo = UserManager.GetInfoUser(), AdditionalInformation = (DocumentManager.getSelectedRecord() != null && DocumentManager.getInfoDocumento(DocumentManager.getSelectedRecord()) != null && DocumentManager.getInfoDocumento(DocumentManager.getSelectedRecord()).segnatura != null) ? DocumentManager.getInfoDocumento(DocumentManager.getSelectedRecord()).segnatura : string.Empty }; //generazione report da codice FileDocumento report = ReportingManager.GenerateReport(request); return(report); }