Disabling visibility of fields if value of a column = previous/next row

Hi there, 
 
In a query dataset, I would get records with repeated values for a majority of columns. The only difference is that for say 4-6 columns, the values for those columns are different. 
 
In report designing, I would like to have the visibility of the repeated values set to false based on certain conditions; e.g like if policy number of the current row is the same as next / previous row. 
 
I did try writing a condition expression for that, but it didn't work really. 
 
I used if (row["POLICY NUMBER"].value == row+1["POLICY NUMBER"]) 
 
I'm not sure whether if I got it wrong or is there any alternate solution to this? 
 
Thanks and regards, 
 
Melvin

Find more posts tagged with

Comments

mwilliams

Hi Melvin,

In your table, select the column that you're wanting to hide duplicates in, then go to the "General" section of the property editor and check the "Suppress Duplicates" checkbox. If I'm understanding correctly, this should solve your issue.

mmah

Dear Michael,

The 'Suppress Duplicates' checkbox helps but it solves one part of my problem.

Right now, after applying that option to the first column of my report, I would want the values in other select columns to have its visibility turned off if the value for the first column is showing nothing (being suppressed as it was a duplicate).

I did tried to put the expression like:

(BirtComp.equal(row["Q1_POL_NO"], "")==1) or the compareString method

However, there were a few occasions I got a ReportServiceApi Exception. In most times, the visibility is not working.

I would appreciate some help here really.

Thanks in advance,

Melvin

mwilliams

Melvin,

What version of BIRT are you using? I'll make a quick example of a way to do what you're wanting.