My Blog

Report Server on cloud

1-click AWS Deployment    1-click Azure Deployment

Overview

ReportServer Community provides you with all that is necessary for great reporting.  From pixel-perfect reporting to ad-hoc relational reporting, ReportServer Community has it covered.

ReportServer is a modern and versatile open source business intelligence platform with powerful reporting features.

With ReportServer you are not limited to one provider’s solutions. ReportServer integrates Jasper, Birt, Mondrian and Excel-based reporting: choose what best suits your needs!

1-Click Report Server on Ubuntu 14.04 LTS

Features

Major Features of Report server com

  • Fast, modern and intuitive user interface
  • Platform independent: runs within your browser
  • Powerful ad hoc reporting capabilities
  • Integrates Jasper and Eclipse BIRT in one unified environment
  • Flexible Dashboard component
  • Native Excel export
  • Excel templates (via jXLS library) for preformatted reports
  • Flexible scheduler with support for complex patterns
  • TeamSpaces: a unique concept to support collaboration
  • Extensively configurable permission system, based on hierarchical structures and ACLs
  • Administrative tools capable to manage even large scale installations
  • Importing and exporting all entities from/to xml
  • Powerful Ad-Hoc reporting.
  • Integrate Jsper, Birt and crystal.
  • Multidimensional OLAP Reporting
  • Extendable via scripting
  • Open Source

Azure

Installation Instructions For Ubuntu

Note : 1. Please use “Reportserver” in the place of “stack_name

                 2. How to find PublicDNS in Azure

A) Application URL: Access the application via a browser at http://PublicDNS/reportserverent

  •  Username : azureuser (Please create new user and delete this user)
  •  Password : Passw@rd123

B) SSH Connection: To connect to the operating system,

1) Download Putty.

2) Connect to virtual machine using following SSH credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 22

Username: Your chosen username when you created the machine ( For example:  Azureuser)

Password : Your Chosen Password when you created the machine ( How to reset the password if you do not remember)

C) Other Information:
Default installation path: will be on your web root folder “/var/www/html/reportserverent” ( Please see above Note for stack name)
2.Default ports:

  • Linux Machines:  SSH Port – 22 or 2222
  • Http: 80 or 8080
  • Https: 443
  • Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306

E)Database Login Details :

  • MYSQL Username : root
  • MYSQL Password : Passw@rd123

Note :-Please change password immediately after first login.
Configure custom inbound and outbound rules using this link

Installation Instructions For Centos

Note : 1. Please use “Reportserver” in the place of “stack_name

                 2. How to find PublicDNS in Azure

A) Application URL: Access the application via a browser at http://PublicDNS/Reportserver

  •  Username : azureuser (Please create new user and delete this user)
  •  Password : Passw@rd123

B) SSH Connection: To connect to the operating system,

1) Download Putty.

2) Connect to virtual machine using following SSH credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 22

Username: Your chosen username when you created the machine ( For example:  Azureuser)

Password : Your Chosen Password when you created the machine ( How to reset the password if you do not remember)

C) Other Information:
Default installation path: will be on your web root folder “/var/www/html/Reportserver” ( Please see above Note for stack name)
2.Default ports:

  • Linux Machines:  SSH Port – 22 or 2222
  • Http: 80 or 8080
  • Https: 443
  • Sql or Mysql ports: By default these are not open on Public Endpoints. Internally Sql server: 1433. Mysql :3306

E)Database Login Details :

  • MYSQL Username : root
  • MYSQL Password : Passw@rd123

Note :-Please change password immediately after first login.

Configure custom inbound and outbound rules using this link

Videos

1-Click Report Server on Ubuntu 14.04 LTS

The Report Server – Installation

Introduction To SQL Server Reporting Services

Report Server on cloud

Related Posts