Introduction
Reports
Dashboards
Web Dashboard - Designer Mode
Creating a Dashboard
Providing Data
Create a New Data Source
Connect to an Existing Data Source
Manage Data Sources
Working with SQL Data Sources
Manage SQL Queries
Dashboard Data Source Wizard
Query Builder
Filter Queries
Pass Query Parameters
Stored Procedures
Preview Data
Filter Data Sources
Calculated Fields
Adding Dashboard Items
Binding Dashboard Items to Data
Binding Dashboard Items to Data in the Web Dashboard
Hidden Data Items
Binding Dashboard Items to Data in OLAP Mode
Designing Dashboard Items
Chart
Providing Data
Series
Panes
Interactivity
Legend
Axes
Orientation
Scatter Chart
Providing Data
Interactivity
Legend
Axes
Orientation
Labels
Grid
Providing Data
Columns
Interactivity
Conditional Formatting
Totals
Layout
Pies
Providing Data
Interactivity
Layout
Labels
Style
Cards
Providing Data
Layout
Delta
Sparkline
Formatting
Interactivity
Cards Arrangement
Gauges
Providing Data
Delta
Gauge Scale
Interactivity
Layout
Style
Pivot
Providing Data
Interactivity
Conditional Formatting
Layout
Expanded State
Choropleth Map
Providing Maps
Providing Data
Delta
Map Navigation
Interactivity
Labels
Legend
Geo Point Maps
Map Types Overview
Providing Maps
Geo Point Map
Providing Data
Bubble Map
Providing Data
Legends
Pie Map
Providing Data
Pie Options
Coloring
Legends
Clustering
Map Navigation
Interactivity
Labels
Range Filter
Providing Data
Series
Interactivity
Predefined Periods
Images
Image Overview
Providing Images
Interactivity
Image Settings
Text Box
Treemap
Providing Data
Interactivity
Layout
Grouping
Coloring
Labels
Filter Elements
Filter Elements Overview
Providing Data
Interactivity
Dashboard Item Group
Data Shaping
Summarization
Grouping
Sorting
Filtering
Top N
Formatting Data
Interactivity
Master Filtering
Drill-Down
Appearance Customization
Conditional Formatting
Coloring
Data Analysis
Aggregations
Calculations
Dashboard Parameters
Creating Parameters
Passing Parameter Values
Requesting Parameter Values
Converting Dashboard Items
Dashboard Layout
Dashboard Title
Dashboard Item Caption
Dashboard Items Layout
Undo and Redo Operations
Saving a Dashboard
Opening a Dashboard
Exporting
UI Elements
Toolbox
Dashboard Surface
Dashboard Menu
Dashboard Item Menu
Data Item Menu
Web Dashboard - Viewer Mode
Data Presentation
Data Presentation Basics
Master Filtering
Drill-Down
Dashboard Layout
Dashboard Parameters
Requesting Parameter Values
Exporting
Dashboard Items
Chart
Data Presentation Basics
Interactivity
Exporting
Scatter Chart
Data Presentation Basics
Interactivity
Exporting
Grid
Data Presentation Basics
Interactivity
Exporting
Pies
Data Presentation Basics
Interactivity
Exporting
Cards
Data Presentation Basics
Interactivity
Exporting
Gauges
Data Presentation Basics
Interactivity
Exporting
Pivot
Exporting
Choropleth Map
Data Presentation Basics
Interactivity
Exporting
Geo Point Maps
Data Presentation Basics
Interactivity
Exporting
Range Filter
Exporting
Image
Exporting
Text Box
Exporting
Treemap
Data Presentation Basics
Interactivity
Exporting
Filter Elements
Interface Elements
Common Activities
Touch Support
Card View
Data Editing
Add and Delete Cards
Switching a CardView to Edit Mode
Save or Discard Changes
Batch Editing
Selection and Navigation
Page Navigation
Select Cards
Sorting
[Filtering]
Creating Complex Filter Criteria with the Filter Control
Header Filter
Date Range Header Filter
Search Panel
Exporting
Charting
Chart Designer
Series Selection
Data View
Docking Panel
Document Viewer
Classic Document Viewer
[Navigation]
Navigate to a Specific Report Page
Navigate using Report Bookmarks
Search for a Specific Text within a Report
[Printing]
Print a Report Using the PDF Web Browser Plug-In
Install and Activate the Adobe Reader Plug-In for Printing in a Web Browser
Print Reports Using the Native Functionality of a Web Browser
[Exporting]
Export a Report and Save It to the Disk
Export a Report and Show It in a New Window
Passing Parameter Values
HTML5 Document Viewer
[Viewing and Navigating]
Navigate Between Pages
Navigate Using Bookmarks
Search for a Specific Text
Switch Display Mode
Zooming
Content Editing
Passing Parameter Values
Printing
[Exporting]
Export a Document
CSV-Specific Export Options
HTML-Specific Export Options
Image-Specific Export Options
MHT-Specific Export Options
PDF-Specific Export Options
RTF-Specific Export Options
Text-Specific Export Options
XLS-Specific Export Options
XLSX-Specific Export Options
DOCX-Specific Export Options
Editors
Work with Dropdown Editors
Editing Values, Selecting Text and Using the Clipboard
Editor Context Menu
Masked Input
Calendar
Fast Navigation Window
Date Selection
Captcha
Color Edit
Custom Color Picker
Date Edit
Image Uploading
Token Box
Track Bar
Track and Scale Clicks
Change Buttons Clicks
Dragging Bar Highlight
Drag Handle Drag-n-Drop
Validation Summary
File Manager
File and Folder Editing
Filtering Files
Multiple File Selection
Uploading Files
Downloading Files
Details View
Access Control
Adaptive Layout
File Upload Control
Uploading a Single File
Uploading Multiple Files
Canceling File Uploading
Multi-File Selection
Filter Editor
Create New Conditions in Filter Editor
Change Conditions in Filter Editor
Delete Conditions in Filter Editor
Grid
[Data Editing]
Add and Delete Grid Rows
Save or Discard Changes when Editing Grid Rows
Switch a Grid to Edit Mode
Batch Editing
[Selection and Navigation]
Page Navigation in Grids
Select Grid Rows
Keyboard Navigation
[Expand and Collapse Group Rows]
Expand and Collapse Group Rows
[Sorting]
Sort Grid Rows
[Grouping]
Group Grid Rows
[Filtering]
Date Range Header Filter
Filtering Grid Data
Search Panel
Creating Complex Filter Criteria with the Filter Control
[Context Menu]
Context Menu
[Layout Customization]
Hide and Display Grid Columns
Reorder Grid Columns
[Customization Dialog]
Sorting Page
Grouping Page
Filtering Page
Column Chooser
[Responsive Layout]
Responsive Layout
[Grid Lookup]
Grid Lookup
Filter Grid Lookup Data
Select Grid Lookup Rows
HTML Editor
[HTML Editor User Interface]
Ribbon
View Modes
Context Menu
Toolbar
Search Panel
Tag Inspector
[Formatting Text]
Make Text Bold in HTML Editor
Apply Italic Formatting in HTML Editor
Underline Text in HTML Editor
Apply Strikethrough Formatting in HTML Editor
Change Foreground Color in HTML Editor
Change Background Color in HTML Editor
Change Font Type in HTML Editor
Change Font Size in HTML Editor
Make Text Superscript or Subscript in HTML Editor
Remove Formatting in HTML Editor
[Formatting Paragraphs]
Text Indentation in HTML Editor
Text Alignment in HTML Editor
Paragraph Styling in HTML Editor
Ordered and Bullet Lists in HTML Editor
Paste Formatting
[Find and Replace Dialog]
Find and Replace Dialog
[Working with Hyperlinks]
Create a Hyperlink in HTML Editor
Modify a Hyperlink in HTML Editor
Remove a Hyperlink in HTML Editor
[Working with Tables]
Create a Table in HTML Editor
Remove a Table in HTML Editor
Modify a Table in HTML Editor
[Working with Images]
Insert an Image in HTML Editor
Modify an Image's Settings in HTML Editor
Image Settings
[Working with Audio Files]
Insert an Audio Into HTML Editor
Modify Audio Settings in HTML Editor
Audio Settings
[Working with Flash Files]
Modify Flash Settings in HTML Editor
Insert a Flash Into HTML Editor
Flash Settings
[Working with Video Files]
Modify Video Settings in HTML Editor
Insert a Video Into HTML Editor
Video Settings
[Working with YouTube Video]
Modify YouTube Video Settings in HTML Editor
Insert a YouTube Video Into HTML Editor
YouTube Video Settings
[Miscellaneous Operations]
Repeat and Undo Actions in HTML Editor
Printing HTML Editor Content
Clipboard Operations in HTML Editor
Check Spelling in HTML Editor
Sizing and Full-Screen Mode
Export HTML Editor Content to Various Documents Formats
Shortcuts
Image Gallery
Fullscreen Viewer
Image Gallery Pager
Image Slider
Image Zoom
Fullscreen Window
Navigation Bar
Menu
Menu Scrolling
Responsive Layout
Navigation Bar
News Control
Pivot Table
Data Presentation
Sort Data in Pivot Tables
Simple Sorting
Sort Data Using a Field List
Sort Data by Summaries
Filter Data in Pivot Tables
Filter Data by Field Values
Invoke a Filter Popup Window
Using Filter Popup Windows
Build Complex Filter Criteria
Layout Customization
Expand and Collapse Groups in Pivot Tables
Hide Pivot Table Fields
Hide Fields Using the Context Menu
Hide Fields Using a Field List
Display Hidden Pivot Table Fields
Reorder Pivot Table Fields
Simple Fields Reordering
Reorder Fields Using a Field List
Field List Overview
Invoke a Field List
Defer Pivot Table Updates
Change Field List Layout
Popup Window
Rating
Report Designer
Report Types
Table Report
Multi-Column Report
Label Report
Parameterized Report
Cross-Tab Report
Drill-Down Report
Chart with Static Series
Chart with Dynamic Series
[Master-Detail Report (Subreports)](/interface-elements-for-web/articles/report-designer/report-types/master-detail-report-(subreports).md)
[Master-Detail Report (Detail Report Bands)](/interface-elements-for-web/articles/report-designer/report-types/master-detail-report-(detail-report-bands).md)
Master-Detail Report
Creating Reports
Basic Operations
Create a New Report
Create Report Elements
Change Measurement Units of a Report
Adjust the Layout of Report Elements
Adjust Page Layout Settings
Providing Data
Bind a Report to Data
Bind Report Controls to Data
Report Parameters
Query Parameters
Calculated Fields
Shaping Data
Grouping Data
Sorting Data
Filtering Data
Calculating Summaries
Formatting Data
Appearance Customization
Understanding Style Concepts
Use Odd and Even Styles
Conditionally Change a Control's Appearance
Conditionally Change a Label's Text
Conditionally Hide Bands
Report Navigation and Interactivity
Create a Document Map with Bookmarks
Create a Table of Contents
Create Hyperlinks
Add a Cross-Reference
Enable Content Editing in Print Preview
Add Details about a Report
Add Page Numbers and System Information to a Report
Create or Modify Watermarks of a Report
Scripting
Report Elements
Report Controls
Report Bands
Interface Elements
Design Surface
Field List
Main Toolbar
Menu
Properties Panel
Query Builder
Report Explorer
Toolbox
Custom SQL Editor
Expression Editor
Filter Editor
Format String Editor
Master-Detail Relation Editor
Script Editor
Wizards
SQL Data Source Wizard
Adding a New Data Source
Choose a Data Connection
Create a Query or Select a Stored Procedure
Configure Query Parameters
Configure Master-Detail Relationships
Editing an Existing Data Source
Create a Query or Select a Stored Procedure
Configure Query Parameters
Report Wizard
Choose a Report Type
Empty Report
Data-bound Report
Choose a Data Source
Choose a Table or View
Choose Columns
Create Groups
Choose Summary Options
Choose a Report Layout
Choose a Report Style
Specify the Report Title
Label Report
Choose the Label Type
Specify the Label's Parameters
Document Preview
Preview Toolbar
Export Options Panel
Search Panel
Document Map Panel
Preview Parameters Panel
Ribbon
Minimizing the Ribbon
[Gallery Bar]
Gallery Bar
Invoke Ribbon Commands
Rich Text Editor
[Text Editor UI]
Editor Elements
Ribbon Interface
[File Operations]
Create a New Document
Load a Document
Print a Document
Save a Document
[Document Layout and Page Setup]
Divide a Documents into Sections
Adjust Page Settings
Lay Out Text in Columns
[Viewing and Navigating]
Navigate through a Document
Show Horizontal Ruler
Full Screen Mode
[Text Editing]
Select Text
Delete Text
Cut, Copy and Paste Editor's Content
Undo and Redo Last Operations
[Formatting]
Format Text
Format Paragraphs
Using Tabs
Using Indents
Apply Predefined Styles
[Pictures and Text Boxes]
Insert, Select, Copy or Delete a Picture or Text Box
Move a Picture or Text Box
Resize a Picture or Text Box
Rotate a Picture or Text Box
Wrap Text Around a Picture or Text Box
Add, Change or Delete a Border for a Picture or Text Box
Add, Change or Delete a Text Box Fill
[Lists]
Numbered Lists
Bulleted Lists
Multilevel Lists
Mail Merge
Keyboard Shortcuts
File Operations
Navigation inside Documents
Work with Selections
Copy, Paste and Edit the Content
Text Formatting
[Miscellaneous]
Insert a Page Break
Insert a Hyperlink
Insert a Symbol
Round Panel
Scheduler
[Appointment Management]
Create an Appointment
Edit an Appointment
Manage Reminders
Make a Series of Recurring Appointments
Delete an Appointment
Restrictions for Operations with Appointments
[Layout Customization]
Switch Scheduler Views
Scheduler Grouping
[Selection and Navigation]
Navigate Time Cells and Dates in the Scheduler
Navigate Scheduler Resources
Scheduler Navigation Buttons
Scheduler 'More' Buttons
Spell Checker
Splitter
Resizing a Pane
Expand or Collapse a Pane
Spreadsheet
[Spreadsheet UI]
Ribbon Interface
Spreadsheet Elements
[File Operations]
Create a Workbook
Load a Workbook
Create a Worksheet
Rename a Worksheet
Delete a Worksheet
Save a Workbook
Import Text Files
Print a Workbook
Adjust Page Settings
Undo and Redo Last Actions
[Viewing]
Hide and Display Worksheets
Hide Gridlines
Full Screen Mode
[Editing Cells]
Select Cells or Cell Content
Copy and Paste Cell Content
Fill Data Automatically
Find and Replace
Insert a Comment
[Cell Formatting]
Format Cells
Format Cell Content
Wrap Text and Merge Cells
Number Formatting
Clear Cell Formatting
[Columns and Rows]
Insert and Delete Rows and Columns
Show and Hide Columns and Rows
Specify Column Width and Row Height
[Data Presentation]
Sort Data
[Formulas]
Create a Simple Formula
Cell References
Using Functions in Formulas
Supported Functions
Error Types in Formulas
[Charting]
Charting Overview
Creating a Chart
Changing a Chart Type
Applying a Predefined Chart Layout and Style
Modifying a Chart Manually
[Pictures and Hyperlinks]
Insert a Picture
Move and Resize a Picture
Insert and Delete Hyperlinks
Keyboard Shortcuts
File Operations
Navigation inside Worksheets
Work with Selections
Copy, Paste and Edit the Cell Content
Cell Formatting
Work with Columns and Rows
Tab Control
Tab Scrolling
Tree List
Edit Tree List Cells
[Data Presentation]
Expand and Collapse Tree List Nodes
Sort Nodes in Tree List
[Filtering]
Header Filter
Date Range Header Filter
Data Filter Row
Search Panel
Creating Complex Filter Criteria with the Filter Control
[Layout and Navigation]
Selection and Navigation in Tree List
Reorder Columns in Tree Lists
Reorder Tree List Nodes
Keyboard Navigation
Field Chooser
Tree View
Expand and Collapse Tree View Nodes
Tree View Nodes Checking
Vertical Grid
[Data Editing]
Add, Delete and Recover Records
Switching a Vertical Grid to Batch Edit Mode
Save or Discard Changes when Editing Grid Records
Batch Editing
[Selection and Navigation]
Page Navigation
Select Records
[Filtering]
Creating Complex Filter Criteria with the Filter Control
Header Filter
Search Panel
Sorting
Expand and Collapse Category Rows
Published with GitBook
Working with SQL Data Sources
Working with SQL Data Sources
Topics in this section describe how to work with data in a
connected SQL data source
.
Manage SQL Queries
Dashboard Data Source Wizard
Query Builder
Filter Queries
Pass Query Parameters
Stored Procedures
Preview Data
results matching "
"
No results matching "
"