Approach to convert number into text (SSRS report body to footer)

(0) Share

Report

Posted on by Oleg_Sokol

Hi everyone!

I'm working on SSRS report that is very similar to CashBook_LV. But in my customization, I need to display in words number of rows in report body tablix.

For now, my approach is to write DataMethod C# code in the SSRS report. But, I want to use my x++ classes and static methods to achieve my goal.

Because, in the near future we will migrate from ax2012 to ax7, and I need reduce concomitant work with this.

Thanks for answers.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Oleg_Sokol 35 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

I resolve this by using AIF Custom Service . Witch I call from Data Method in SSRS report.

Was this reply helpful? Yes No
Oleg_Sokol 35 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

Good day JMD Technolojii!

As I understand, this part relates to DP class? Right?

In this part (processreport ()) you fill tmp tables. I do the same.

Have you an example of code to call X++ logic from SSRS report?

I found one here community.dynamics.com/.../212172 and here msdn.microsoft.com/.../bb986590(v=ax.50).aspx

but, it doesn't look good to write your credentials into code.

Was this reply helpful? Yes No
JII SAADUDDIN 1,832 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

Hi Oleg_Sokol.

I have had my example using Classes.

1. classDeclations.

2. Create 2 tmptables to call for declations.

3. processreport()

example:

header:

use ssrsdataproviderbase

---your code here

Was this reply helpful? Yes No
Oleg_Sokol 35 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

Tatian, thanks for your replay! But, using tmp table with fields in DP class for this purpose is not an option. Because (if you look at report that I mention earlier) lines in the body needed to be counted in the footer on each page, and printed in words.

So, this have to be runtime function in report. I've done it by C# code in Data Method, but I want to use X++ Classes for this.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Approach to convert number into text (SSRS report body to footer)

The DataMethod that you are using here is the BI C# project that you can find in the AOT.

If you want to use the X++ you need to work in the Classes that you created for build you report, If the report is query type, you need to add the method in the query to return what you need.

You need to add a new field in the temporary table and add the logic in the DP class to set the value.

After that call the field in the SSRS report

Was this reply helpful? Yes No
Oleg_Sokol 35 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

I want call it from designer. In the textBox enter, for instace, "numeralsToTxt(ReportItems!CountDebitAmount.Value)".

For this, I need to write some code into Data Methods on the report.

just like dill function

[DataMethod(), PermissionSet(SecurityAction.Assert, Name = "FullTrust")]

public static string DrillMainAccount(string reportContext, string mainAccountValue)

{

return DrillThroughCommonHelper.ToMainAccount(reportContext, mainAccountValue);

}

But I don't know how to get x++ code from there.

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

You can call it as the following

YourTableForReport.AstringTypeField = Global::numeralstotxt(AnyRealfield);

Was this reply helpful? Yes No
Oleg_Sokol 35 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

Maybe, I not clearly describe what I really mean.

I need to understand how to call this method from SSRS report DataMethod()? Could you give me a hint?

Was this reply helpful? Yes No
Mahmoud Hakim 17,887 on at

Like (0)

Report

RE: Approach to convert number into text (SSRS report body to footer)

There are standard method achieve that.

Just check global class , you can see method numeralstotxt

This method converts number to word , just call it in your report

msdn.microsoft.com/.../global.numeralstotxt.aspx

Was this reply helpful? Yes No