Small and medium business | Business Central, N...

Removing a row of zeros while designing RDLC Report

(0) Share

Report

Posted on by M Saravanan

281

Dear Members,

I am currently trying to design a RDLC report. When I am trying to do so, I can notice that a row of zero appears from nowhere in my RDLC report which is actually not present in my design. I had attached the screenshot for your reference.

I had tried various other methods to remove it, yet I am unsuccessful.

Please do help me out by providing your valuable suggestions and solutions in removing out the row of zeros.

Thanks in Advance,

M Saravanan

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Removing a row of zeros while designing RDLC Report

Hi,

Right click on the text box you have in your report and follow with below image.
Suggested answer

NAV_with_Narang 2,236 Super User 2024 Season 1 on at

Like (0)

Report

RE: Removing a row of zeros while designing RDLC Report

You'll right click on the text box > press expression and then surround your expression with the function suggested by Nitin
Suggested answer

TabrezAjaz 190 on at

Like (0)

Report

RE: Removing a row of zeros while designing RDLC Report

As nitin suggested,

The further answer for your question:

* Look for the row, and set visibility at row level based on the expression.
M Saravanan 281 on at

Like (0)

Report

RE: Removing a row of zeros while designing RDLC Report

Dear Nitin Verma,

Thank you so much for your response.

I would like to know where should I insert the above expression.

Could you please suggest it.?

Thanks in advance,

Saravanan M
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Removing a row of zeros while designing RDLC Report

Hi You can try with Text field > Expression with this =Code.BlankZero(Yourfields.value)