Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Getting Data to read from left to right
Getting Data to read from left to right [message #1685328] Wed, 18 March 2015 20:08 Go to next message
David Embry is currently offline David EmbryFriend
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.

Re: Getting Data to read from left to right [message #1687510 is a reply to message #1685328] Thu, 19 March 2015 17:38 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
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
Re: Getting Data to read from left to right [message #1687632 is a reply to message #1687510] Thu, 19 March 2015 18:38 Go to previous messageGo to next message
David Embry is currently offline David EmbryFriend
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.
Re: Getting Data to read from left to right [message #1687710 is a reply to message #1687632] Thu, 19 March 2015 19:15 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
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
Re: Getting Data to read from left to right [message #1688468 is a reply to message #1687710] Fri, 20 March 2015 19:25 Go to previous messageGo to next message
David Embry is currently offline David EmbryFriend
Messages: 3
Registered: March 2015
Junior Member
Version 3.7.1. I'd be so appreciative if you could help. Thanks!
Re: Getting Data to read from left to right [message #1688474 is a reply to message #1685328] Fri, 20 March 2015 19:41 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
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.


Michael

Developer Evangelist, Silanis
Previous Topic:Unable to find the connection profile reference by DS connection properties in BIRT report
Next Topic:jdbc connection profile problem
Goto Forum:
  


Current Time: Thu Jul 18 01:25:12 GMT 2024

Powered by FUDForum. Page generated in 0.04209 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top