Empty space in RDLC Report

IvonaK

Hi to all,

I have made a Report and I put code on Visible tab on Details Group. (picture 1)


also I put code in Filters (picture 2)


but there is still empty space

Any advice,
Thanks

RockWithNAV

Hey Ivonak,

There could be many possibilities for the blank rows, You need to identify first the structure you designed and the data you are getting from the Data-set. First you should execute the Report and check About this Page of the Report (Execute twice as it starts first time). Identify here what exactly are the Data's you are getting and match this with your Report Outcome. Check is there some blank lines coming from Data-set Itself.

Once you will analyze this, you will easily understand the cause and what exactly to implement either the Row Visibility Condition or the Filters.

Thanks
Blog - https://rockwithnav.wordpress.com/

IvonaK

Hi ,

My empty space is coming from Row Visibility, because I have some rows that have value 0 , and I don't want to show them.

Thanks,
Best Regards,

RockWithNAV

Hey IvonaK ,

In that case you can simply select that row - Select the Row Visibility Option and write -
=IIF(Fields!XYZ.Value>0,False,True)


Thanks
Blog - https://rockwithnav.wordpress.com/

lakshanvindana

can I see the Report Dataset Designer please?

IvonaK

Hi to all,

I resolve the problem. The empty space was from this code that I put in Visible propertis (picture 3)



When I remove the code and put code like picture 4



it works

Thanks a lot,