Resetting a variable on change of group

The report I am trying to do groups lists appointments with their statuses so they are grouped by the appointment ID and different rows contain the different statuses such as "Checked In" "In Room" etc.I am trying to save detail data into a varible to use at a group level. I initialize the variable in onInitialize method for the report.At the detail level I am doing this to populate the value: if (this.getRowData().getColumnValue("Scheduling Action") == "CHECKIN") checkinTime = this.getRowData().getColumnValue("Action Date and Time"); The above works fine, the problem I am having is resetting the variable. I have tried doing it in the onPrepare, onCreate and onRender methods for the appointment Id group I am using. Any ideas would be appreciated. I am still pretty new at this. I am using BIRT version 3.7.2.

Find more posts tagged with

Comments

BRM

So what you are saying is that if the variable gets set to "****" in one of the detail rows it will retain that value when used in the footer even if a subsequent row would cause it to be set to some other value? Not sure but using variables across elements of reports like this seems like a job for PGV's. You might try if (this.getRowData().getColumnValue("Scheduling Action") == "CHECKIN"){ temp_var = this.getRowData().getColumnValue("Action Date and Time"); reportContext.setPersistentGlobalVariable("checkinTime", temp_var);} Then in the footer or wherever else you wanted to use the value you would do:myVar = reportContext.getPersistentGlobalVariable("checkinTime")

bakinzer

BRM I found a different way to do what I needed using data elements at the detail level and aggregations at the group level. I still want to see why the original way I did didn't work so will try your suggestion of using a PGV. One thing though, your statement:"So what you are saying is that if the variable gets set to "****" in one of the detail rows it will retain that value when used in the footer even if a subsequent row would cause it to be set to some other value?"should not be a problem. Any time the varialble would get set it is set to something I need. The problem is that I can't unset it when I start a the detail for a new group. If the detail for that group doesn't have the condition the variable retains the value from the previous group.