ReportServer Admin Guide 4.7
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.
MySQL
4.12.
PostgreSQL
4.13.
Redshift
4.14.
SAP HANA
4.15.
SQL Server
4.16.
SQL Server (Old driver, jTDS)
4.17.
SQLite
4.18.
Teradata
4.19.
YugabyteDB
4.20.
Storage of Database Passwords
4.21.
Datasource Pool
4.22.
CSV Lists
4.22.1.
Database Cache
4.22.2.
Configuration at the Object
4.23.
Script datasources
4.23.1.
Configuration at the Object
4.24.
BIRT Report datasource
4.25.
Mondrian Datasource
4.26.
Using XMLA with SQL Server Analysis Services
4.27.
Datasource Bundle
4.28.
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 Graphviz 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: Plain Excel
7.4.2.
Exporting Jasper reports containing images to HTML
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.
Transports
11.1.
General Introduction
11.1.1.
Overview of the Use Cases
11.1.2.
Conclusion
11.2.
Configuration and Prerequisites
11.2.1.
Unique Keys for Objects
11.2.2.
Configuration Files
11.2.3.
Remote Server Configuration
11.2.4.
Version Consistency
11.3.
Usage
11.3.1.
Creating a Transport in the Source System
11.3.2.
Retrieving and Importing the Transport in the Target System
11.3.3.
Applying the Transport in the Target System
11.4.
Monitoring and Logging
11.5.
Frequently Asked Questions FAQ
11.5.1.
What are transports and what purpose do they serve?
11.5.2.
How is a transport created?
11.5.3.
What is the encrypted name of a transport, and why is it used?
11.5.4.
What are the fields in a transport, and why can't they be edited? What can specifically be edited?
11.5.5.
What are transport logs, and how are they structured?
11.5.6.
How can elements be added to a transport?
11.5.7.
What happens if you add the same element to a transport multiple times?
11.5.8.
How can elements be removed from a transport?
11.5.9.
How can you view the elements contained in a transport?
11.5.10.
What happens if you move the original elements? Will these changes be reflected in the transport?
11.5.11.
How do you transfer a transport or a list of transports from one server to another?
11.5.12.
What are application conditions? What conditions must be met to apply a transport?
11.5.13.
What can be done with a transferred transport? What does ''apply'' mean exactly, and what happens when you click ''apply''?
11.5.14.
What happens if you click ''apply'' multiple times?
11.5.15.
Can a transport be transported again?
11.5.16.
What happens if a transport cannot be applied?
11.5.17.
Can multiple transports be applied simultaneously?
11.5.18.
What happens if a transport is interrupted during application?
11.5.19.
Can transports be exchanged between different versions of ReportServer?
11.5.20.
How are transports handled during a system backup?
11.5.21.
How is the order of transports determined?
11.5.22.
What are the risks of applying transports in the wrong order?
11.5.23.
Should intermediate states be transported?
11.5.24.
How can transports be used as a backup of work results during development?
11.5.25.
What configurations are necessary?
11.5.26.
Can applied transports be undone?
12.
REST API
12.1.
Finding the REST URL
12.2.
Authentication
12.3.
test Service
12.4.
general-info Service
12.5.
dot-renderer Service
12.5.1.
Virtual Filesystem / Internal Files
12.5.2.
External Files
12.5.3.
Customizing Output
12.6.
markdown-renderer Service
12.6.1.
Virtual Filesystem / Internal Files
12.6.2.
External Files
12.6.3.
Customizing Output
12.7.
node-exporter Service
12.7.1.
Exporting reports
12.7.2.
Exporting users
12.7.3.
Exporting datasources
12.7.4.
Exporting datasinks
12.7.5.
Exporting files
12.7.6.
Exporting remote servers
12.7.7.
Exporting transports
12.7.8.
Exporting dashboards from dashboard library
13.
Markdown
13.1.
Markdown Syntax Examples
13.1.1.
Header
13.1.2.
Emphasis
13.1.3.
Lists
13.1.4.
Task List Items
13.1.5.
Comments
13.1.6.
Links
13.1.7.
Images
13.1.8.
Blockquotes
13.1.9.
Code
13.1.10.
Embedding Graphviz DOT
13.1.11.
Tables
13.1.12.
Horizontal Rules
13.1.13.
Strikethrough
13.1.14.
Underlining
14.
Graphviz DOT
14.1.
Basic DOT Syntax
14.1.1.
Nodes and Edges
14.1.2.
Subgraphs
14.1.3.
Graph Attributes
15.
Remote RS Servers
16.
Scheduling of Reports
16.1.
Technical Backgrounds to Scheduler Jobs
16.2.
Filtering by the Status of a Job
16.3.
Notifications
16.4.
Terminal Commands
16.5.
Conditional Scheduling
16.6.
Creating and Using a Condition Report
16.6.1.
Creating a condition
16.6.2.
Using the condition while scheduling
16.7.
Predefined Conditions
16.8.
Defining a Simple Condition via Scripting
17.
Theming
18.
Terminal
18.1.
Using the Terminal
18.2.
The Virtual File System
18.3.
Assigning Aliases
18.4.
Scripts
18.5.
Object Resolver
19.
Terminal Operators
19.1.
Write-into-file operators
19.2.
Write-into-datasink operator
20.
Terminal Commands
20.1.
birt
20.2.
cat
20.3.
cd
20.4.
clearInternalDbCache
20.5.
clearInternalScriptCache
20.6.
columnsExist
20.7.
columnsMetadata
20.8.
config
20.9.
connPoolStats
20.10.
copy
20.10.1.
copy parameterDefinitions
20.10.2.
copy tableContents
20.11.
cp
20.12.
createTextFile
20.13.
datasourceMetadata
20.14.
deployReport
20.15.
desc
20.16.
diffconfigfiles
20.17.
dirmod
20.18.
echo
20.19.
editTextFile
20.20.
eliza
20.21.
entitymerge
20.22.
env
20.23.
exec
20.24.
export all
20.25.
groupmod
20.26.
haspermission
20.27.
hello
20.28.
hql
20.29.
id
20.30.
info
20.30.1.
info datasource
20.31.
import all
20.32.
kill
20.33.
ldapfilter
20.34.
ldapguid
20.35.
ldapimport
20.36.
ldapinfo
20.37.
ldapschema
20.37.1.
ldapschema attributeInfo
20.37.2.
ldapschema attributeList
20.37.3.
ldapschema entry
20.37.4.
ldapschema matchingRuleInfo
20.37.5.
ldapschema matchingRuleList
20.37.6.
ldapschema objectClassInfo
20.37.7.
ldapschema objectClassInfo
20.37.8.
ldapschema syntaxRuleInfo
20.37.9.
ldapschema syntaxRuleList
20.38.
ldaptest
20.38.1.
ldaptest filter
20.38.2.
ldaptest guid
20.38.3.
ldaptest groups
20.38.4.
ldaptest organizationalUnits
20.38.5.
ldaptest users
20.38.6.
ldaptest orphans
20.39.
listlogfiles
20.40.
listpath
20.41.
locate
20.42.
ls
20.43.
meminfo
20.44.
mkdir
20.45.
mv
20.46.
onedrive
20.47.
pkg
20.47.1.
pkg install
20.47.2.
pkg list
20.48.
properties
20.48.1.
properties clear
20.48.2.
properties contains
20.48.3.
properties list
20.48.4.
properties put
20.48.5.
properties remove
20.49.
ps
20.50.
pwd
20.51.
rcondition
20.52.
registry
20.52.1.
registry clear
20.52.2.
registry contains
20.52.3.
registry list
20.52.4.
registry put
20.52.5.
registry remove
20.53.
reportmod
20.54.
rev
20.55.
rm
20.56.
rpull
20.56.1.
rpull copy
20.57.
scheduleScript
20.58.
scheduler
20.59.
sql
20.60.
tableExists
20.61.
transport
20.61.1.
transport create
20.62.
ssltest
20.63.
teamspacemod
20.64.
unzip
20.65.
updateAlias
20.66.
updatedb
20.67.
usermod
20.68.
variantTest
20.69.
viewlogfile
20.70.
xslt
20.71.
zip
21.
ReportServer Scripting
21.1.
A first Hello World
21.2.
How to Handle Errors
21.3.
Administrative Scripts
21.4.
Changing the Data Model
21.5.
Enhancing ReportServer with Scripts
21.6.
Scheduling of Scripts
21.7.
Accessing Scripts by URL
22.
Integrating ReportServer with an Active Directory using LDAP
22.1.
Synchronizing Users
22.2.
Authenticating Users
22.3.
Possible Improvements
23.
Dashboards and Dadgets
23.1.
Static HTML Dadgets
23.2.
Embedding Dashboards via the URL
24.
SFTP Server
25.
Maintenance
25.1.
Testing User Specific Settings (su)
25.2.
Logging
25.3.
Recovering of Objects
A.
Expression Language
B.
Demo Data
Home
Documentation
ReportServer Admin Guide 4.7
Terminal Commands
cat
search
20.1. birt
...
20.3. cd
20.2. cat
Allows to display the specified file on the terminal window.
Use: cat file
Home
Documentation
ReportServer Admin Guide 4.7
Terminal Commands
cat
search
20.1. birt
...
20.3. cd