Print empty lines when value in detail is null

What's your BIRT version?

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109369" data-time="1347636884" data-date="14 September 2012 - 08:34 AM">
What's your BIRT version? </blockquote>
Hi Williams, 
Mu version is 3.7.0v20110602 
 
Thanks in advance,

Take a look at this.

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109435" data-time="1347902693" data-date="17 September 2012 - 10:24 AM">
Take a look at this. </blockquote>
 
 
This is what I need. Could you explain what you did? 
I see 5 rows with empty labels. How do you count to display them or not? 
 
Thanks in advance!

Take a look at the aggregation in the sub-table and at the visibility expression for each of the blank rows.

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109775" data-time="1348624556" data-date="25 September 2012 - 06:55 PM">
Take a look at the aggregation in the sub-table and at the visibility expression for each of the blank rows. </blockquote>
Williams, thanks. 
I did, but I've one issue: 
When my detail is empty, meaning no rows at all in the detail table, then the empty rows are not being displayed. At the other hand when I've rows in the detail, the empty rows are being displayed correctly. 
I've explored in your example to find out if you do any additional when the aggregation is null or 0, but I didn't find any thing. 
Any ideas how you do this? In your example everything works smooth! 
 
Thanks in advance!

Make sure the extra rows are in the table footer, not the detail. If there are no detail rows, the footer will still show. The detail will not, so no matter what you do, you won't see extra detail rows.

Hi MWilliams, 
 
I have a similar requirement, but the difference is that I need to insert additional Detail Rows within each Table-Group as if it came from the data-set, in addition to the actual data-set rows. This is to ensure that I always get a set of detail-rows in which I can push some pre-defined values. 
 
The higher purpose of this is that I want to prepare a chart on the aggregates based on the values in the complete set of rows (including data-set rows as well as the pre-fixed rows). 
 
For example, see the data in the below image. The dummy rows marked in yellow are inserted manually under each Key_Field (M-1,M-2), so that the ultimate grouping would get all the bucket values (B-1,B-2,B-3,B-4) with counts of Field_2 and Field_3 against each of these buckets. 
 
file:///D:/writable/BIRT/samples/extrarows.png 
 
 
Hope I could detail my requirement clearly. 
 
Please provide a lead. Thanks.

Not sure what happened with your upload. Can you try again?

I am not getting any link for attaching the image, so tried inserting in the editor where it asks me for a URL.

Click on "add reply" rather than trying to use the "fast reply". After you choose the attachment file, be sure to select attach this file before adding the reply.

Thanks. Attached now. 
 
<blockquote class='ipsBlockquote' data-author="'shyamgoda'" data-cid="109920" data-time="1348765077" data-date="27 September 2012 - 09:57 AM">
Hi MWilliams, 
 
I have a similar requirement, but the difference is that I need to insert additional Detail Rows within each Table-Group as if it came from the data-set, in addition to the actual data-set rows. This is to ensure that I always get a set of detail-rows in which I can push some pre-defined values. 
 
The higher purpose of this is that I want to prepare a chart on the aggregates based on the values in the complete set of rows (including data-set rows as well as the pre-fixed rows). 
 
For example, see the data in the below image. The dummy rows marked in yellow are inserted manually under each Key_Field (M-1,M-2), so that the ultimate grouping would get all the bucket values (B-1,B-2,B-3,B-4) with counts of Field_2 and Field_3 against each of these buckets. 
 
file:///D:/writable/BIRT/samples/extrarows.png 
 
 
Hope I could detail my requirement clearly. 
 
Please provide a lead. Thanks. </blockquote>

You're probably looking at a joint dataSet. If you're using SQL and can access all of this data in a single dataSet, you can probably just write a slightly more complex query to add the rows to your dataSet instead.

Hi Williams,

I thought of extending the data-set, but the problem is that I wouldn't know how many Key-Field values would come out of the main dataset (M-1, M-2, M-3, .....), so it becomes difficult to add the additional rows in the data-set for each of the M-X groups.

Let me know another way by which I can add a fixed number of additional rows within each group, so that at least one record for each bucket (B-1, B-2, B-3, B-4) would exist under each M-1, M-2, etc. The difference here against the earlier depiction is that I will always add 4 rows for each group, irrespective of the Bucket values obtained from dataset and the gaps therein.

Thanks.

Using a scripted dataSet to take the values from the original dataSet, then add the necessary fixed rows would work. You'd just use the onFetch of your original dataSet to store your resultSet into an array. Then, you'd use this array to create a scripted set, adding rows where necessary.

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109967" data-time="1348836040" data-date="28 September 2012 - 05:40 AM">
Using a scripted dataSet to take the values from the original dataSet, then add the necessary fixed rows would work. You'd just use the onFetch of your original dataSet to store your resultSet into an array. Then, you'd use this array to create a scripted set, adding rows where necessary. </blockquote>
 
Thanks, I was looking for such solution. Please direct me to some samples of scripted dataSet.

Here is a devShare post showing a scripted dataSource:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/544-sample-birt-scripted-data-source-example/

Williams,
I observed that some posts have been omitted in this topic.
I had an additional question about the footer in a report.
In my table footer I've a a detail table, that I want to display on every page.
Last week you told me that it is not possible to repeat the footer of a table on every page, because this is only being displayed at the end of the table ( on the other hand, a header of a table presents itself on each page)

You gave me two options:
to make us of the master page footer. Since I'm using master detail between two tables I'm not able to use this alternative

You also gave an option to present the exact number of rows on each page and then the footer would present itself on each page. (not exact your words, but in this direction you reacted)

Could you explain the number of row being presented in the tables in more detail?

many many thanks!

Sorry for interrupting into the main query of RaniAg. I just wanted to inform that I was able to resolve my query for additional dummy rows through SQL itself as advised by Williams (little more complex, as you said it). Thanks a lot.

<blockquote class='ipsBlockquote' data-author="'RaniAg'" data-cid="110028" data-time="1349098480" data-date="01 October 2012 - 06:34 AM">
Williams, 
I observed that some posts have been omitted in this topic. 
I had an additional question about the footer in a report. 
In my table footer I've a a detail table, that I want to display on every page. 
Last week you told me that it is not possible to repeat the footer of a table on every page, because this is only being displayed at the end of the table ( on the other hand, a header of a table presents itself on each page) 
 
You gave me two options: 
to make us of the master page footer. Since I'm using master detail between two tables I'm not able to use this alternative 
 
You also gave an option to present the exact number of rows on each page and then the footer would present itself on each page. (not exact your words, but in this direction you reacted) 
 
Could you explain the number of row being presented in the tables in more detail? 
 
many many thanks! </blockquote>
 
Sorry. I moved it off to a new topic, since it was unrelated to the topic in this thread. Here's the link: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/27906-show-footer-data-at-the-bottom-of-each-page/'>http://www.birt-exchange.org/org/forum/index.php/topic/27906-show-footer-data-at-the-bottom-of-each-page/</a>