【下载FastReport.Net最新版本】
FastReport.Net为其报表设计器提供了自定义功能,在本文中,将介绍如何使用Active Query Builder替换内置SQL查询编辑器。- 首先,下载最新版本的.Net Active Query Builder,借助下载的安装程序安装库。
- 创建WindowsForms应用程序,项目中添加对Active Query Builder库的引用。需要以下library(库),在已安装程序的文件夹中找到它们(C:\ Program Files \ ActiveDBSoft \ Active Query Builder 3 .NET \ assemblies):
ActiveQueryBuilder.AdvantageMetadataProvider; ActiveQueryBuilder.Core; ActiveQueryBuilder.DB2MetadataProvider; ActiveQueryBuilder.FirebirdMetadataProvider; ActiveQueryBuilder.MSSQLCEMetadataProvider; ActiveQueryBuilder.InformixMetadataProvider; ActiveQueryBuilder.MSSQLMetadataProvider; ActiveQueryBuilder.MySQLMetadataProvider; ActiveQueryBuilder.ODBCMetadataProvider; ActiveQueryBuilder.OLEDBMetadataProvider; ActiveQueryBuilder.OracleMetadataProvider; ActiveQueryBuilder.OracleNativeMetadataProvider; ActiveQueryBuilder.PostgreSQLMetadataProvider; ActiveQueryBuilder.SQLiteMetadataProvider; ActiveQueryBuilder.SybaseMetadataProvider; ActiveQueryBuilder.UniversalMetadataProvider; ActiveQueryBuilder.View; ActiveQueryBuilder.View.WinForms; ActiveQueryBuilder.View.WPF; ActiveQueryBuilder.VistaDB5MetadataProvider;
FastReport; FastReport.Bars; FastReport.Editor;现在将文件添加到项目中,它是一个使用ActiveQueryBuilder的插件。位置:C:\ Program Files(x86)\ FastReports \ FastReport.Net \ Extras \ Misc \ ActiveQueryBuilder \ ActiveQBForm.cs。要执行此操作,请在解决方案资源管理器中右键单击项目名称,然后选择Add——>Existing Item…。由于有演示应用程序,因此表单只包含一个按钮:

using FastReport.Forms; using FastReport.Design; using FastReport; … private void button1_Click(object sender, EventArgs e) { Report report = new Report(); FastReport.Utils.Config.DesignerSettings.CustomQueryBuilder += new FastReport.Design.CustomQueryBuilderEventHandler(DesignerSettings_CustomQueryBuilder); report.Design(); } private void DesignerSettings_CustomQueryBuilder(object sender, CustomQueryBuilderEventArgs e) { using (ActiveQBForm form = new ActiveQBForm()) { form.Connection = e.Connection; form.SQL = e.SQL; if (form.ShowDialog() == DialogResult.OK) e.SQL = form.SQL; } }单击该按钮时,将创建一个报表对象,然后覆盖报表构建器调用方,并导向report designer。下面,为报表生成器创建了一个自定义报表生成器,只需调用先前添加到项目中的ActiveQBForm对象,现在启动应用程序,然后查看报表设计器。如果要编辑现有报表,则在创建报表对象后,需要将报表加载到其中:
report.Load("С:/Program Files (x86)/FastReports/FastReport.Net/Demos/Reports/Image.frx");现在使用添加图标将数据源添加到报表中:










本站文章除注明转载外,均为本站原创或翻译
欢迎任何形式的转载,但请务必注明出处,尊重他人劳动成果
转载请注明:文章转载自:FastReport控件中文网 [https://www.fastreportcn.com/]
本文地址:https://www.fastreportcn.com/post/2190.html
欢迎任何形式的转载,但请务必注明出处,尊重他人劳动成果
转载请注明:文章转载自:FastReport控件中文网 [https://www.fastreportcn.com/]
本文地址:https://www.fastreportcn.com/post/2190.html