Hiding Crosstab

birtrac

Hi

We need to hide a crosstab in the BIRT Report if all the rows and columns have value 0 or NULL.
Somehow i am able to hide it if there is no data returned in the crosstab using NULL value for the Grand total column/row intersection cell. But doesnt work when the values are all Zeros.

Any suggestions , how that can be achieved.

Thanks.

cypherdj

Is the grand total column a field in your dataset or are you referring to the row area grand total in the crosstab properties?

If it's a field in your data set, the following would probably address your problem:

What you could do is in the beforeOpen script for the dataset bound to the datacube used to populate the crosstab, you would set a global persistent variable, let's call it showCrosstab, to true.

In the onFetch script for the very same dataset, you would then test the grand total value for null and set showCrosstab to false if that is the case.

Finally, you would set the visibility of the crosstab (in the editor properties) to the value of showCrosstab.