Hide a grid row if the table inside this row is empty

HI Everyone,
 
I am using Eclipse Mars.1 Release (4.5.1) and BIRT 4.5.0.
 
My report has a grid with some rows. Each grid row contains a table. To set the Visibility of a table I use an Aggregation. If the table is empty the table is not visible.
 
But how can I hide the grid row, if the table inside this row is empty ?
 
Thanks in advance.
Johann

Find more posts tagged with

Comments

icirillo

Hi Johann,
 
please look at the following solution:
 
<a data-ipb='nomediaparse' href='https://www.eclipse.org/forums/index.php/t/218294/'>https://www.eclipse.org/forums/index.php/t/218294/</a>
 
It should also work for grids if you create the count aggregation in the column bindings of the grid instead of in the column bindings of the table.

JohannJ

Hi Ivano 
thanks for your reply, but it doesn't work in my case. 
Look at the adapted example (norowsWithGrid.rptdesign). 
In this example there is a grid "GridChapter" with no data set and two rows. 
In every grid row there is a table "Table1" and "Table2" with a column binding "MyRowCount". If a table is empty the table is not visible, but the grid row is still visible. 
I don't know how the column binding for the grid rows should look like in a grid with no data set. 
Do you have any idea ? 
Thanks in advance. 
Johann

pricher

Hi Johann,
 
Because the grid is created before the tables, you cannot control the grid visibility based on an aggregation at the table level. You need to bind your data set to the grid, create an aggregate at that level, and use that aggregate to control the visibility of a grid row.
 
In the attached example, the first row of the grid will not be displayed when the data set returns nothing.
 
Hope this helps,
 
P.

JohannJ

Hi Pierre 
thanks for your help. 
You are right, it couldn't work.

In your example the grid and the table inside this grid uses the same data set, so I think it only works if the grid and all the tables inside the grid uses the same data set / database table. 
In my case the report contains several chapters. Each chapter contains one grid with several tables with different data sets / database tables. The reason why I use grids is to easy switch the visibility of each chapter (grid) in my report. 
I think I have to change my report design.
 
Thanks
Johann

icirillo

I Johann,
 
with the attached example it works as you wish but it is needed to duplicate the tables. Why we need to duplicate the tables is because if you don't put a hidden table at the beginning of the report then the datasets will not load the data before the grid is rendered but after the grid is rendered then the "count variables" defined in the initialize method of the report will be equal to zero and will not be useful to hide the grid lines. I don't think there is a better solution also according to the following thread:
 
<a data-ipb='nomediaparse' href='https://www.eclipse.org/forums/index.php/t/240097/'>https://www.eclipse.org/forums/index.php/t/240097/</a>

JohannJ

Hi
 
Perfect, it works.
Thank you very much for your help
 
Thanks
Johann