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

Removing a row of zeros while designing RDLC Report

(0) Share

Report

Posted on by M Saravanan

244

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
M Saravanan 244 on at

Like (0)

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

Was this reply helpful? Yes No
Suggested answer

TabrezAjaz 202 on at

Like (0)

Report

As nitin suggested,

The further answer for your question:

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

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,294 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No