Skip to main content



      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 16:08 Go to next message
Eclipse UserFriend
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 13:38 Go to previous messageGo to next message
Eclipse UserFriend
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
Re: Getting Data to read from left to right [message #1687632 is a reply to message #1687510] Thu, 19 March 2015 14:38 Go to previous messageGo to next message
Eclipse UserFriend
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 15:15 Go to previous messageGo to next message
Eclipse UserFriend
What's your BIRT version? I'll have something to you soon after I get that from you. Smile
Re: Getting Data to read from left to right [message #1688468 is a reply to message #1687710] Fri, 20 March 2015 15:25 Go to previous messageGo to next message
Eclipse UserFriend
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 15:41 Go to previous message
Eclipse UserFriend
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.
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: Tue Apr 15 06:02:55 EDT 2025

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

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

Back to the top