ReportServer Forum

migueltubia

Member

Registered: 2018-07-09

Create report using REST services

Hi,

we are trying several report engines to automate our reporting tasks.

We need to create reports which connect to several Data Sources:

- Relational DB (mysql...).
- XML Web Services.
- REST JSON Web services.

Does reportserver connect, from one report, to all of these data sources?
From the documentation, I can see that we can connect to MySQL, but I cannot find anything about REST services as Data Sources...

Any help is welcome!
Best regards.
M.

karolina

Member

Registered: 2014-08-09

Re: Create report using REST services

Hi,

See script datasources and script reports (available in RS Enterprise Edition).

Karolina

migueltubia

Member

Registered: 2018-07-09

Re: Create report using REST services

Hi,

thanks for your help. I'm reading about script datasources, but I'm new to ReportServer... Do you know if is there any example with REST APIs?

And from the BIRT report designer in Eclipse, how could I connect/import these DataSources created in ReportServer into BIRT designer?

As I comment, I'm new to this tool and I'm trying to know how to create a report, using BIRT and REST APIs, and I need to know the full process, from creating the DS to generating the report and schedule them, and I'm pretty confused...

thanks for all.
Regards,
M.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Create report using REST services

Hi migueltubia,

using script datasources and script reports you have the full control. You can get data from any source you can connect from within java.
Refer to the documentation:
Script datasources: https://reportserver.net/en/guides/scri … tasources/
Script reports: https://reportserver.net/en/guides/admi … t-Reports/ and https://reportserver.net/en/guides/scri … Reporting/
You can connect with your REST APIs from within java and create either the datasource or the report (dynamic list).
Check here for information:
Data Sources: https://reportserver.net/en/guides/admi … a-Sources/
Dynamic List: https://reportserver.net/en/guides/admi … amic-List/

Documentation overview: https://reportserver.net/en/documentation/

ReportServer datasources are not usable from outside reportserver. These are in most of the cases simple JDBC connections to databases, so you can use these by standard JDBC URLs from within BIRT. If you create a script datasource, this is usable in reportserver as a "normal" datasource. You can use it for example for dynamic lists or for datasource parameters.

I have been testing and, for BIRT reports, this is not currently supported. I raised ticket RS-2968 for this.
Nevertheless, you can use script datasources for dynamic lists, which are exportable in many formats (Excel, PDF, etc). You can consider using dynamic lists for using REST APIs together with reportserver.

Regards,
Eduardo