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

How to separate Rupee from cents in Rdlc

(0) Share

Report

Posted on by Beginner Dynamics 3...

Hello,

I have the above report to design and I am facing with only this difficulty. How can I separate rupees and cents. I have 2 columns separate in terms of rupees (Rs) and cents (cts).

I want an amount which include cents in it to display in the cts column. Like if I get 200.36, the 200 should display in Rs column and 36 in cts column.

Will be grateful if someone can guide me how to do it!

Thanks in advance

Categories:

Dynamics 365 Business Central

All responses (6)

Answers (0)

Suggested answer

Amit Baru 3,029 on at

Like (1)

Report

RE: How to separate Rupee from cents in Rdlc

Hi,

Pls refer the below link for more clarity

https://erpconsultors.com/convert-amount-into-words-in-d365-bc/

Amit Sharma

www.erpconsultors.com
Suggested answer

Nitin Verma 21,544 Moderator on at

Like (1)

Report

RE: How to separate Rupee from cents in Rdlc

Hi,

In that case you need to re-design that report, open with Report builder and do the mathematic function in that report it self.

You can find out those functions when you do the report design, also you can use Expression property to change the values of Text field in RDLC design.

Thanks.
Beginner Dynamics 3... 95 on at

Like (0)

Report

RE: How to separate Rupee from cents in Rdlc

Actually I am customizing a report and I am using the general journal line as the dataitem.

So, I have not created any table or page.

I have just created a new report where the dataitem is general journal line

So in the picture, this is the layout.

And this report will be added as an action in the payment journal where the amount lcy will be reflected in the column Amount. But the issue here is, I have to find a way to separate the cents and make it display in the cts column

So in all, I won't get to add it into OnAfterGetRecords because I have not created any page.

Thanks to help me further.
Suggested answer

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: How to separate Rupee from cents in Rdlc

It should be probably added on Line level, when are actually getting the prices, and use OnAfterGetRecords of that dataitem.
Beginner Dynamics 3... 95 on at

Like (0)

Report

RE: How to separate Rupee from cents in Rdlc

Hello Mr Nitin.

Thank you for the reply.

Gladly if you can tell me where should I write this.

On trigger pre(report) or in the textbox properties?
Suggested answer

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: How to separate Rupee from cents in Rdlc

Hi,

You can use some standard functions to cut your values.

youramount := 200.36;

message('%1',youramount div 1);

Answer is = 200

message('%1',amount * 100) mod 100);

answer is = 36