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

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Beginner Dynamics 3... 95 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Beginner Dynamics 3... 95 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Pls refer the below link for more clarity

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

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No