Delete Blank Line in Report RRS feed

  • Question

  • Hi,

    I am using Report Viewer Control in VS2010. I need to create a report which like



                                DatabaseName    CreateDate  RecoveryModel Owner

                                                                                                                    File     FileGroup Drive SizeofFile


    So for this I have created 3 goups. Server.Instance and Database.For displaying the detals about file I have added a new line since I don't want to Group based on File.

    I have placed the textbox for File details.But the problem is it shows blank line after every file details.Something like this:

    master.mdf      PRIMARY      C:\       4

    blank line  here

    master.ldf       PRIMARY       C:\        1


    I don't want that blank line to appear there.I have tried wring an expression in the row visibilty propery of this new row as:

    =IIf(Fields!File.Value.ToString().Trim().Length = 0,



    But it doesn't help either.


    Can anyone help me in getting this done.

    Many thanks in advance



    Tuesday, December 21, 2010 3:04 AM

All replies

  • I just found that I am getting this blank row because I was using HideDuplicate rows. How can we remove this blank row created by HideDuplicate.



    Tuesday, December 21, 2010 8:56 PM