ReportServer Admin Guide 4.6.1
Navigation
1.
Preamble
2.
First Steps
2.1.
Configuration and installation
2.2.
Login
2.3.
Creating a datasource
2.4.
Creating your First Report
2.5.
Importing a Graphical Report
2.6.
Creating users
2.7.
Terminal and FileServer
3.
User and Permission Management
3.1.
The User Tree
3.2.
Permission Management
3.2.1.
Determining if a Permission is Granted
3.2.2.
Generic rights
3.2.3.
Object Related Rights
3.2.4.
Virtual Roots
4.
Datasources
4.1.
Relational Databases
4.2.
Athena
4.3.
Db2 for IBM i
4.4.
Db2 for z/OS
4.5.
Derby
4.6.
CockroachDB
4.7.
CrateDB
4.8.
Exasol
4.9.
Google BigQuery
4.10.
Incorta
4.11.
Redshift
4.12.
SAP HANA
4.13.
SQL Server
4.14.
SQL Server (Old driver, jTDS)
4.15.
SQLite
4.16.
Teradata
4.17.
YugabyteDB
4.18.
Storage of Database Passwords
4.19.
Datasource Pool
4.20.
CSV Lists
4.20.1.
Database Cache
4.20.2.
Configuration at the Object
4.21.
Script datasources
4.21.1.
Configuration at the Object
4.22.
BIRT Report datasource
4.23.
Mondrian Datasource
4.24.
Datasource Bundle
4.25.
Configuration of a Standard Datasource
5.
Datasinks
5.1.
Email - SMTP
5.2.
Table datasinks
5.3.
SFTP
5.4.
FTPS
5.5.
FTP
5.6.
Samba - SMB/CIFS
5.7.
Amazon S3
5.8.
SCP
5.9.
Local Filesystem
5.10.
Printer Datasinks
5.11.
Script Datasinks
5.12.
OAuth2-authenticated datasinks
5.13.
Dropbox
5.14.
OneDrive - SharePoint (O365)
5.15.
Google Drive
5.16.
Box
6.
File System
6.1.
Configuration Files
6.2.
Filing of Scripts
6.3.
Rendering DOT files
6.4.
Rendering Markdown files
6.5.
Accessing Resources by URL
7.
Report Management
7.1.
Fundamentals
7.2.
The Dynamic List
7.2.2.
Variants of the Dynamic List
7.2.3.
Output Formats of the Dynamic List
7.2.4.
Configuring the Dynamic List
7.2.5.
The Metadata Datasource
7.2.6.
Linking Dynamic Lists to URLs
7.2.7.
Linking Geolocation Data in Dynamic Lists to Google Maps
7.2.8.
Customizing Dynamic Lists via Report Properties
7.2.9.
Exporting Dynamic List Configuration
7.2.10.
Theming HTML and PDF Output
7.3.
Working with Parameters
7.3.1.
The Parameter Types
7.3.2.
General Usage of Parameters
7.3.3.
Parameter Instances
7.3.4.
The Text Entry Parameter
7.3.5.
The Date Parameter
7.3.6.
The Datasource Parameter
7.3.7.
File-Selection Parameter
7.3.8.
Script Parameter
7.3.9.
Cascading Parameters
7.3.10.
Using Parameters
7.3.11.
Parameters in Datasources: Mondrian Schema
7.3.12.
Parameters in Datasources: CSV List
7.3.13.
Parameters in Datasources: Script Datasources
7.3.14.
Special Parameters
7.4.
JasperReports
7.4.1.
Unformatted Excel Output
7.5.
Eclipse Birt
7.6.
SAP Crystal Reports
7.6.1.
Prepare ReportServer for Crystal
7.6.2.
Use Crystal Reports
7.7.
Saiku / Mondrian Reports
7.8.
JXLS Reports
7.8.1.
JXLS2
7.9.
Script Reports
7.9.1.
Arguments
7.9.2.
Parameters
7.9.3.
Output Formats
7.9.4.
Datasources
7.10.
Grid Editor Reports
7.10.1.
A Basic Grid Editor
7.10.2.
A Fluid API
7.10.3.
Global Editor Configuration
7.10.4.
Column Configs
7.10.5.
Data Validation
7.10.6.
Field Editors
7.10.7.
Predefined Variables
7.10.8.
Obtaining a Database Connection
7.10.9.
Foreign Key Relationships
7.11.
Executing Reports via the URL
7.11.1.
Particularities of the Dynamic List
7.11.2.
Configuring Reports in ReportServer by URL
7.11.3.
Embedding Reports Without Login
7.11.4.
Embedding the Report Execution View
7.12.
Report Properties
7.12.1.
Available Report Properties per Type
7.13.
Report Metadata
7.13.1.
Using Metadata as Parameters
7.14.
Drill Down Reports
8.
Global Constants
9.
User Variables
9.1.
Defining User Variables
9.2.
Allocating User Variables
9.3.
Using User Variables in Reports
10.
Import and Export
10.1.
Exporting
10.1.1.
Export Format
10.2.
Importing
10.2.1.
Importing Reports
10.2.2.
Importing Datasources
10.2.3.
Importing Users and Files
10.2.4.
Checkbox quot;mergequot;
11.
REST API
11.1.
Finding the REST URL
11.2.
Authentication
11.3.
test Service
11.4.
general-info Service
11.5.
dot-renderer Service
11.5.1.
Virtual Filesystem / Internal Files
11.5.2.
External Files
11.5.3.
Customizing Output
11.6.
markdown-renderer Service
11.6.1.
Virtual Filesystem / Internal Files
11.6.2.
External Files
11.6.3.
Customizing Output
11.7.
node-exporter Service
11.7.1.
Exporting reports
11.7.2.
Exporting users
11.7.3.
Exporting datasources
11.7.4.
Exporting datasinks
11.7.5.
Exporting files
11.7.6.
Exporting remote servers
11.7.7.
Exporting transports
11.7.8.
Exporting dashboards from dashboard library
12.
Remote RS Servers
13.
Scheduling of Reports
13.1.
Technical Backgrounds to Scheduler Jobs
13.2.
Filtering by the Status of a Job
13.3.
Notifications
13.4.
Terminal Commands
13.5.
Conditional Scheduling
13.6.
Creating and Using a Condition Report
13.6.1.
Creating a condition
13.6.2.
Using the condition while scheduling
13.7.
Predefined Conditions
13.8.
Defining a Simple Condition via Scripting
14.
Theming
15.
Terminal
15.1.
Using the Terminal
15.2.
The Virtual File System
15.3.
Assigning Aliases
15.4.
Scripts
15.5.
Object Resolver
16.
ReportServer Scripting
16.1.
A first Hello World
16.2.
How to Handle Errors
16.3.
Administrative Scripts
16.4.
Changing the Data Model
16.5.
Enhancing ReportServer with Scripts
16.6.
Scheduling of Scripts
16.7.
Accessing Scripts by URL
17.
Integrating ReportServer with an Active Directory using LDAP
17.1.
Synchronizing Users
17.2.
Authenticating Users
17.3.
Possible Improvements
18.
Terminal Operators
18.1.
Write-into-file operators
18.2.
Write-into-datasink operator
19.
Terminal Commands
19.1.
birt
19.2.
cat
19.3.
cd
19.4.
clearInternalDbCache
19.5.
clearInternalScriptCache
19.6.
columnsExist
19.7.
columnsMetadata
19.8.
config
19.9.
connPoolStats
19.10.
copy
19.10.1.
copy parameterDefinitions
19.10.2.
copy tableContents
19.11.
cp
19.12.
createTextFile
19.13.
datasourceMetadata
19.14.
deployReport
19.15.
desc
19.16.
diffconfigfiles
19.17.
dirmod
19.18.
echo
19.19.
editTextFile
19.20.
eliza
19.21.
entitymerge
19.22.
env
19.23.
exec
19.24.
export all
19.25.
groupmod
19.26.
haspermission
19.27.
hello
19.28.
hql
19.29.
id
19.30.
info
19.30.1.
info datasource
19.31.
import all
19.32.
kill
19.33.
ldapfilter
19.34.
ldapguid
19.35.
ldapimport
19.36.
ldapinfo
19.37.
ldapschema
19.37.1.
ldapschema attributeInfo
19.37.2.
ldapschema attributeList
19.37.3.
ldapschema entry
19.37.4.
ldapschema matchingRuleInfo
19.37.5.
ldapschema matchingRuleList
19.37.6.
ldapschema objectClassInfo
19.37.7.
ldapschema objectClassInfo
19.37.8.
ldapschema syntaxRuleInfo
19.37.9.
ldapschema syntaxRuleList
19.38.
ldaptest
19.38.1.
ldaptest filter
19.38.2.
ldaptest guid
19.38.3.
ldaptest groups
19.38.4.
ldaptest organizationalUnits
19.38.5.
ldaptest users
19.38.6.
ldaptest orphans
19.39.
listlogfiles
19.40.
listpath
19.41.
locate
19.42.
ls
19.43.
meminfo
19.44.
mkdir
19.45.
mv
19.46.
onedrive
19.47.
pkg
19.47.1.
pkg install
19.47.2.
pkg list
19.48.
properties
19.48.1.
properties clear
19.48.2.
properties contains
19.48.3.
properties list
19.48.4.
properties put
19.48.5.
properties remove
19.49.
ps
19.50.
pwd
19.51.
rcondition
19.52.
registry
19.52.1.
registry clear
19.52.2.
registry contains
19.52.3.
registry list
19.52.4.
registry put
19.52.5.
registry remove
19.53.
reportmod
19.54.
rev
19.55.
rm
19.56.
rpull
19.56.1.
rpull copy
19.57.
scheduleScript
19.58.
scheduler
19.59.
sql
19.60.
tableExists
19.61.
transport
19.61.1.
transport create
19.62.
ssltest
19.63.
teamspacemod
19.64.
unzip
19.65.
updateAlias
19.66.
updatedb
19.67.
usermod
19.68.
variantTest
19.69.
viewlogfile
19.70.
xslt
19.71.
zip
20.
Dashboards and Dadgets
20.1.
Static HTML Dadgets
20.2.
Embedding Dashboards via the URL
21.
SFTP Server
22.
Maintenance
22.1.
Testing User Specific Settings (su)
22.2.
Logging
22.3.
Recovering of Objects
A.
Expression Language
B.
Demo Data
English
Toggle navigation
Home
Pricing
Documentation
Download
Forum
Blog
Demo
Home
Documentation
ReportServer Admin Guide 4.6.1
Terminal Commands
hello
19.26. haspermission
...
19.28. hql
19.27. hello
Says hello
Use: hello
Home
Documentation
ReportServer Admin Guide 4.6.1
Terminal Commands
hello
19.26. haspermission
...
19.28. hql
