ReportServer Admin Guide 4.5.0
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.1.1.
SQLite
4.2.
Amazon Redshift
4.3.
Google BigQuery
4.4.
Teradata
4.5.
Storage of Database Passwords
4.6.
Datasource Pool
4.7.
CSV Lists
4.7.1.
Database Cache
4.7.2.
Configuration at the Object
4.8.
Script datasources
4.8.1.
Configuration at the Object
4.9.
BIRT Report datasource
4.10.
Mondrian Datasource
4.11.
Datasource Bundle
4.12.
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.
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
11.
Scheduling of Reports
11.1.
Technical Backgrounds to Scheduler Jobs
11.2.
Filtering by the Status of a Job
11.3.
Notifications
11.4.
Terminal Commands
11.5.
Conditional Scheduling
11.6.
Creating and Using a Condition Report
11.6.1.
Creating a condition
11.6.2.
Using the condition while scheduling
11.7.
Predefined Conditions
11.8.
Defining a Simple Condition via Scripting
12.
Theming
13.
Terminal
13.1.
Using the Terminal
13.2.
The Virtual File System
13.3.
Assigning Aliases
13.4.
Scripts
13.5.
Object Resolver
14.
ReportServer Scripting
14.1.
A first Hello World
14.2.
How to Handle Errors
14.3.
Administrative Scripts
14.4.
Changing the Data Model
14.5.
Enhancing ReportServer with Scripts
14.6.
Scheduling of Scripts
14.7.
Accessing Scripts by URL
15.
Integrating ReportServer with an Active Directory using LDAP
15.1.
Synchronizing Users
15.2.
Authenticating Users
15.3.
Possible Improvements
16.
Terminal Operators
16.1.
Write-into-file operators
16.2.
Write-into-datasink operator
17.
Terminal Commands
17.1.
birt
17.2.
cat
17.3.
cd
17.4.
clearInternalDbCache
17.5.
clearInternalScriptCache
17.6.
columnsExist
17.7.
columnsMetadata
17.8.
config
17.9.
connPoolStats
17.10.
copyTableContents
17.11.
cp
17.12.
createTextFile
17.13.
datasourceMetadata
17.14.
deployReport
17.15.
desc
17.16.
diffconfigfiles
17.17.
dirmod
17.18.
echo
17.19.
editTextFile
17.20.
eliza
17.21.
env
17.22.
exec
17.23.
export all
17.24.
groupmod
17.25.
haspermission
17.26.
hello
17.27.
id
17.28.
info
17.28.1.
info datasource
17.29.
import all
17.30.
kill
17.31.
ldapfilter
17.32.
ldapguid
17.33.
ldapimport
17.34.
ldapinfo
17.35.
ldapschema
17.35.1.
ldapschema attributeInfo
17.35.2.
ldapschema attributeList
17.35.3.
ldapschema entry
17.35.4.
ldapschema matchingRuleInfo
17.35.5.
ldapschema matchingRuleList
17.35.6.
ldapschema objectClassInfo
17.35.7.
ldapschema objectClassInfo
17.35.8.
ldapschema syntaxRuleInfo
17.35.9.
ldapschema syntaxRuleList
17.36.
ldaptest
17.36.1.
ldaptest filter
17.36.2.
ldaptest guid
17.36.3.
ldaptest groups
17.36.4.
ldaptest organizationalUnits
17.36.5.
ldaptest users
17.36.6.
ldaptest orphans
17.37.
listlogfiles
17.38.
listpath
17.39.
locate
17.40.
ls
17.41.
meminfo
17.42.
mkdir
17.43.
mv
17.44.
onedrive
17.45.
pkg
17.46.
ps
17.47.
pwd
17.48.
rcondition
17.49.
reportmod
17.50.
rev
17.51.
rm
17.52.
scheduleScript
17.53.
scheduler
17.54.
sql
17.55.
tableExists
17.56.
ssltest
17.57.
teamspacemod
17.58.
unzip
17.59.
updateAlias
17.60.
updatedb
17.61.
usermod
17.62.
variantTest
17.63.
viewlogfile
17.64.
xslt
17.65.
zip
18.
Dashboards and Dadgets
18.1.
Static HTML Dadgets
18.2.
Embedding Dashboards via the URL
19.
SFTP Server
20.
Maintenance
20.1.
Testing User Specific Settings (su)
20.2.
Logging
20.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.5.0
Terminal Commands
pkg
17.44. onedrive
...
17.46. ps
17.45. pkg
Command to install ReportServer packages.
list
Lists all available packages in the local filesystem.
install
Install a package. Use flag
-d
to install package from local file system.
Home
Documentation
ReportServer Admin Guide 4.5.0
Terminal Commands
pkg
17.44. onedrive
...
17.46. ps
