ActiveReports 19 User Guide
Demos
Blog
Support
Pricing
Download
ActiveReports 19 .NET Edition
MESCIUS.ActiveReports.QueryDesigner Assembly
/ GrapeCity.ActiveReports.QueryDesigner.Implementation.SqlParser Namespace
Collapse All
Expand All
In This Topic
Inheritance Hierarchy
See Also
Introduction
Overview
Product Requirements
What's New
Get Started
Report Readers
Desktop Viewers
Windows Forms Viewer
Windows Presentation Foundation Viewer
Print
Export
Print Presets
Annotations
Web Viewers
Export
Report Authors
Standalone Designer
Quick Start
WebDesigner
Quick Start
Expressions
Custom Parameters View
Report Types
RDLX Report
RDLX Dashboard Report
Page Report
Section Report
Report Controls
Report Controls in Page/RDLX Report
BandedList
Barcode
Bullet
Chart
Chart Wizard
Chart Smart Panels and Adorners
Plots
Column and Bar Charts
Create Clustered Column Chart
Create Clustered Bar Chart
Area Chart
Create Clustered Area Chart
Create Stacked Area Chart
Create Stacked Percentage Area Chart
Line Chart
Create Single Line Chart
Create Multiple Line Chart
Pie and Doughnut Charts
Create Doughnut Chart
Create Pie Chart
Scatter and Bubble Charts
Create Bubble Chart
Create Scatter Chart
Radar Scatter and Radar Bubble Charts
Create Radar Bubble Chart
Create Multi-Category Radar Scatter Chart
Radar Line Chart
Create Radar Line Chart with Multiple Lines
Radar Area Chart
Create Radar Area Chart with Multiple Values
Spiral Chart
Create Simple Spiral Chart
Create Stacked Spiral Chart
Create Stacked Percentage Spiral Chart
Polar Chart
Create Simple Polar Chart
Create Clustered Polar Chart
Create Stacked Polar Chart
Create Stacked Percentage Polar Chart
Gantt Chart
Create Gantt Chart
Funnel and Pyramid Charts
Create Funnel Chart
Create Pyramid Chart
Candlestick Chart
Create Candlestick Chart
High Low Close Chart
Create High Low Close Chart
High Low Open Close Chart
Create High Low Open Close Chart
Range Charts
Create Range Bar Chart
Gauge Chart
Create Gauge Chart
Axes
Legends
Customize Chart Appearance
Trendlines
Classic Chart
CheckBox
Container
ContentPlaceHolder (RDLX Master Report)
FormattedText
Image
InputField
Line
List
Map
Add a Title to the Map
Add a Legend to the Map
Set the Distance Scale on a Map
Set the Color Scale on a Map
Add Data to a Map
Modify the Appearance of the Viewport
Use Map Layers
Polygon Layer
Point Layer
Line Layer
Tile Layer
Use Color Rule, Marker Rule, and Size Rule
Matrix
Overflow Placeholder (Page report only)
Shape
Sparkline
Subreport
Table
Table of Contents
Tablix
TextBox
Report Controls in Section Report
Barcode
Chart
Area Chart
Bar Chart
Line Chart
Pie and Doughnut Charts
Financial Chart
Point and Bubble Charts
CheckBox
CrossSectionBox
CrossSectionLine
InputFieldCheckBox
InputFieldText
Label
Line
OleObject
Picture
ReportInfo
RichTextBox
Shape
SubReport
TextBox
Report Wizard
Selecting Report Type
Configuring Page Settings
Configuring Data Source
Database Data Source
Configuring File Data Source
Configuring Web API Data Source
Configuring Programmatic Data Source
Configuring Data Queries
Configuring Database Queries
Configuring File Queries
Configuring CSV File Queries
Configuring JSON File Queries
Configuring XML File Queries
Configuring Excel File Queries
Configuring Web API Queries
Programmatic Queries
Configuring Report Controls
Configuring Table
Configuring Tablix
Configuring Chart
Data Binding
Data Binding in Page/RDLX Reports
Connect to a Data Source
MS SQL Server
MySQL
PostgreSQL
SQLite
JSON
XML
CSV
Excel
JSON API
Microsoft ODBC Provider
Connect to PostgreSQL Database
Microsoft OLEDB Provider
Add Dataset
Query Builder in JSON and XML Providers
Query Builder in Microsoft SQL Client and OLEDB Providers
Stored Procedure as Dataset
Dynamic JSON Connection String
Nested Datasets (JSON and XML)
Work with Local Shared Data Sources
Bind Nested Data Regions to Different Datasets
Dataset/Object Provider
Data Binding in Section Reports
Connect to a Data Source
OLEDB Provider
ODBC Provider
SQL Provider
XML Provider
CSV Provider
JSON Provider
Unbound Provider
Design Reports
Design Page/RDLX Reports
Layout
Set Page Size, Margins, and Orientation in Page Reports
Skip Page Generation in Page Reports
Set Page Layout in Z- or N-Order
Manage Blank Rows in a Table Data Region in Page Reports
Hide or Show Sections in RDLX and RDLX Dashboard Reports
Keep Groups Together in Data Regions
Manage Page Breaks in Data Regions
Report Dialog
Master Report (RDLX Report)
Layers
Expressions
LookupSet Function in Data Regions
Data Visualizers
Icon Set
Range Bar
Range Bar Progress
Data Bar
Gradient
Hatch
Color Scale 2
Color Scale 3
Filters
Groups
Interactivity
Parameters
Multi-Value Parameter
Cascading Parameter
Hidden Parameter
Actionable Parameters
Drill-Down Links
Bookmarks
Hyperlinks
Drill-Through Links
Sort Data
Document Map
Scripts
Report Appearance
Themes
Styles
Tutorials: Report Controls in Page/RDLX Reports
TableofContent Control for Navigation
BandedList Data Region for Free-form Bands
Bullet Control to Visualize Sales against Target
CheckBox Control
OverflowPlaceholder Control for Columnar Reports
InputField Control for Editable PDFs
Line Control for Freehand Forms
List Control for Hierarchical Relationships
Table Data Region for a Tabular Report
Shape Control for Enhanced Report Appearance
Image Control
Container Control for Enhanced Report Appearance
FormattedText Control for Mail Merge
Subreport Control for a Master-Detail Report
Sparkline Control
Tablix Data Region
TextBox Control
Map Data Region
Tutorials: Page/RDLX Report Scenarios
Create RDLX Dashboard Report
Create Multi-Column Layout (or Columnar report)
Create Address Labels in Page Report
Create Top N Report
Create a Red Negatives or a Green Bar Report
Apply Theme at Runtime Using Dynamic Expression
Add Page Numbering
Show Row Number in Tablix and Table
Link Multiple Datasets to Same Data Region
Localize RDLX Report Content
Design Section Reports
Layout
Report Settings Dialog
Aggregates Calculations
Display Page Numbers and Report Dates
Date, Time, and Number Formatting
Interactivity
Parameters
Bookmarks
Hyperlinks
Scripts
Report Events
Tutorials: Report Controls in Section Reports
InputFieldCheckBox Control
InputFieldText Control
Picture Control
TextBox Control
Tutorials: Section Report Scenarios
Create Top N Report
Create a Summary Report
Create Green Bar Report
Create Address Labels in Section Report
DevOps
ActiveReports Editions
Compare ActiveReports Editions
Open Source Software
Copyright Notice
End User License Agreement
Install ActiveReports
Available Packages
Manage ActiveReports Dependencies
Redistributable Files
ActiveReports Features
Report Types
ActiveReports Components
Designers
Viewers
Theme Editor
Import Wizard
Exports
Report Import and Migration
MS Access
Crystal
Excel
MS SSRS RDLX
Migration between Supported Report Types
Azure and Medium Trust
Configuration and Customization
Configure ActiveReports using Config file
Configure PDF Font Settings for Section report in GDI
Customization Options
Localization
.NET Localization
Js Components Localization
WebDesigner Localization
Js Viewer Localization
WebViewer Localization
Blazor Localization
Blazor WebDesigner Localization
Blazor Viewer Localization
Cultures
Deployment
Deploy Windows Application
Deploy Web Application
Deploy Applications in Non-Windows Environment
Mac
Linux
Deploy Applications to Cloud Services
Azure App Service
Deploy on Azure using a Windows Environment
Deploy on Azure using a Linux Environment
Amazon Web Services
Deploy on AWS using a Windows Environment
Deploy on AWS using a Linux Environment
Google Cloud
Deploy on Google Cloud using a Windows Environment
Deploy on Google Cloud using a Linux Environment
Deploy Application Using Docker
Section 508 Compliance
Developers
Quick Start
Breaking Changes
ActiveReports Version Compatibility and Migration
Compatibility of Visual Studio Integrated Designers
Upgrade Reports and References
ActiveReports File Converter
Migrate to ActiveReports 19
Migrate from ActiveReports 2 COM
Reference Migration
Web Viewer Migration
ActiveX Viewer Migration
Migrate to .NET Core
License ActiveReports
License Types
Upgrading License from Trial to Purchase
Licensing a Developer Machine
Licensing a Project
Licensing Compiled Code
Licensing Build Agents/Pipelines using Command Line
Offline Licensing with Command Line
Submitting a Reactivation Request
Fixing Licensing Errors
Contacting Support
Configure ActiveReports Using Code
Work with Reports using Code
Visual Studio Integrated Designer
Design View
Report Menu
Designer Tabs
Designer Buttons
Toolbar
Toolbox
Page Tabs
Report Explorer
Properties Panel
Rulers
Scroll Bars
Snap Lines
Zoom Support
Page/RDLX Report
Create a Report or Load an Existing Report
Bind a Page/RDLX Report to Data
Bind Page/RDLX Report to Entity Framework and Other Data Providers
Bind Page/RDLX Report to SQL, OLEDB, and ODBC Data Providers
Bind Page/RDLX Report to Custom Data Providers (Oracle, PostgreSQL, SQLite)
Bind Page/RDLX Report to CSV, JSON, and XML Data
Nested Datasets
Bind Page/RDLX Report at Run Time
Use Dynamic Connection String in Data Source
Save Page/RDLX Report
Merge Multiple Reports
Add Code to Layouts Using Script
Create a Custom Report Item
Apply Styles through Code
Section Report
Create a Report or Load an Existing Report
Bind a Section Report to Data
Bind a Section Report to Data Source at Run Time
Bind Data Set and Unbound Data to Section Report at Run Time
Save Section Reports
Change Ruler Measurements
Modify Printer Settings
Insert or Add Report Pages
Save and Load RDF Files
Add and Save Annotations
Work with Subreports
Draw on the Canvas of Rendered Report
Work with Code-based Section Reports
Inherit a Report Template
Design Code-based Section Reports in .NET Core
Load an RTF or HTML File in RichTextBox at Runtime
Use Custom Controls on Reports
Create Custom Chart Control
Add Code to Layouts Using Script
Subreport in Section Reports
Embed Subreports
Subreports with XML Data
Subreports with JSON Data
Subreports with Run-Time Data Sources
Create Mail Merge with RichTextBox
Overlaying in Reports (Letterhead)
Optimize Section Reports
Custom Properties in Chart
Report Parts
Create Designer and Viewer Applications
.NET Viewer Application
WPF Viewer
Load Reports
Customize the WPF Viewer
Windows Forms Viewer
Load Reports
Customize the WinForms Viewer Control
Web Viewer and Web Designer Middlewares
Js Viewer ASP.NET Core Middleware
WebDesigner ASP.NET Middleware
Js Viewer Application
ASP.NET MVC Core Integration
Integration to Angular Application
Integration to React Application
Integration to VueJS Application
Load Reports
Switch Between Render Formats
Update Security Token in Report Service
Caching Reports
Prevent Cross-Site Scripting Attacks
Customize UI
Customize Page View
Animation
View Reports from Different Domains using CORS
Predefined Export Settings
Js Viewer API
ASP.NET WebViewer Application
Customizing the WebViewer UI
Customize Export Settings
Blazor Viewer Application
Progressive Web Application
UI Customization
Blazor Viewer API
WebDesigner Application
ASP.NET MVC Core Integration
Integration to Angular Application
Integration to React Application
Integration to VueJS Application
Load Reports
Configure and Use Shared Data Sources
Save Reports
Preview Reports
Update Security Token in Designer Service
WebDesigner API
Blazor WebDesigner Application
Blazor Server Application
Blazor Web Assembly
Configure and Use Shared Data Sources
Configure Preview
Blazor WebDesigner API
End User Report Designer in WinForms Application
Create Basic End User Report Designer
Set High DPI Support
Use End-User Report Designer API
Work with a Report
Customize the Design View
Manage the Report Explorer
Customize the Toolbox
Work with Report Parts
Themes in WebDesigner and Js Viewer Components
Role Based Authorization with JWT
Extensibility in ActiveReports
Fonts Customization
Resources Customization
Map Tile Provider Customization
Data Provider Customization
External Customizations in ActiveReports
Export Reports
Export Page/RDLX Reports
HTML Export
PDF Export
ZUGFeRD/Factur-X Invoices
Image Export
XML Export
Excel Export
Word Export
CSV Export
JSON Export
Excel Data Export
Text Print Export
Export Section Reports
HTML Export
PDF Export
Text Export
RTF Export
Excel Export
TIFF Export
Set PDF Print Presets
Manage Asynchronous Report Rendering
Print Reports
Print using Print Methods
Print Reports on a Single Page
Print in Js Viewer
Plugins Development
Samples
Samples
Advanced
Page and RDLX Reports
Calendar
Custom Chart
Custom Data Provider
Custom PDF Export
Custom Resource Locator
Custom Tile Provider
OData Data Source
Oracle Data Provider
Section Report
Custom Drill Through
API
Page and RDLX Reports
Create Report
Digital Signature Pro
Export
Font Resolver
Layers
Report Wizard
Style Sheets
Section Report
Charting
Cross Section Controls
Cross Tab Report
Custom Annotation
Digital Signature Pro
Export
Inheritance
Print Multiple Pages per Sheet
Style Sheets
Sub Report
Summary
Data Binding
Page and RDLX Reports
CSV Data Source
DataSet DataSource
Json Data Source
Object Data Source
OleDb Data Source
Xml Data Source
OData Data Source
Section Report
Bound Data
IList Binding
LINQ
Unbound Data
XML
Designer Pro
Map
End User Designer
Table of Contents
Reports Gallery
Desktop
Win Viewer
WPF Viewer
Web
Custom Preview
Web Samples
WebDesigner Samples
Blazor Designer
WebDesigner MVC
WebDesigner MVC(Core)
WebDesigner Angular(Core)
WebDesigner Blazor
WebDesigner Custom Data Providers
WebDesigner Custom Store
WebDesigner Custom
WebDesigner Blazor Custom
WebDesigner Custom Shared Data Sources
WebDesigner Report Parts
JSViewer Samples
Blazor Viewer
JSViewer Angular(Core)
JSViewer CORS
JSViewer CORS(Core)
JSViewer MVC
JSViewer MVC(Core)
JSViewer React(Core)
JSViewer React(Hooks)
JSViewer Vue(Core)
WebViewer ASP.NET
Class Library
MESCIUS.ActiveReports Assembly
MESCIUS.ActiveReports.Aspnet.Designer Assembly
MESCIUS.ActiveReports.Aspnet.Viewer Assembly
MESCIUS.ActiveReports.Aspnetcore.Designer Assembly
MESCIUS.ActiveReports.Aspnetcore.Viewer Assembly
MESCIUS.ActiveReports.Blazor.Designer Assembly
MESCIUS.ActiveReports.Blazor.Viewer Assembly
MESCIUS.ActiveReports.Chart Assembly
MESCIUS.ActiveReports.Core.Data.DataEngine Assembly
MESCIUS.ActiveReports.Core.Data.ExpressionInfo Assembly
MESCIUS.ActiveReports.Core.Data.VBFunctionLib Assembly
MESCIUS.ActiveReports.Core.Document Assembly
MESCIUS.ActiveReports.Core.Document.Drawing.Gdi Assembly
MESCIUS.ActiveReports.Core.Rdl Assembly
MESCIUS.ActiveReports.Core.Rendering Assembly
MESCIUS.ActiveReports.Design.Win Assembly
MESCIUS.ActiveReports.Export.Excel Assembly
MESCIUS.ActiveReports.Export.Html Assembly
MESCIUS.ActiveReports.Export.Image Assembly
MESCIUS.ActiveReports.Export.Pdf Assembly
MESCIUS.ActiveReports.Export.Rdf Assembly
MESCIUS.ActiveReports.Export.Word Assembly
MESCIUS.ActiveReports.Export.Xml Assembly
MESCIUS.ActiveReports.QueryDesigner Assembly
MESCIUS.ActiveReports.SpreadBuilder Assembly
MESCIUS.ActiveReports.Viewer.Common Assembly
MESCIUS.ActiveReports.Viewer.Win Assembly
MESCIUS.ActiveReports.Viewer.Wpf Assembly
MESCIUS.ActiveReports.Web Assembly
MESCIUS.ActiveReports.Web.Viewer Assembly
MESCIUS.ActiveReports.Win Assembly
Troubleshooting
GrapeCity.ActiveReports.QueryDesigner.Implementation.SqlParser Namespace Inheritance Hierarchy
In This Topic
Inheritance Hierarchy
See Also
Inheritance Hierarchy
System.Object
GrapeCity.ActiveReports.QueryDesigner.Implementation.SqlParser.SqlDialect
See Also
Reference
MESCIUS.ActiveReports.QueryDesigner Assembly
