Remove blank lines from Report

(0) Share

Report

Posted on by Community Member

Hello Experts,

I am developing a Report, in that i am using multiple tables. But in some table somewhere is data and somewhere not . So i want to Remove blank lines those are not having data. Please guide me ASAP.

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Rehan Satti 634 on at

Like (0)

Report

RE: Remove blank lines from Report

Have you tried to use

Use PrintOnlyIfDetail property of report data item

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Remove blank lines from Report

Hello Rehan,

I tried this. but its not working.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

RE: Remove blank lines from Report

Hi Manita,

Hope CurrReport.SKIP help you!

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: Remove blank lines from Report

Please apply the filter on the group in the report, to filter lines or apply Row Visibility Condition

docs.microsoft.com/.../add-dataset-filters-data-region-filters-and-group-filters

Was this reply helpful? Yes No
Suggested answer

Zaid Tariq 2,274 on at

Like (0)

Report

RE: Remove blank lines from Report

Well just click on the row from the tablix and go to row visibility,, Add a condition and it will work. If still not just share your Layout screenshot and Data-set, i will write you back the condition. Thanks

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

RE: Remove blank lines from Report

Dear manita,

Please follow my screenshots, your problem will be resolved 100%.

Was this reply helpful? Yes No
Suggested answer

Tina Menezes 2,582 on at

Like (0)

Report

RE: Remove blank lines from Report

Hi Manita,

You need to go to the 'Row visibility' of your details row of the table.

Select 'Show or hide based on an expression'.

Now enter the expression based on which the row must be hidden.

=Fields!FieldName.Value=""

Enter the name of the field based on which the row should be hidden.

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (1)

Report

RE: Remove blank lines from Report

Hello Manita,

for hiding a rows from RDLC -> Select whole row and then go for Row Visibility and then write in expression something:

=Fields!YourFieldName.Value=""

or you can use

=IsNothing(Fields!YourFieldName.Value)

For skipping the record that you don't want then write something in

OnAfterGetRecord triger

IF YourTableField = '' THEN Currreport.SKIP;

Was this reply helpful? Yes No