Eclipse Community Forums: BIRT » Getting Data to read from left to right

Help

Home

Home » Archived » BIRT » Getting Data to read from left to right

Show: Today's Messages :: Show Polls :: Message Navigator

Getting Data to read from left to right [message #1685328]

Wed, 18 March 2015 20:08

David Embry

Messages: 3
Registered: March 2015

Junior Member

Being new to BIRT, I need to ask what will probably be a fairly basic question. I have been asked to create a report where the data of one bound field reads from left to right (horizontally) instead of vertically. This field is the months of the year. Below that are two results of a SUM. The report should look like:

Jan Feb Mar Apr May
25 30 26 2 32
16 1 14 33 24

I created a list and inserted a Grid in the detail line of the list. On the outline tab, I selected the Grid and went to "Properties", and changed the "Display" from "Block" to "InLine". However, this did not force the data to display left to right, instead maintaining a vertical stack. I also changed the "Display" on each of the rows of the grid.

Any thoughts or tricks would be highly appreciated. Thanks so much in advance.

Report message to a moderator

Re: Getting Data to read from left to right [message #1687510 is a reply to message #1685328]

Thu, 19 March 2015 17:38

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

From the looks of it, a crosstab would probably be the way to go. If you show me what your data looks like that you want to build this output from and let me know your BIRT version, I could provide an example if you aren't able to get it working. Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Getting Data to read from left to right [message #1687632 is a reply to message #1687510]

Thu, 19 March 2015 18:38

David Embry

Messages: 3
Registered: March 2015

Junior Member

Okay, here is the data. Twelve rows of data, the far left column being the month number. The other two columns are asset and location counts.

MONTHNO ASSET_CNT LOC_CNT
1 923 3507
2 737 2426
3 16 224
4 47 150
5 8 130
6 16 207
7 16 431
8 21 241
9 36 302
10 94 632
11 267 1286
12 695 2805

Since there are numbers for each month of the year, data will always be present for each month.

If you could give me an example, that would be great. Thanks in advance.

Report message to a moderator

Re: Getting Data to read from left to right [message #1687710 is a reply to message #1687632]

Thu, 19 March 2015 19:15

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

What's your BIRT version? I'll have something to you soon after I get that from you. Smile

Michael

Developer Evangelist, Silanis

Report message to a moderator

Re: Getting Data to read from left to right [message #1688468 is a reply to message #1687710]

Fri, 20 March 2015 19:25

David Embry

Messages: 3
Registered: March 2015

Junior Member

Version 3.7.1. I'd be so appreciative if you could help. Thanks!

Report message to a moderator

Re: Getting Data to read from left to right [message #1688474 is a reply to message #1685328]

Fri, 20 March 2015 19:41

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Take a look at the attached report. I created a data cube in the data explorer, use the fields from the cube in a crosstab in the layout, selected the crosstab and changed the orientation to vertical in the property editor, and mapped the short string month values to replace the integer months. Hope this helps. Let me know if you have questions.

You could also possibly use lists to get this working, if this doesn't work for you.

Attachment: LeftToRightData.rptdesign
(Size: 22.97KB, Downloaded 274 times)

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:	Unable to find the connection profile reference by DS connection properties in BIRT report
Next Topic:	jdbc connection profile problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:41:27 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter