none
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

    Server

               Instance

                                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,

     

    true,false)

    But it doesn't help either.

     

    Can anyone help me in getting this done.

    Many thanks in advance

    Regards,

    Zainu

    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.

    Regards,

    Zainu

    Tuesday, December 21, 2010 8:56 PM