nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How would you create report from XLS with > 600 Rows

domurada

Hello Guys,
Me again.
 
 
So simple Question, how would you create a Report from an XLS with over 600 Rows. 
I have an huge XLS File, where on the First Row are Datum Fields (who change regular) and on the First Column are the actual labels.

Find more posts tagged with

Comments

GLO_FR

Hi,
 
you can use your Excel file as a datasource and the sheet containing your 600 rows like a normal dataset.

domurada

I have tried that. 
Created a Excel DataSource, but when I try to create the Dataset I have like no way to configurate the how and which data I actual want. It just gives me the ability to pick the Sheet, and then some Indicators from Row like it would read a Table. I want my Data transposed.

GLO_FR

Hi,
 
in fact to use an Excel sheet in BIRT, the data inside has to be structured like a database table.
It means you have to place the data/value you want to use in BIRT before in the Excel sheet more or less like this.
<pre class="_prettyXprint _lang-nocode">
| COLUMN A | COLUMN B | COLUMN C
---+

1| <my field 1> | <my field 2> | <my field 3>
---+

2|<my value 1.1>|<my value 2.1>|<my value 3.1>
---+

3|<my value 1.2>|<my value 2.2>|<my value 3.2>
---+

4|<my value 1.3>|<my value 2.3>|<my value 3.3>
---+

5|<my value 1.4>|<my value 2.4>|<my value 3.4>
---+

6|<my value 1.5>|<my value 2.5>|<my value 3.5>
</pre>

domurada

Poorly I am not able to configure the Excel Sheet or more not allowed to. 

<pre class="_prettyXprint _lang-">
| 1.1.2014 | 2.5.2014 | 10.7.2014
---+

Group A|
---+

A.1|<my value 1.1>|<my value 2.1>|<my value 3.1>
---+

A.2|<my value 1.2>|<my value 2.2>|<my value 3.2>
---+

Group B|
---+

B.1|<my value 1.4>|<my value 2.4>|<my value 3.4>
---+

Group C
---+

C.1|<my value 1.1>|<my value 2.1>|<my value 3.1>
---+

C.2|<my value 1.2>|<my value 2.2>|<my value 3.2>
</pre>

That is how my Excel Sheet is looking.

GLO_FR

Right now, the only way I see to solve your problem is to create a scripting dataset which will give the right output of your Excel file.
 
1) On the onFetch event of your Excel DataSet, put the different rows in an array for instance
2) In the scripted DataSet read the array and with javascript code place the different "cells" the way you want
 
 
BTW, the easiest solution will be to modify the excel file before, but if you're not allowed to do it

domurada

Ye that it won't be easy was sure at start... Maybe I find/write a Tool that could change the XLS Temporary to read it but I dunno if I could build this in automaticly. 
One way, what whould make everything **** of easier would be a Function who would be called in the OnFetch or anyother Event, which would allow me to add new Cells to the existing DataSet. Is there a possiblity to do that ?

GLO_FR

Hi
 
<blockquote class="ipsBlockquote" data-author="domurada" data-cid="131001" data-time="1411730870">
<div>
One way, what whould make everything **** of easier would be a Function who would be called in the OnFetch or anyother Event, which would allow me to add new Cells to the existing DataSet. Is there a possiblity to do that ?
</div>
</blockquote>
 
Probably yes, but certainly very hard to do. BTW, this won't solve your problem.
 
Either you can modify the Excel file before using it in BIRT, or on the fly with, on my point of view, a scripted dataset