Share via

Exclude empty rows in Report

Илья Листратенко 21 Reputation points
2020-08-29T14:27:28.963+00:00

I have a table in an RDL file.
Empty rows create due to the (Finish) field contains in sql query, (Finish) field not used in the main report.
Field (Finish) is used as a parameter to go to the subreport, I cannot delete it.
How to exclude empty rows (Finish), but leave a field to go to a subreport?

Sample report export to Excel 21314-image002.jpgfile.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-08-31T03:08:14.347+00:00

    Hi,
    Seem your image is not full, which is not quite clear which column you referred is empty.
    Normally, I would suggest to hide the row using visibility property
    Use :
    =Iif(IsNothing(<Your Fields>.Value),True,False)

    This method depends on your report design and you data. You could check this blog to see detail guide and help: Hide a row is a field is empty
    If you need further help, you could share more detail or full picture of your report design.
    Regards,
    Lukas

    0 comments