Setting a table cell visibility

Lesbea

Hello to all , I am a new user of Birt and have got on very well so far. However I need some help on this problem that is getting to me.

I have a dataset with some data in for a report
the data set has a field called XLINECLASS which is set to 'H' for header or 'S' for summary.
I have several fields which have values in i.e. XGBP , XEUR etc.

I have set a table up to have the fields from the data set including XLINECLASS which has been set to non-visible.

Ok with me so far.

Now my problem is that I do not want the cells XGBP XEUR on a row to be visible when the XLINECLASS value for that row is 'H'.

Could somebody work out the method to use, I have tried the function on a cell by setting hide cell to yes and using row["XLINECLASS] = 'S' to condition the cell but that does not seem to work for me

Do I need a script on the cell for onRender if so can sombody help on this please.

Many thanks to all you experts out there in advance.

birtq

Hi

Try this out :

Add this script in initialize.

importPackage(Packages.org.eclipse.birt.report.model.api);
importPackage(Packages.org.eclipse.birt.report.model.api.elements);

delm = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("ql");

hr = StructureFactory.createHideRule();
hr.setFormat("html");
hr.setExpression("if( row["XYZ"] =2 ){true;}else{false;}");
ph = delm.getPropertyHandle("visibility");
ph.addItem(hr);


Changes required in:

line 3: change "ql" to the name of the data cell where you want to hide/unhide data.

line 6: ( row["XYZ"] =2 ) to the required condition.

:-)
Regards,
birtq