Hello all, I have a report that shows branch information for a number of cities. The data in the report has been grouped by the city field and each city field relates to a number of rows. Now each row has its border visible with a certain color. For city column, the first row has the data and rest of the rows the boxes (since the borders are visible) have no data. I want to change it so that there won't be any empty boxes in the city column. So basically the bottom border of the city field won't be visible untill all its relevant data in other columns are shown. Please let me know how I can do it. Thanks.

Hi Ryan_XH, According to your description, I understand that we don’t want any empty textbox (if the city field is null) to be displayed, right? Please connect me if my understanding is wrong. In this case, please try the following steps as below. - Select the row handle which have city filled - Expand Visibility node in Properties Window - Click “fx” button from Hidden dropdown list - Type in the expression: =Iif(Isnothing(Fields!City.Value),true,false) And then, if City value is null, all the entire row will become invisible. If you have any question, please feel free to ask. Thank, Eileen