Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Horizontally growing table with groups
Hablaaja
<p>Hi,</p><p> </p><p>I need to create a table like:</p><p> </p><p>
Find more posts tagged with
Comments
XFabien
<p>Did you try to create a date cube and add a crosstab to your report?</p><p> </p><p>And set the crosstab's orientation to 'vertical' that should be work for you.</p>
micajblock
<p>Search the DevShare for Inline</p>
Hablaaja
<p>Tried cross tab, but it didn't work correctly because it has no function to "line break".</p><p> </p><p>Searched inline measures and found one youtube video and tried to do this with lists which causes the "left headers" to show multiple times.</p><p> </p><p>Not found a good solution yet...</p>
micajblock
<p>Did you see this?</p><p> </p><p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/devshare/_/designing-birt-reports/705-multiple-columns-within-a-list'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/705-multiple-columns-within-a-list</a></p>
;
Hablaaja
<blockquote class="ipsBlockquote" data-author="mblock" data-cid="123043" data-time="1387312793"><div><p>Did you see this?</p><p> </p><p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/devshare/_/designing-birt-reports/705-multiple-columns-within-a-list'>http://developer.actuate.com/community/devshare/_/designing-birt-reports/705-multiple-columns-within-a-list</a></p></div></blockquote><p> </p><p>Yes
I did. It was pretty much OK, but with that all I got was like:</p><p> </p><p> | group1 | | g2 | | g3 |</p><p>| header1 | data11 | | h1 | d12 | | h1 | d13 |</p><p>| header2 | data21 | | h2 | d22 | | h2 | d23 |</p><p>| header3 | data31 | | h3 | d32 | | h3 | d33 |</p><p> </p><p>
page break</p><p> | g4 | | g5 |</p><p>| h1 | d14 | | h1 | d15 |</p><p>| h2 | d24 | | h2 | d25 | ETC......................</p><p>| h3 | d34 | | h3 | d35 |</p><p> </p><p> </p><p>When I need to have like</p><p> </p><p> | group1 | g2 | g3 |</p><p>| header1 | data11 | d21 | d31 |</p><p>| header2 | data21 | d22 | d32 |</p><p>| header3 | data31 | d23 | d33 |</p><p> </p><p>
page break</p><p> | g4 | g5 |</p><p>| header1 | d41 | d51 |</p><p>| header2 | d42 | d52 | ETC.............................</p><p>| header3 | d43 | d53 |</p>
micajblock
<p>This makes it much more complicated. A few questions:</p><p>1. Can you provide sample data to build an example from?</p><p>2. What version of BIRT are you using?</p><p>3. Are the number of columns fixed or is it dependent on the data.</p>
Hablaaja
<p>1. In what form would you like to that data to be... for example the data can be what ever like:</p><p> </p><p>groups are car models: bmw, audi, volvo, fiat, honda, toyota</p><p> </p><p>headers are just labels like: model, color, year</p><p> </p><p>so the rows you got from database could be like:</p><p> </p><p>1) bmw, 325i, black, 2013;</p><p>2) audi, RS4, yellow, 2012;</p><p>3) volvo, V70, blue, 2010;</p><p>4) bmw, M5, Orange, 2013;</p><p>5) fiat, stilo, brown, 2006;</p><p>6) honda, CRV, blue, 2009;</p><p>7) toyota, celica, green, 1994;</p><p> </p><p> </p><p>2. <report xmlns="<a data-ipb='nomediaparse' href='
http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design</a>"
; version="3.2.23" id="1"> </p><div> <property name="createdBy">Eclipse BIRT Designer Version 4.2.2.v201301221637 Build <4.2.2.v20130206-1509></property></div><div> </div><div> So that would be 4.2.2?</div><div> </div><div>3. The number of columns are dependent of the data.</div>
micajblock
<p>a CSV file would be great.</p>
Hablaaja
<p>Here you go !</p>
micajblock
<p>Not enough data to need a page break. Also what do you want in columns and what do you want as the rows, and lastly what is the measure (in the cell of the crosstab)?</p>
