Script for removing rows

Hello everybody...I've started recently working with BIRT and run into my first real challenge

. I'm hoping that some seniors in the area can give me an easy solution.

Here it is...i have attached an example of the input data; the big challenge is to remove the lines 5 and 6 (the idea is that if i have two lines with columns A, B, D identical but one with "General" in column E and one with a value, i need to remove the "General" one - in a few words, specific configuration overwrites the generic one)

I was thinking to put a hidden column with a flag...0 and 1...and the script inside the column to mark the lines to be deleted with 1; then with a filter is easy. I just don't manage to make the script for this column.

Hope you have a clue for me. Thanks

Find more posts tagged with

Comments

mcremer

Were are you getting your data from?

If your using SQL I sugest creating a condition in yoru query.

If you still want 2 use it as it is. I sugest looking in the visabilety.

johnw

I don't see any condition where A, B, C, D are identical. But, to answer your question, if you did have that, you would need to have some sort of global persistent storage (I'm thinking a Java HashMap with a key, and a ArrayList or Array as the value) that gets initialized in either the initialize or beforeFactory method of the report. Populate it during the onFetch event in the dataset. Then either use a dataset filter, table filter, or as mcremer suggested, a visibility expression. The problem with this approach is that if you have a large data set, this can potentially get to be a very memory intensive operation.