public static void Generate(Telerik.ReportViewer.Html5.WebForms.ReportViewer rv, IEnumerable<object> data, string extension, SortDescriptorCollection sortDescriptors, GroupDescriptorCollection grpDescriptors)
{
Telerik.Reporting.Report report1 = new Telerik.Reporting.Report();
report1.DataSource = data;
string sortCol = "";
string sortDir = "";
//multi sort can be done by iterating through collection like for group
if (sortDescriptors.Count > 0)
{
ColumnSortDescriptor sd = sortDescriptors[0] as ColumnSortDescriptor;
sortCol = sd.Column.UniqueName;
sortDir = sd.SortDirection.ToString();
}
//Page Header Section
Telerik.Reporting.PageHeaderSection pageHeaderSection1 = new Telerik.Reporting.PageHeaderSection();
pageHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
pageHeaderSection1.Style.BackgroundColor = Color.Gray;
Telerik.Reporting.TextBox txtHead = new Telerik.Reporting.TextBox();
txtHead.Value = "Title";
txtHead.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.2395832538604736D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch));
txtHead.Name = "reportTitle";
txtHead.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5603775978088379D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
pageHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { txtHead });
IEnumerator dataColl = data.GetEnumerator();
int count = 0;
int first = 0;
object obj = null;
while (dataColl.MoveNext())
{
if (first == 0)
{
obj = dataColl.Current;
foreach (PropertyInfo info in obj.GetType().GetProperties())
{
count++;
}
first++;
}
}
Telerik.Reporting.Drawing.Unit x = Telerik.Reporting.Drawing.Unit.Inch(0);
Telerik.Reporting.Drawing.Unit y = Telerik.Reporting.Drawing.Unit.Inch(0);
Telerik.Reporting.ReportItemBase[] headColumnList = new Telerik.Reporting.ReportItem[count];
Telerik.Reporting.ReportItemBase[] detailColumnList = new Telerik.Reporting.ReportItem[count];
Telerik.Reporting.Group group = new Telerik.Reporting.Group();
SizeU size = new SizeU(Telerik.Reporting.Drawing.Unit.Inch((double)(22) / count), Telerik.Reporting.Drawing.Unit.Inch(0.6));
int column = 0;
foreach (PropertyInfo info in obj.GetType().GetProperties())
{
string columnName = info.Name;
Telerik.Reporting.HtmlTextBox headerCol = CreateTxtHeader(columnName, column);
headerCol.Style.BackgroundColor = Color.LemonChiffon;
headerCol.Style.BorderStyle.Default = BorderType.Solid;
headerCol.Style.BorderWidth.Default = Unit.Pixel(1);
headerCol.CanGrow = true;
headerCol.Location = new Telerik.Reporting.Drawing.PointU(x, y);
headerCol.Size = size;
headColumnList[column] = headerCol;
Telerik.Reporting.TextBox textBox = CreateTxtDetail(columnName, column);
textBox.Style.BorderStyle.Default = BorderType.Solid;
textBox.Style.BorderWidth.Default = Unit.Pixel(1);
textBox.CanGrow = true;
textBox.Location = new Telerik.Reporting.Drawing.PointU(x, y);
textBox.Size = size;
detailColumnList[column] = textBox;
textBox.ItemDataBinding += new EventHandler(textBox_ItemDataBound);
x += Telerik.Reporting.Drawing.Unit.Inch(headerCol.Size.Width.Value);
column++;
}
Telerik.Reporting.ReportItemBase[] groupColumnList = new Telerik.Reporting.ReportItem[grpDescriptors.Count];
int i = grpDescriptors.Count;
if (grpDescriptors.Count > 0)
{
Telerik.Reporting.GroupHeaderSection groupHeaderSection1 = new Telerik.Reporting.GroupHeaderSection();
foreach (ColumnGroupDescriptor grpDescriptor in grpDescriptors)
{
string grpCol = grpDescriptor.Column.UniqueName;
group.Groupings.Add(new Grouping("=Fields." + grpCol));
if (grpDescriptor.SortDirection.ToString().ToLower() == "descending")
{
group.Sortings.Add(new Sorting("=Fields." + grpCol, SortDirection.Desc));
}
else
{
group.Sortings.Add(new Sorting("=Fields." + grpCol, SortDirection.Asc));
}
i--;
Telerik.Reporting.TextBox hdCol = new Telerik.Reporting.TextBox();
hdCol.Style.BackgroundColor = Color.Orange;
hdCol.Style.BorderStyle.Default = BorderType.Solid;
hdCol.Style.BorderWidth.Default = Unit.Pixel(1);
hdCol.KeepTogether = true;
hdCol.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5603775978088379D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
hdCol.Value = "=[" + grpCol + "]";
groupColumnList[i] = hdCol;
group.GroupHeader = groupHeaderSection1;
//to avoid extra row after group col
group.GroupHeader.Height = Telerik.Reporting.Drawing.Unit.Inch(0);
}
groupHeaderSection1.Items.AddRange(groupColumnList);
}
if (sortCol.Length > 0)
{
group.Groupings.Add(new Grouping("=Fields." + sortCol));
if (sortDir.ToLower() == "descending")
{
group.Sortings.Add(new Sorting("=Fields." + sortCol, SortDirection.Desc));
}
else
{
group.Sortings.Add(new Sorting("=Fields." + sortCol, SortDirection.Asc));
}
}
ReportHeaderSection reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection();
reportHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
reportHeaderSection1.Items.AddRange(headColumnList);
report1.Groups.Add(group);
//Detail Section
Telerik.Reporting.DetailSection detailSection1 = new Telerik.Reporting.DetailSection();
detailSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
detailSection1.Items.AddRange(detailColumnList);
//Page Footer Section
Telerik.Reporting.PageFooterSection pageFooterSection1 = new Telerik.Reporting.PageFooterSection();
pageFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(0.3, Telerik.Reporting.Drawing.UnitType.Inch);
pageFooterSection1.Style.BackgroundColor = Color.LightGray;
pageFooterSection1.PrintOnFirstPage = true;
pageFooterSection1.PrintOnLastPage = true;
Telerik.Reporting.TextBox txtFooter = new Telerik.Reporting.TextBox();
txtFooter.Value = "='Page ' + PageNumber + ' of ' + PageCount";
txtFooter.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.2395832538604736D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch));
txtFooter.Name = "pageInfoTextBox";
txtFooter.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.5603775978088379D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch));
Telerik.Reporting.PictureBox picBoxFooter = new Telerik.Reporting.PictureBox();
picBoxFooter.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.2395832538604736D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch));
picBoxFooter.Value = @"C:\CCMSGoldStandard_Local\CCMSGoldStandard\CCMSAppShell\Images\no.png";
picBoxFooter.Style.TextAlign = Telerik.Reporting.Drawing.
HorizontalAlign.Center;
picBoxFooter.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Inch))), new Telerik.Reporting.Drawing.Unit(.5D, ((Telerik.Reporting.Drawing.UnitType)(Telerik.Reporting.Drawing.UnitType.Inch))));
picBoxFooter.Sizing = ImageSizeMode.AutoSize;
pageFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { txtFooter, picBoxFooter });
//add all section to report
report1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { pageHeaderSection1, reportHeaderSection1, detailSection1, pageFooterSection1 });
report1.PageSettings.Landscape = false;
report1.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
report1.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(.25, Telerik.Reporting.Drawing.UnitType.Inch);
report1.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(.25, Telerik.Reporting.Drawing.UnitType.Inch);
report1.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch);
Telerik.Reporting.Drawing.SizeU paperSize = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(22, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(22, Telerik.Reporting.Drawing.UnitType.Inch));
report1.PageSettings.PaperSize = paperSize;
report1.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Custom;
Hashtable deviceInfo = new Hashtable();
deviceInfo["FontEmbedding"] = "Subset";
if (extension.ToLower() == "csv")
{
deviceInfo["NoHeader"] = true;
deviceInfo["NoStaticText"] = true;
}
Telerik.Reporting.Processing.ReportProcessor RP = new Telerik.Reporting.Processing.ReportProcessor();
byte[] buffer = RP.RenderReport(extension.ToUpper(), report1, deviceInfo).DocumentBytes;
string myPath = "C:";
string file = myPath + @"\" + DateTime.Now.ToString("HHmmss") + "." + extension;
FileStream fs = new FileStream(file, FileMode.Create);
fs.Write(buffer, 0, buffer.Length);
fs.Flush();
fs.Close();
Process.Start(file);
}
protected void ButtonDene_Click(object sender, EventArgs e)
{
//Create new CultureInfo
var cultureInfo = new System.Globalization.CultureInfo("tr-TR");
// Set the language for static text (i.e. column headings, titles)
System.Threading.Thread.CurrentThread.CurrentUICulture = cultureInfo;
// Set the language for dynamic text (i.e. date, time, money)
System.Threading.Thread.CurrentThread.CurrentCulture = cultureInfo;
EFDal ed = new EFDal();
var instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = new KalibrasyonRaporlari.KYS();
this.KYSReport.ReportSource = instanceReportSource;
Telerik.Reporting.Report report = (Telerik.Reporting.Report)instanceReportSource.ReportDocument;
report.ReportParameters["BolgeKodu"].Value = 1;
//report.ReportParameters[0].Value = 1;
report.ReportParameters["BasTar"].Value = DateTime.Parse("2015-01-01");
report.ReportParameters["SonTar"].Value = DateTime.Parse("2015-06-01");
Telerik.Reporting.TextBox txtAciklama = report.Items.Find("txtAciklama", true)[0] as Telerik.Reporting.TextBox;
txtAciklama.Value = ed.BolgeKodundanBolgeAdiniDon(Convert.ToInt32(report.ReportParameters["BolgeKodu"].Value)) +
" bölgesi için " + report.ReportParameters["BasTar"].Value.ToString().Replace(" 00:00:00", "") + " ve " + report.ReportParameters["SonTar"].Value.ToString().Replace(" 00:00:00", "") +
" tarihleri arasında gecikme sürelerini aşağıda görebilirsiniz";
}
/// <summary>
/// Export report results in a given format
/// </summary>
/// <param name="reportToExport">Holds report object</param>
/// <param name="reportFormat">Hold report format</param>
/// <returns>Returns generated file name</returns>
private string Export(Telerik.Reporting.Report reportToExport, string reportFormat)
{
var reportProcessor = new ReportProcessor();
var instanceReportSource = new InstanceReportSource {
ReportDocument = reportToExport
};
RenderingResult result = reportProcessor.RenderReport(reportFormat, instanceReportSource, null);
string dateTimeStamp = DateTime.Now.ToString(Constants.DateTimeExtendedFormat);
string fileName = string.Format("{0}{1}.{2}", Constants.ModelingReportFileBaseName, dateTimeStamp, result.Extension);
string path = GlobalConfigVariable.ReportsFilePath;
string filePath = Path.Combine(path, fileName);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
using (var fs = new FileStream(filePath, FileMode.Create))
{
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}
return(fileName);
}
//public async Task<string> GetAccessToken()
//{
// UserPasswordCredential creds = new UserPasswordCredential("*****@*****.**", "Welcome@123");
// AuthenticationResult authenticationResult = null;
// var authenticationContext = new AuthenticationContext("https://login.windows.net/common/oauth2/token/");
// authenticationResult = await authenticationContext.AcquireTokenAsync("https://analysis.windows.net/powerbi/api", "c565eea1-4938-468e-8d5f-35b74ac5e8e5", creds);// new ClientCredential(Secrets.ClientID,Secrets.ClientSecret));
// return authenticationResult.AccessToken.ToString();
//}
public async Task <string> CreatePGXCaseReport(PGXCaseReportData dataSource)
{
string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTemplateLocation"].ToString() + "\\" + dataSource.TemplateName;
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreWhitespace = true;
Telerik.Reporting.Report report = null;
using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
{
ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
}
report.DataSource = dataSource;
ReportProcessor reportProcessor = new ReportProcessor();
InstanceReportSource instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
return(Convert.ToBase64String(result.DocumentBytes));
}
public async Task <string> GenerateSequenceReport(string template, CaseSequenceData dataSource)
{
string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTempLocation"].ToString() + "\\" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".trdx";
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreWhitespace = true;
Telerik.Reporting.Report report = null;
byte[] templateBytes = Convert.FromBase64String(template);
File.WriteAllBytes(filePath, templateBytes);
using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
{
ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
}
report.DataSource = dataSource;
ReportProcessor reportProcessor = new ReportProcessor();
InstanceReportSource instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
return(Convert.ToBase64String(result.DocumentBytes));
}
public async Task <string> GenerateReport(string template, CaseQualitativeData dataSource)
{
//Reference:http://www.telerik.com/forums/programmatically-use-of-trdp-report
//sample reports:C:\Program Files (x86)\Telerik\Reporting R1 2017\Report Designer\Examples
string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTempLocation"].ToString() + "\\" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".trdx";
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreWhitespace = true;
Telerik.Reporting.Report report = null;
byte[] templateBytes = Convert.FromBase64String(template);
File.WriteAllBytes(filePath, templateBytes);
using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
{
ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
}
report.DataSource = dataSource;
ReportProcessor reportProcessor = new ReportProcessor();
InstanceReportSource instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
return(Convert.ToBase64String(result.DocumentBytes));
}
private void ImprimirXLSGral(ArrayList ALValorParametrosGeneral, Type instance)
{
try
{
//Reporte de Facturas vigentes
Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosGeneral.Count - 1; i++)
{
report1.ReportParameters[i].AllowNull = true;
report1.ReportParameters[i].Value = ALValorParametrosGeneral[i];
}
//report1.ReportParameters[23].Value = 1;
//report1.ReportParameters[16].Value = 63;
//report1.ReportParameters[1].Value = "Pendiente por facturar";
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("XLS", report1, null);
string ruta = Server.MapPath("Reportes") + "\\" + instance.Name + ".xls";
if (File.Exists(ruta))
{
File.Delete(ruta);
}
FileStream fs = new FileStream(ruta, FileMode.Create);
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
fs.Flush();
fs.Close();
RadAjaxManager1.ResponseScripts.Add("startDownload('" + instance.Name + ".xls');");
}
catch (Exception ex)
{
throw ex;
}
}
private void SaveReport(Telerik.Reporting.Report report, string fileName)
{
ReportProcessor reportProcessor = new ReportProcessor();
Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
using (FileStream fs = new FileStream(fileName, FileMode.Create))
{
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}
}
public async Task <string> CreateToxicologyAccessionReport(ReportCaseData dataSource, string templateName)
{
int seriesCount = dataSource.PreviousHistoryChartData.Select(x => x.Name).Distinct().Count();
int xAxisDataCount = dataSource.PreviousHistoryChartData.Select(x => x.DateCollected).Distinct().Count();
//dataSource.ChartData = await this.GenerateChartImageFromXlsxFile("", "", dataSource.PreviousHistoryExcelChartData, seriesCount, xAxisDataCount);
Console.Write(dataSource.ToString());
Console.WriteLine(templateName);
//string templateName = "ToxicologyAccessionCaseReport";
string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTemplateLocation"].ToString() + "\\" + templateName + ".trdx";
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreWhitespace = true;
Telerik.Reporting.Report report = null;
using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
{
ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
}
report.DataSource = dataSource;
ReportProcessor reportProcessor = new ReportProcessor();
InstanceReportSource instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
//var reportLocation = ConfigurationManager.AppSettings["ReportTempLocation"];
//string reportName = templateName+"_" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".pdf";
//string reportDestination = Path.Combine(reportLocation, reportName);
//using (FileStream fs = new FileStream(reportDestination, FileMode.Create))
//{
// fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
//}
//string reportUrl = dataSource.ServerUrl + "/" + reportName;
////byte[] bytes = result.DocumentBytes;
//string response = Convert.ToBase64String(bytes);
return(Convert.ToBase64String(result.DocumentBytes));
}
public static void ExportToPDF(Telerik.Reporting.Report reportToExport)
{
ReportProcessor reportProcessor = new ReportProcessor();
//Telerik.Reporting.InstanceReportSource instanceReportSource = new Telerik.Reporting.InstanceReportSource();
//instanceReportSource.ReportDocument = reportToExport;
RenderingResult result = reportProcessor.RenderReport("PDF", reportToExport, null);
string fileName = result.DocumentName + DateTime.Now.Ticks + "." + result.Extension;
var directoryInfo = Directory.GetParent(Directory.GetCurrentDirectory()).Parent;
string projectPath = directoryInfo.FullName;
string folderName = Path.Combine(projectPath, "TestDataSource");
if (!Directory.Exists(folderName))
{
Directory.CreateDirectory(folderName);
}
string filePath = Path.Combine(folderName, fileName);
using (FileStream fs = new System.IO.FileStream(filePath, System.IO.FileMode.Create))
{
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
}
//Response.Clear();
//Response.ContentType = result.MimeType;
//Response.Cache.SetCacheability(HttpCacheability.Private);
//Response.Expires = -1;
//Response.Buffer = true;
//Response.AddHeader("Content-Disposition",
// string.Format("{0};FileName=\"{1}\"",
// "attachment",
// fileName));
//Response.BinaryWrite(result.DocumentBytes);
//Response.End();
}
public static ReportSource RenderReportData(byte[] ReportBinaryData, Dictionary <string, object> Parameters)
{
ReportPackager pack = new ReportPackager();
Telerik.Reporting.Report doc = pack.Unpackage(new MemoryStream(ReportBinaryData));
InstanceReportSource instance = new InstanceReportSource();
instance.ReportDocument = doc;
if (Parameters != null)
{
foreach (KeyValuePair <string, object> kvp in Parameters)
{
instance.Parameters.Add(new Telerik.Reporting.Parameter(kvp.Key, kvp.Value));
}
}
return(instance);
}
public async Task <string> CreateToxLabOrderRequisitionReport(ToxLabOrderReportData dataSource, string templateName = "ToxLabOrderRequisitionReport.trdx")
{
string filePath = System.Configuration.ConfigurationManager.AppSettings["ReportTemplateLocation"].ToString() + "\\" + templateName;
XmlReaderSettings settings = new XmlReaderSettings();
settings.IgnoreWhitespace = true;
Telerik.Reporting.Report report = null;
using (XmlReader xmlReader = XmlReader.Create(filePath, settings))
{
ReportXmlSerializer xmlSerializer = new ReportXmlSerializer();
report = (Telerik.Reporting.Report)xmlSerializer.Deserialize(xmlReader);
}
report.DataSource = dataSource;
ReportProcessor reportProcessor = new ReportProcessor();
InstanceReportSource instanceReportSource = new InstanceReportSource();
instanceReportSource.ReportDocument = report;
RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, null);
//var reportLocation = ConfigurationManager.AppSettings["ReportTempLocation"];
//string reportName = dataSource.Id + "_ToxLabOrderRequisition_" + Guid.NewGuid().ToString() + "_" + DateTime.Now.ToString("yyyyMMdd_HH_mm_ss") + ".pdf";
//string reportDestination = Path.Combine(dataSource.FolderPath, reportName);
//using (FileStream fs = new FileStream(reportDestination, FileMode.Create))
//{
// fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
//}
//string reportUrl = dataSource.ServerUrl + "/" + reportName;
//byte[] bytes = result.DocumentBytes;
//string response = Convert.ToBase64String(bytes);
return(Convert.ToBase64String(result.DocumentBytes));
}
public ltrECChineseEnglishFormsEnquiry(List <clsECLetter> objLettera, DataSet dsFooterCountry)
{
objLetter = objLettera;
Telerik.Reporting.Report ReportToDisplay = null;
//
// Required for telerik Reporting designer support
//
ltrECEnglishFormEnquiry recnewEnglish = new ltrECEnglishFormEnquiry(objLettera, dsFooterCountry);
ltrECChineseFormEnquiry rechineseReport = new ltrECChineseFormEnquiry(objLettera, dsFooterCountry);
InitializeComponent();
this.subReport2.ReportSource = recnewEnglish;
this.subReport1.ReportSource = rechineseReport;
//table1.DataSource = objLetter;
//ReportToDisplay = new ltrECEnglishFormEnquiry(objLettera, dsFooterCountry);
if ((dsFooterCountry != null) && (dsFooterCountry.Tables.Count > 0) && (dsFooterCountry.Tables[0].Rows.Count > 0))
{
txtCountry.Value = dsFooterCountry.Tables[0].Rows[0]["CompanyName"].ToString();
txtAddress.Value = dsFooterCountry.Tables[0].Rows[0]["CompContact"].ToString();
txtMail.Value = dsFooterCountry.Tables[0].Rows[0]["CompEmail"].ToString();
}
}
private void ImprimirXLS(ArrayList ALValorParametrosInternos, Type instance, ArrayList ALValorParametrosConsignacion, Type instance2)
{
try
{
//Reporte de Facturas vigentes
Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
report1.ReportParameters[i].AllowNull = true;
report1.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
report1.ReportParameters[23].Value = 1;
report1.ReportParameters[16].Value = 63;
report1.ReportParameters[1].Value = "Pendiente por facturar";
//Reporte de Facturas vencidas
Telerik.Reporting.Report reportPXFVEN = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
if (i == 23)
{
reportPXFVEN.ReportParameters[i].AllowNull = true;
reportPXFVEN.ReportParameters[i].Value = 0;
}
else
{
reportPXFVEN.ReportParameters[i].AllowNull = true;
reportPXFVEN.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
}
reportPXFVEN.ReportParameters[23].Value = 0;
reportPXFVEN.ReportParameters[16].Value = 63;
reportPXFVEN.ReportParameters[1].Value = "Pendiente por facturar";
//Reporte de prueba Vigente
Telerik.Reporting.Report PruebaVIG = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
PruebaVIG.ReportParameters[i].AllowNull = true;
PruebaVIG.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
PruebaVIG.ReportParameters[16].Value = 64;
PruebaVIG.ReportParameters[1].Value = "Prueba";
PruebaVIG.ReportParameters[23].Value = 0; //vigente
//Reporte de prueba Vencidas
Telerik.Reporting.Report PruebaVEN = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
PruebaVEN.ReportParameters[i].AllowNull = true;
PruebaVEN.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
PruebaVEN.ReportParameters[16].Value = 64;
PruebaVEN.ReportParameters[1].Value = "Prueba";
PruebaVEN.ReportParameters[23].Value = 1; //Vencida
//Reporte de No conformes Vigente
Telerik.Reporting.Report NCVIG = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
NCVIG.ReportParameters[i].AllowNull = true;
NCVIG.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
NCVIG.ReportParameters[16].Value = 65;
NCVIG.ReportParameters[1].Value = "Producto no conforme";
NCVIG.ReportParameters[23].Value = 0; //vigente
//Reporte de No Conforme Vencidas
Telerik.Reporting.Report NCVEN = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
{
NCVEN.ReportParameters[i].AllowNull = true;
NCVEN.ReportParameters[i].Value = ALValorParametrosInternos[i];
}
NCVEN.ReportParameters[16].Value = 65;
NCVEN.ReportParameters[1].Value = "Producto no conforme";
NCVEN.ReportParameters[23].Value = 1; //Vencida
//Reporte de prueba Vigente
Telerik.Reporting.Report RepConsignacion = (Telerik.Reporting.Report)Activator.CreateInstance(instance2);
for (int i = 0; i <= ALValorParametrosConsignacion.Count - 1; i++)
{
RepConsignacion.ReportParameters[i].AllowNull = true;
RepConsignacion.ReportParameters[i].Value = ALValorParametrosConsignacion[i];
}
var reportBook = new ReportBook();
reportBook.Reports.Add(report1);
reportBook.Reports.Add(reportPXFVEN);
reportBook.Reports.Add(PruebaVIG);
reportBook.Reports.Add(PruebaVEN);
reportBook.Reports.Add(NCVIG);
reportBook.Reports.Add(NCVEN);
reportBook.Reports.Add(RepConsignacion);
reportBook.Reports[0].DocumentName = "PXF_VENCIDA";
reportBook.Reports[1].DocumentName = "PXF_VIGENTE";
reportBook.Reports[3].DocumentName = "PRUEBA VENCIDA";
reportBook.Reports[2].DocumentName = "PRUEBA VIGENTE";
reportBook.Reports[5].DocumentName = "NC VENCIDA";
reportBook.Reports[4].DocumentName = "NC VIGENTE";
reportBook.Reports[6].DocumentName = "Consignacion";
ReportProcessor reportProcessor = new ReportProcessor();
RenderingResult result = reportProcessor.RenderReport("XLS", reportBook, null);
string ruta = Server.MapPath("Reportes") + "\\" + ALValorParametrosConsignacion[2] + instance.Name + ".xls";
if (File.Exists(ruta))
{
File.Delete(ruta);
}
FileStream fs = new FileStream(ruta, FileMode.Create);
fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
fs.Flush();
fs.Close();
// RAM1.ResponseScripts.Add("startDownload('" + instance.Name + ".xls');");
RadAjaxManager1.ResponseScripts.Add("startDownload('" + ALValorParametrosConsignacion[2] + instance.Name + ".xls');");
//Telerik.Reporting.Report report1 = (Telerik.Reporting.Report)Activator.CreateInstance(instance);
//for (int i = 0; i <= ALValorParametrosInternos.Count - 1; i++)
//{
// report1.ReportParameters[i].AllowNull = true;
// report1.ReportParameters[i].Value = ALValorParametrosInternos[i];
//}
//ReportProcessor reportProcessor = new ReportProcessor();
//RenderingResult result = reportProcessor.RenderReport("XLS", report1, null);
//string ruta = Server.MapPath("Reportes") + "\\" + instance.Name + ".xls";
//if (File.Exists(ruta))
// File.Delete(ruta);
//FileStream fs = new FileStream(ruta, FileMode.Create);
//fs.Write(result.DocumentBytes, 0, result.DocumentBytes.Length);
//fs.Flush();
//fs.Close();
//RadAjaxManager1.ResponseScripts.Add("startDownload('" + instance.Name + ".xls');");
}
catch (Exception ex)
{
throw ex;
}
}