Exclude empty rows in Report

Question

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 file.

Answer 1

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