Display several data set row in the same table detail row

Hi!

I have a data set with two columns :
name, value
SLA1,80%
SLA1,90%
SLA1,40%
SLA1,70%
SLA1,50%
SLA1,30%

I would like to display the rows in a table and export the report in PDF format.
The problem is that if my data set returns a lot of rows, my PDF report will be generated with a lot of pages and each page will contain two column and a large empty area.

So I would like to present the table like this :

header :
detail 1 : name1 | name 2 | name 3
detail 2 : 80% | 90% | 70%
footer :

So the first column will present only the data set rows which rownum%3 = 0
The second column will present only the data set rows which rownum%3 = 1
And the third column will present only the data set rows which rownum%3 = 2

Is there a way to do this using javascript maybe?

Thanks for your help.

Find more posts tagged with

Comments

frenchGuy

I already have a method :
- a table is binded to the data set
- I insert a grid with 3 columns in the table detail row
- each grid cell has a table
- I display the values in the second level tables by filtering with the following rules
rownum%3 = 0
rownum%3 = 1
rownum%3 = 2

Do you have a better method?

thuston

A crosstab? You can make a computed column (Xcol) that is a static value 'X'.
Then create your cube and group on name (or RowNumber) and Xcol, measure on Value.
Use XCol for Crosstab row and delete the data control so the 'X' is not displayed.
This would allow it to grow for any number of dataRows.

Another option would be a Table with Aggregate strings. The issue here would be with alignment.
AggName = "name1, name2, name3, ..."
AggVal = "80%, 90%, 40%, ..."

235383

Hi junior member,

Can u just tell me specifically how to use the rown num filter in the inner table.

I tried giving the filter. I throws error like row_ronum%3 is not a

I am also need to display the column values into row wise...

Pleease tell me where and how to make this happen...

Thanks
prasad

mwilliams

prasad,

Create a computed column in your dataSet called rowCount and use the aggregation "runningcount". You can then use this field to filter your different columns. Let me know if you have issues still.

235383

Williams,

Can u please be specific.If possible can u attach me a sample

mwilliams

What is your BIRT version?

235383

It is 3.2.17 ...

mwilliams

Take a look at this report.

birtguru

hi
i have used a table in report design.when i run .rptdesign it do not show table contents.
eg.
like the attachments you have given her is not showing city names if i run it with java application...
please help me out..
i am using 3.7.2 version
if i view it directy in tool than it works good.but with java application it is not showing table content .it shows only header with java application..
any idea about it.

mwilliams

I have not tried running it with java. Can you attach the java code that you're using to run it?