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)
Problem with specific list
lukasw44
Hello <br />
I have got problem with my list. Actually i create list from database select, and i havent got any problem with that ...<br />
But i have got problem with show resoults. Now i have got somethink like that: <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>L.p | Type | text | description |
1. | Text |text1 | description 1 |
2. | Text |text2 | description 2 |
3. | Text |text3 | description 3 |
4. | Image |image1| description 4 |
5. | Image |image2| description 5 |
6. | Video |video1| description 6 |
7. | Video |video2| description 7 |
8. | Video |video3| description 8 |
9. | Video |video4| description 9 |
</pre>
<br />
But i need show this resoults like that : <br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
L.p | Type | text | description |
1. | Text |text1 | description 1 |
2. | |text2 | description 2 |
3. | |text3 | description 3 |
4. | | | |
5. | Image |image1| description 4 |
6. | |image2| description 5 |
7. | | | |
8. | Video |video1| description 6 |
9. | |video2| description 7 |
10.| |video3| description 8 |
11.| |video4| description 9 |
12.| | | |
13.| | | |
14.| | | |
15.| | | |
16.| | | |
17.| | | |
18.| | | |
19.| | | |
20.| | | |
</pre>
As you can see i have got:<br />
<strong class='bbc'>1.</strong> empty row beetwen two different types. <br />
<strong class='bbc'>2.</strong>Category is only in one line (first line)<br />
<strong class='bbc'>3.</strong> min resoults is 20 so when my select return only 10 next ten is empty rows. But if i have got more than 20 resoults i show all.<br />
<br />
How i can do that easy ? i am using birt 2.3.2 and eclipse plugin.<br />
<br />
plz help
Find more posts tagged with
Comments
kclark
Do you want all the results to be in the same table? If they don't need to be in the same table you can create three tables and filter out the other two types only showing Text in the first, image in the second, and video in the third. Then for the type you can quickly add a label and have the results output how you would like them to be as shown in your post.