/// <summary>
/// btnCustomersLeveled_Click - Creates a OrdersLeveled report and sets
/// the data source for it.
/// </summary>
private void btnCustomersLeveled_Click(object sender, EventArgs e)
{
try
{
//OrdersLeveled rpt = new OrdersLeveled();
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.OrdersLeveled));
Data.XMLDataSource ds = rpt.DataSource as Data.XMLDataSource;
if (ds == null)
{
// Display the message when an error occurs.
MessageBox.Show(Properties.Resources.DataSourceError, this.Text);
return;
}
// Set the XML file name.
ds.FileURL = Properties.Resources.ConnectionString;
// Display the report.
ViewerForm frm = new ViewerForm();
frm.Show();
frm.LoadReport(rpt);
}
catch (ReportException ex)
{
MessageBox.Show(ex.ToString(), Text);
}
}
void LoadReport(ReportType reportType)
{
// Instantiate a new Invoice report
var report = new SectionReport();
report.LoadLayout(XmlReader.Create(Properties.Resources.Invoice));
report.MaxPages = 10;
// Set the connection string to the sample database.
((OleDBDataSource)report.DataSource).ConnectionString = Properties.Resources.ConnectionString;
switch (reportType)
{
case ReportType.CrossSectionControls:
cscViewer.LoadDocument(report);
break;
case ReportType.RepeatToFill:
((Detail)report.Sections["Detail"]).RepeatToFill = true;
repeatToFillViewer.LoadDocument(report);
break;
case ReportType.PrintAtBottom:
((GroupFooter)report.Sections["customerGroupFooter"]).PrintAtBottom = true;
printAtBottomViewer.LoadDocument(report);
break;
}
}
public void PdfExport(SectionReport report, string path)
{
using (var exporter = new PdfExport())
{
exporter.Export(report.Document, path);
}
}
public frmVOnePreviewForm(SectionReport report)
{
InitializeComponent();
var isCloudEdition = Convert.ToBoolean(System.Configuration.ConfigurationManager.AppSettings["IsCloudEdition"]);
Icon = (isCloudEdition) ? Properties.Resources.cloud_icon : Properties.Resources.app_icon;
Report = report;
if (Report != null &&
Report.Document != null &&
Report.Document.Printer != null)
{
Report.Document.Printer.EndPrint += (sender, e) => OutputHandler?.Invoke(this);
}
ShowSaveFileDialogHandler = ShowSaveFileDialogInner;
Load += frmVOnePreviewForm_Load;
rptViewer.Click += rptViewer_Click;
rptViewer.MouseDown += rptViewer_MouseDown;
rptViewer.PrintingSettings
= GrapeCity.Viewer.Common.PrintingSettings.ShowPrintDialog
| GrapeCity.Viewer.Common.PrintingSettings.ShowPrintProgressDialog
| GrapeCity.Viewer.Common.PrintingSettings.UsePrintingThread
| GrapeCity.Viewer.Common.PrintingSettings.UseStandardDialog;
}
public ReportViewer(SectionReport report)
{
InitializeComponent();
this.viewModel.Report = report;
DataContext = viewModel;
}
private void RunReport_DSRelations()
{
// ***** Sub report using the data set that contains the relationship *****
DataSet myJoinedDS = new DataSet();
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptDSRelationParent));
string cnnString = Properties.Resources.ConnectionString;
OleDbConnection cnn = new OleDbConnection(cnnString);
cnn.Open();
OleDbDataAdapter catAd = new OleDbDataAdapter("Select * from categories order by categoryname", cnn);
OleDbDataAdapter prodAd = new OleDbDataAdapter("Select * from products order by productname", cnn);
OleDbDataAdapter ODAd = new OleDbDataAdapter("Select * from [order details]", cnn);
//Add three DataTables in the DataSet (myJoinedDS)
catAd.Fill(myJoinedDS, "Categories");
prodAd.Fill(myJoinedDS, "Products");
ODAd.Fill(myJoinedDS, "OrderDetails");
cnn.Close();
//Sets the parent-child relationship between DataTable.
myJoinedDS.Relations.Add("CategoriesProducts", myJoinedDS.Tables["Categories"].Columns["CategoryID"], myJoinedDS.Tables["Products"].Columns["CategoryID"]);
myJoinedDS.Relations.Add("ProductsOrderDetails", myJoinedDS.Tables["Products"].Columns["ProductID"], myJoinedDS.Tables["OrderDetails"].Columns["ProductID"]);
rpt.DataSource = (myJoinedDS);
rpt.DataMember = "Categories";
arvMain.LoadDocument(rpt);
}
private void buttonRunReport_Click(object sender, EventArgs e)
{
SectionReport report = null;
// Select the report in the Viewer.
if (radioButtonProductListReport.Checked)
{
report = new ProductsReport();
}
else if (radioButtonCategoriesReport.Checked)
{
report = new CategoryReport();
}
// Apply stylesheet on the report.
string outputFolder = new FileInfo(GetType().Assembly.Location).DirectoryName + "\\";
string styleSheet = "";
if (radioButtonClassicStyle.Checked)
{
styleSheet = outputFolder + "Classic.reportstyle";
}
else if (radioButtonColoredStyle.Checked)
{
styleSheet = outputFolder + "Colored.reportstyle";
}
else if (_externalStyleSheet != "")
{
styleSheet = _externalStyleSheet;
}
if (styleSheet != "")
{
report.LoadStyles(styleSheet);
}
reportViewer.LoadDocument(report);
}
private void RunReport_UnboundDataSet()
{
// ***** To view the DataSet with multiple tables using sub-reports *****
// To generate dataset using "Customers" and "Orders" tables.
OleDbConnection nwindConn = new OleDbConnection(Properties.Resources.ConnectionString);
OleDbCommand selectCMD = new OleDbCommand("SELECT * FROM Customers", nwindConn);
selectCMD.CommandTimeout = 30;
OleDbCommand selectCMD2 = new OleDbCommand("SELECT * FROM Orders", nwindConn);
selectCMD2.CommandTimeout = 30;
OleDbDataAdapter custDA = new OleDbDataAdapter();
custDA.SelectCommand = selectCMD;
OleDbDataAdapter ordersDA = new OleDbDataAdapter();
ordersDA.SelectCommand = selectCMD2;
DataSet DS = new DataSet();
custDA.Fill(DS, "Customers");
ordersDA.Fill(DS, "Orders");
nwindConn.Close();
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptUnboundDSMain));
rpt.DataSource = DS;
rpt.DataMember = "Customers";
arvMain.LoadDocument(rpt);
}
/// <summary>
/// ShowReport - takes the supplied SectionReport object and loads it into
/// the PreviewForm for viewing.
/// </summary>
/// <param name="rpt">SectionReport object to run and display.</param>
private void ShowReport(SectionReport rpt)
{
// Change the mouse cursor to the wait cursor.
Cursor tmp = Cursor;
Cursor = Cursors.WaitCursor;
try
{
// Make the sure the connection string points to the correct file location.
OleDBDataSource ds = (OleDBDataSource)rpt.DataSource;
ds.ConnectionString = _connectString;
// Create a new instance of the preview form.
PreviewForm viewerForm = new PreviewForm(rpt.Document, this);
viewerForm.Show();
rpt.Run();
}
catch (ReportException ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
Cursor = tmp;
}
}
protected override object OnCreateReportHandler(string reportPath)
{
SectionReport rptOrders;
switch (reportPath)
{
case "Reports/BillingInvoice.rdlx":
case "Reports/Orders.rdlx":
PageReport rptPageRDL = new PageReport();
rptPageRDL.Load(new FileInfo(Server.MapPath(reportPath)));
rptPageRDL.Report.DataSources[0].ConnectionProperties.ConnectString = "data source=" + Server.MapPath("~/App_Data/NWind.mdb") + ";provider=Microsoft.Jet.OLEDB.4.0;";
return(rptPageRDL);
case "Reports/Invoice.rpx":
rptOrders = new SectionReport();
XmlTextReader xtr = new XmlTextReader(Server.MapPath(reportPath));
rptOrders.LoadLayout(xtr);
(rptOrders.DataSource as OleDBDataSource).ConnectionString = "data source=" + Server.MapPath("~/App_Data/NWind.mdb") + ";provider=Microsoft.Jet.OLEDB.4.0;";
return(rptOrders);
default:
return(base.OnCreateReportHandler(reportPath));
}
}
protected override object OnCreateReportHandler(string reportPath)
{
var data = reportPath.Split(';');
if (data.Length != 2)
{
return(base.OnCreateReportHandler(reportPath));
}
switch (data[0])
{
case "Section":
var sectionReport = new SectionReport();
sectionReport.LoadLayout(XmlReader.Create(Server.MapPath("~/Reports/OrderReport.rpx")));
sectionReport.DataSource = Repository.GetOrders(data[1]);
var xvalues = new List <string>();
var yvalues = new List <double>();
foreach (Order order in Repository.GetOrders(data[1]))
{
xvalues.Add(order.ShippedDate);
yvalues.Add((double)order.Freight);
}
((SectionReportModel.ChartControl)sectionReport.Sections["reportFooter1"].Controls[0]).Series[0].Points.DataBindXY(xvalues.ToArray(), yvalues.ToArray());
return(sectionReport);
case "Page":
var pageReport = new PageReport(new FileInfo(Server.MapPath("~/Reports/OrderDetailsReport.rdlx")));
pageReport.Document.LocateDataSource += delegate(object sender, LocateDataSourceEventArgs args)
{
args.Data = Repository.GetDetails(data[1]);
};
return(pageReport);
}
return(base.OnCreateReportHandler(reportPath));
}
public void ViewReport(SectionReport ar)
{
reportType = ar.GetType().ToString();
rprt = ar;
viewer1.Document = rprt.Document;
rprt.Run();
}
public void ViewDrawingLogWithExcel(SectionReport ar)
{
reportType = ar.GetType().ToString();
rprt = ar;
viewer1.Document = rprt.Document;
rprt.Run();
}
/// <summary>
/// Handles the hyperlink sent from the viewer object.
/// </summary>
private void arvMain_HyperLink(object sender, GrapeCity.ActiveReports.Viewer.Win.HyperLinkEventArgs e)
{
e.Handled = true;
string hyperlink = e.HyperLink.Split(':')[1];
string report = e.HyperLink.Split(':')[0];
if (report == "DrillThrough1")
{
// Click on customer ID to open the drill through for that customer.
var rpt2 = new SectionReport();
rpt2.LoadLayout(XmlReader.Create(Properties.Resources.DrillThrough1));
ViewerMain frm2 = new ViewerMain(false);
rpt2.Parameters["customerID"].Value = hyperlink;
frm2.arvMain.LoadDocument(rpt2);
frm2.ShowDialog(this);
}
else if (report == "DrillThrough2")
{
// Click order number to open the order details
var rpt3 = new SectionReport();
rpt3.LoadLayout(XmlReader.Create(Properties.Resources.DrillThrough2));
ViewerMain frm3 = new ViewerMain(false);
rpt3.Parameters["orderID"].Value = hyperlink;
frm3.arvMain.LoadDocument(rpt3);
frm3.ShowDialog(this);
}
}
public static void Print <T>(SectionReport report, IList <T> data) where T : new()
{
report.DataSource = data;
var viewer = new ReportViewer(report);
viewer.ShowDialog();
}
private void RunReport_Bookmark()
{
// ***** Bookmark in sub-report *****
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptBookmarkMain));
arvMain.LoadDocument(rpt);
}
public void ViewReport(SectionReport ar)
{
rprt = ar;
reportType = ar.GetType().ToString(); ////******************Added and Commented for M-File button*****11/18
//viewer1.Document = rprt.Document;
//rprt.Run();
//Cursor.Current = Cursors.Default;
}
private void exportButton_Click(object sender, EventArgs e)
{
var reportName = (string)reportsNames.SelectedItem;
var exportType = (string)exportTypes.SelectedItem;
IDocumentExportEx documentExportEx = null;
var report = new SectionReport();
System.Xml.XmlTextReader xtr = new System.Xml.XmlTextReader(@"..\..\..\..\Reports\" + reportName);
report.LoadLayout(xtr);
report.Run();
var exporTypeLower = exportType.ToLower();
switch (exporTypeLower)
{
case _pdf:
documentExportEx = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport();
break;
case _xlsx:
documentExportEx = new GrapeCity.ActiveReports.Export.Excel.Section.XlsExport()
{
FileFormat = GrapeCity.ActiveReports.Export.Excel.Section.FileFormat.Xlsx
};
break;
case _rtf:
documentExportEx = new GrapeCity.ActiveReports.Export.Word.Section.RtfExport();
break;
case _mht:
documentExportEx = new GrapeCity.ActiveReports.Export.Html.Section.HtmlExport();
break;
case _csv:
documentExportEx = new GrapeCity.ActiveReports.Export.Xml.Section.TextExport();
break;
}
var fileName = Path.GetFileNameWithoutExtension(reportName);
var saveFileDialog = new SaveFileDialog()
{
FileName = fileName + GetSaveDialogExtension(exporTypeLower),
Filter = GetSaveDialogFilter(exporTypeLower)
};
if (saveFileDialog.ShowDialog() != DialogResult.OK)
{
return;
}
exportButton.Enabled = false;
using (var stream = new FileStream(Path.Combine(saveFileDialog.FileName), FileMode.Create))
documentExportEx.Export(report.Document, stream);
exportButton.Enabled = true;
}
private void Button_Click(object sender, EventArgs e)
{
var rpt = new SectionReport();
var reportPath = "..\\..\\" + (string)comboBox1.SelectedItem;
rpt.LoadLayout(XmlReader.Create(reportPath));
rpt.PrintWidth = 6.5F;
arvMain.LoadDocument(rpt);
}
private void RunReport_Hierarchical()
{
// *****Hierarchical structure of sub-reports *****
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptHierarchicalMain));
arvMain.LoadDocument(rpt);
}
private void ActiveReportsWindow_OnLoaded(object sender, RoutedEventArgs e)
{
_sectionReport = new SectionReport {
DataSource = DataTable
};
_sectionReport.Document.Printer.PrinterName = "";
_sectionReport.PageSettings.Margins.Left = 0.1f;
_sectionReport.PageSettings.Margins.Right = 0.1f;
_sectionReport.PrintWidth = 15F;
_sectionReport.Sections.Add(SectionType.ReportHeader, "ReportHeader");
_sectionReport.Sections.Add(SectionType.Detail, "Detail");
_sectionReport.Sections.Add(SectionType.ReportFooter, "ReportFooter");
var section1 = _sectionReport.Sections[1];
section1.CanGrow = true;
section1.CanShrink = true;
float locationX = 0;
foreach (DataColumn dataSetColumn in DataTable.Columns)
{
var labelHeader = new Label
{
Text = dataSetColumn.ColumnName,
Alignment = GrapeCity.ActiveReports.Drawing.TextAlignment.Left,
Location = new PointF(locationX, 0.0F),
ShrinkToFit = false,
MinCondenseRate = 100,
BackColor = Color.Gainsboro,
Width = 2
};
_sectionReport.Sections[0].Controls.Add(labelHeader);
var ctl = new TextBox
{
Name = dataSetColumn.ColumnName,
Text = dataSetColumn.ColumnName,
DataField = dataSetColumn.ColumnName,
Location = new PointF(locationX, 0.05F),
ShrinkToFit = false,
WrapMode = WrapMode.NoWrap,
CanShrink = false,
};
ctl.Border.BottomStyle = BorderLineStyle.Dash;
_sectionReport.Sections[1].Controls.Add(ctl);
locationX += ctl.Width;
}
ReportViewer.LoadDocument(_sectionReport);
}
/// <summary>
/// ViewerForm_Load - Handles initial form setup.
/// </summary>
private void ViewerForm_Load(object sender, EventArgs e)
{
if (_loadMainReport)
{
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.DrillThroughMain));
arvMain.LoadDocument(rpt);
}
}
/// <summary>
/// btnArray_Click - Illustrates using a Array as a data source
/// </summary>
private void btnArray_Click(object sender, System.EventArgs e)
{
//Create the report
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.UnboundDAInvoice));
//Run and view the report
arvMain.LoadDocument(rpt);
}
private void RunReport_Simple()
{
// ***** Simple sub-report *****
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptSimpleMain));
arvMain.LoadDocument(rpt);
}
// Define a structure for LINQtoObject.
private void ViewerForm_Load(object sender, EventArgs e)
{
// To generate a report.
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create("..\\..\\rptLINQtoObject.rpx"));
// To run the report.
arvMain.LoadDocument(rpt);
}
private void RunReport_Nested()
{
// ***** Nested sub-reports *****
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptNestedParent));
arvMain.LoadDocument(rpt);
}
private void RunReport_Parameter()
{
// ***** Use a parameter in the subreport *****
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptParamMain));
arvMain.LoadDocument(rpt);
}
private void RunReport_MasterSubreport()
{
// ***** Master-detail report contains a subreport *****
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create(Properties.Resources.rptMasterMain));
arvMain.LoadDocument(rpt);
}
private void ReportForm_Load(object sender, EventArgs e)
{
rpt = new SectionReport();
//Adding Page Header/Footer sections
rpt.Sections.InsertPageHF();
rpt.Sections[0].BackColor = Color.LightGray;
//Adding Detail section
rpt.Sections.Insert(1, new Detail());
rpt.Sections[1].BackColor = Color.PeachPuff;
rpt.Sections[1].Height = 0.5f;
//Adding label to display first column's name
GrapeCity.ActiveReports.SectionReportModel.Label lblCategoryID = new GrapeCity.ActiveReports.SectionReportModel.Label();
lblCategoryID.Location = new PointF(0, 0.05F);
lblCategoryID.Text = "Tên món ăn";
lblCategoryID.Alignment = GrapeCity.ActiveReports.Document.Section.TextAlignment.Center;
lblCategoryID.Font = new Font("Arial", 10, FontStyle.Bold);
rpt.Sections[0].Controls.Add(lblCategoryID);
//Adding label to display second column's name
GrapeCity.ActiveReports.SectionReportModel.Label lblCategoryName = new GrapeCity.ActiveReports.SectionReportModel.Label();
lblCategoryName.Location = new PointF(1.459f, 0.05f);
lblCategoryName.Size = new SizeF(1.094f, 0.2f);
lblCategoryName.Text = "Giá";
lblCategoryName.Font = new Font("Arial", 10, FontStyle.Bold);
rpt.Sections[0].Controls.Add(lblCategoryName);
// Adding Textbox to display first column's records
GrapeCity.ActiveReports.SectionReportModel.TextBox txtCategoryID = new GrapeCity.ActiveReports.SectionReportModel.TextBox();
txtCategoryID.Location = new PointF(0, 0);
txtCategoryID.Alignment = GrapeCity.ActiveReports.Document.Section.TextAlignment.Center;
rpt.Sections[1].Controls.Add(txtCategoryID);
//Adding Textbox to display second column's records
GrapeCity.ActiveReports.SectionReportModel.TextBox txtCategoryName = new GrapeCity.ActiveReports.SectionReportModel.TextBox();
txtCategoryName.Location = new PointF(1.459f, 0);
rpt.Sections[1].Controls.Add(txtCategoryName);
// Setting report's data source
rpt.DataSource = DataProvider.Instance.ExecuteQuery("select * from dbo.menu where created ='" + _dateReport + "' ");
// Assigning DataField properties of controls in the detail section
txtCategoryID.DataField = "name";
txtCategoryName.DataField = "price";
rpt.Run();
this.viewer1.Document = rpt.Document;
}
/// <summary>
/// btnGenerateReport_Click - Opens a new viewer form to display the
/// report bound to the DataLayer object
/// </summary>
private void btnGenerateReport_Click(object sender, System.EventArgs e)
{
// Create new report object
var rpt = new SectionReport();
rpt.LoadLayout(XmlReader.Create("IlistReportSample.rpx"));
rpt.DataSource = _productCollection;
// Pass the document to show in the viewer form
ViewerForm frmViewer = new ViewerForm();
frmViewer.Show();
frmViewer.LoadDocument(rpt);
}
public ViewerForm(SectionReport report)
{
InitializeComponent();
_report = report;
}
