Calling global variable on main table doesn't work

AlbertYu

Hi,

Just wondering why my call to a global variable via the command:

reportContext.getPersistentGlobalVariable(BirtStr.concat(row["APP_COMPID"], "deployed"))

does not work.

I have set this global variable on the onCreate script of a sub table's row element script, by the following:

reportContext.setPersistentGlobalVariable(BirtStr.concat(row["APP_COMPID"], "deployed"), "show");

When I try calling this command on a sub-table's column, it works fine.

It just doesn't work when I try calling it on the main table's row.

The sub-tables are linked to the main table through a data set parameter binding - the parameter being Focus_App_CompID and the value being row["APP_COMPID"]

Can anyone help please?


Thank you,

Albert

johnw

They are at two different points in the report generation cycle.
You can't really have a child tables value show in the parent row. Not sure why you would need to, why not just display the child tables value.

If you really need to, a better way would be to have a hidden table at the top that sets a global map with the value you want. This is done in the onFetch method of the data set. This way, your not executing a query for every row in the table, you only execute two queries for the report, one that drives the map, and the main one. In the main table, I just pull the map and lookup the value based on the key.

I have attached an example. In it, you can see that the global variable will never be the correct value in your current row if set in the sub-table.