ReportServer Forum

aperturepro

Member

Registered: 2017-02-08

Hello and a basic question.

Hello everyone,

I am new to ReportServer and would very much like to learn from everyone here.

To start off, I have a question regarding Excel template. Can we do reports, extracting field values from multiple queries and create document (or report) like BIRT/Jasper/Crystal or is it just for listing?

Thank you in advance!

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Hello and a basic question.

Hello aperturepro,

welcome to the forum.

I am not sure if I understand your question correctly. What would you like to do in detail ?

Cheers,
Eduardo

aperturepro

Member

Registered: 2017-02-08

Re: Hello and a basic question.

Hi Eduarde

An example would be

KPI Target from 3 sources and  actual numbers coming from 3 system. Ba

The report will look like this;

https://www.google.com.sg/url?sa=i&rct= … 7699239519

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Hello and a basic question.

Still not getting what are you trying to do. Where is the excel template you mention? What are you trying to do with this template? What sources do you mean? What type of reports are you trying to create? What do you mean by "just for listing"?

Please try to explain what you are trying to do with a simple example.

Cheers,
Eduardo

aperturepro

Member

Registered: 2017-02-08

Re: Hello and a basic question.

Eduarde

Maybe I will rephrase my question, is the Excel template report strictly mean for listing columnar values?

karolina

Member

Registered: 2014-08-09

Re: Hello and a basic question.

Hi,

My 2 cents:

Excel export of a dynamic list or simple Excel export for JasperReports is just for simple row listing. If you use subtotals in the dynamic lists, then they are reflected in the exported Excel file.

If you need sth more sophisticated, like formating, or even macros and pivot tables, you may use jxls templates attached to dynamic list report variant. This will be suitable for situation when you have one datasource and one query that returns one table.

If you have one datasource, but you have more than one query, you may use jxls reports. There you write SQL queries inside the jxls report.

If you have more than one datasource and still you want to have Excel-like report, you may write a script report and put data into Excel file by the script, but this is advanced.

You will find more information about jxls templates, jxls reports and script reports in the documentation. Note that ReportServer uses jXLS 1.x version

Karolina

Last edited by karolina (2017-02-08 14:16:02)

aperturepro

Member

Registered: 2017-02-08

Re: Hello and a basic question.

Karolina

Thank you. That seems to answer the question.