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

Removing a row of zeros while designing RDLC Report

(0) Share

Report

Posted on by M Saravanan

254

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)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

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

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,390 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Was this reply helpful? Yes No