Guys..I have developed a report using grouping..which displays some blank rows unnecessarily. Can you pls tell me how to get rid of those blank rows..pls http://www.imageupload.org/?d=B1CE6B821

Hi, Go to the Left Most cell of that particular row right click 'ROW Visibility' there is a tab called " Hide " you need to give the expression in it. =!Field.value IS Nothing Thanks, FUN BI

Thanks a lot guys for the quick reply.. @Igor..If I delete those rows..then my report is getting messed up..dont know why.. @FunBI..I am trying your solution..I went to the left most cell..right clicked it..in Tablix properties..I went into visibility..in the Show or hide based on an expression..I wrote.. =!Field.value IS Nothing..but I am getting an error..can you tell me if I am writing the code right..or I am making a mistake..

@Rockstar: =!Field.value Is nothing means !Field.Value the Field you want to make it invisible not the literal words Field. if your row field is named as production plant then it would be =!Fields.Productionplant.Value IS Nothing Thanks, Fun BI

Hi, Those blank rows are group headers. In order to remove them right click the leftmost blank cell in the row to be deleted and choose delete row.Remember to mark as an answer if this post has helped you.

Thanks a lot guys for working out for me..I really appreciate that..Thanks to my Noob knowledge..I remember adding the group headers while creating groups..Is there any way to disable or remove those headers now?

Hi rockstar823, In order to remove the group header, you can right-click on the group field and select “Split Cells”(the cell is divided into two cells ). After that, you can delete the extra row, and then fill the field in the new cell. If possible, you can try to design a new report. Please note that don’t select the “Add group header” checkbox when you add a group. For more information about Adding Grouping and Totals, please refer to the article below: http://msdn.microsoft.com/en-us/library/ms170712.aspx Thanks, Bin Long

Hi rockstar283, In the picture that you posted above, it seems that you add a group header when you add a group. Right? On my local machine, I tried to reproduce this issue. Here are the screenshots: Without group header: Include group header: If I have something misunderstood, please point out and post the structure when you design your report. If possible, please post the report(.rdl file) to the following E-mail address, and then I will try to reproduce this issue and assist you resolve it. E-mail: sqltnsp AT Microsoft.com (Please replace AT with @) (Note: Please begin with “Hi, Bin Long” in the body of E-mail) Thanks, Bin Long

Hi , Can u Paste your Report Layout Design here. It Looks more than Hiding a Row .Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://mycubeandreports.blogspot.com/

extremely Sorry for the nooby doubt mate..but =!Fields.Productionplant.Value IS Nothing is not working either..e.g. in my case..you can see in the attached snapshot..you can see the blank lines I want to omit..so I went into the first blank cell under the product (number) column..and in visibility I put..=!Fields.PRODUCT_NUMBER.Value is Nothing..but when I do that I get an error saying..The hidden expression for the textbox contains an error..Leading '.' or '!' can only appear inside a WITH statement..Can you please help me a little bit more.. http://img146.imageshack.us/img146/5513/unledonx.png