1、常用属性及方法
//常用属性
CrystalReportViewer1.HasToggleGroupTreeButton = true;//显示或隐藏工具栏上组树按钮
CrystalReportViewer1.HasExportButton = true;//显示或隐藏工具栏上导出按钮
CrystalReportViewer1.HasPrintButton = true;//显示或隐藏工具栏上打印按钮
CrystalReportViewer1.HasViewList = true;//显示或隐藏工具栏上视图列表(主报表)
CrystalReportViewer1.HasDrillUpButton = true;//获取或设置浅化按钮可见性(向上)
CrystalReportViewer1.HasPageNavigationButtons = true;//显示或隐藏工具栏上导航按钮
CrystalReportViewer1.HasGotoPageButton = true;//显示或隐藏工具栏上跳转按钮
CrystalReportViewer1.HasSearchButton = true;//显示或隐藏工具栏上搜索按钮
CrystalReportViewer1.HasZoomFactorList = true;//显示或隐藏工具栏上缩放按钮
CrystalReportViewer1.HasCrystalLogo = true;//显示或隐藏工具栏上LOGO
CrystalReportViewer1.SelectionFormula = "{Customer.Last Year's Sales} > 11000.00 " + "AND Mid({Customer.Customer Name}, 1, 1) = \"A\"";//筛选公式
CrystalReportViewer1.DisplayToolbar = true;//显示或隐藏工具栏
CrystalReportViewer1.DisplayGroupTree = true;//显示或隐藏组树
CrystalReportViewer1.DisplayPage = true;//显示或隐藏页面视图
CrystalReportViewer1.SeparatePages = true;//获取或设置报表页是分开还是连接?
CrystalReportViewer1.BorderWidth = Convert.ToInt32("borderWidth");//设置边框宽度
//常用方法
CrystalReportViewer1.ShowNthPage(Convert.ToInt32("pageNumber"));//跳转页
CrystalReportViewer1.Zoom(Convert.ToInt32("zoomFactor"));//缩放
2、登陆验证
private void ConfigureCrystalReports()
{
ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.ServerName = ".";
connectionInfo.DatabaseName = "Northwind";
connectionInfo.UserID = "sa";
connectionInfo.Password = "";
string reportPath = Server.MapPath("NorthwindCustomers.rpt");
crystalReportViewer.ReportSource = reportPath;
SetDBLogonForReport(connectionInfo);
}
private void Page_Init(object sender, EventArgs e)
{
ConfigureCrystalReports();
}
private void SetDBLogonForReport(ConnectionInfo connectionInfo)
{
TableLogOnInfos tableLogOnInfos = crystalReportViewer.LogOnInfo;
foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
{
tableLogOnInfo.ConnectionInfo = connectionInfo;
}
}