Home
Analytics
Display Empty Table message when there is no record in Table
KavithaD
Hi All,
I want to Display Empty Table message when there is no record in Table.I tried with Visibility for table row I couldnt achieve.I am attaching sample.
Thank you,
Kavitha
Find more posts tagged with
Comments
thuston
<a class='bbc_url' href='
http://www.birt-exchange.org/org/forum/index.php/topic/20094-how-to-check-whether-the-resultset-of-a-query-is-null/'>I
just answered this.</a><br />
<br />
row.__rownum >= 0
johnw
<a class='bbc_url' href='
http://digiassn.blogspot.com/2007/03/birt-hide-report-table-when-no-data-is.html'>Walkthrough</a>of
how to do this. You will need to add an aggregation (in my walkthrough, it was for an older version of BIRT where the Total.* aggregations were still present, so just replace that with a count aggregation). You have the right thinking of using a Visibility property.<br />
<br />
John<br />
<br />
<blockquote class='ipsBlockquote' data-author="'KavithaD'" data-cid="66642" data-time="1279799823" data-date="22 July 2010 - 04:57 AM"><p>
Hi All,<br />
<br />
I want to Display Empty Table message when there is no record in Table.I tried with Visibility for table row I couldnt achieve.I am attaching sample.<br />
<br />
<br />
Thank you,<br />
Kavitha<br /></p></blockquote>
KavithaD
@thuston
:: row.__rownum >= 0 Doesn't work for me
@johnw
:: i am using jdbc data source.with out using any variable cant we do it using table or label visibility?
Please help me .
Thank you,
Kavitha.
thuston
<blockquote class='ipsBlockquote' data-author="'KavithaD'" data-cid="66703" data-time="1280123880" data-date="25 July 2010 - 10:58 PM"><p>
@thuston
:: row.__rownum >= 0 Doesn't work for me <br /></p></blockquote>
<br />
It only works in the Header (and maybe footer). No rows == no Detail rows created.<br />
Right-click the Header row and Insert - Row - Below.<br />
Use my Visibility expression in this second Header Row.
johnw
The link is an example of how to do it. You can replace the expression that uses the report parameter with any expression, be it a value of a database, or a value of a table level binding, in the case that you need, the value of the Count aggregation.<br />
<br />
<blockquote class='ipsBlockquote' data-author="'KavithaD'" data-cid="66703" data-time="1280123880" data-date="25 July 2010 - 10:58 PM"><p>
@thuston
:: row.__rownum >= 0 Doesn't work for me <br />
<br />
@johnw
:: i am using jdbc data source.with out using any variable cant we do it using table or label visibility?<br />
<br />
Please help me .<br />
<br />
<br />
Thank you,<br />
Kavitha.<br /></p></blockquote>
KavithaD
Thank you thuston and johnw.
Your suggestions are working
