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

Expressions in RDLC Report of BC

(1) Share

Report

Posted on by BBC_Astha

160

I am a beginner and learning on my own, While playing around with existing reports. I came across this expression

=Cstr(Choose(12,Split(Cstr(ReportItems!HeaderValue.Value),Chr(177))))

I am able to understand the most of the functions but what is 12 in here similarly in following expression

=Cstr(Choose(26,Split(Cstr(ReportItems!HeaderValue.Value),Chr(177))))

is it related to columns of the table, if that is the case how will i know which number is mapping to which column name?

I tried to map the columns value of report to the main table ID, it is not same? What am i missing

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 24,227 Most Valuable Professional on at

Like (0)

Report

Expressions in RDLC Report of BC

Hi

Maybe this can help you and give you some hints

How Do I Use SetData and GetData in Microsoft Dynamics NAV 2013 R2 (youtube.com)

Best regards

Gerardo

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 94,448 Super User 2025 Season 2 on at

Like (0)

Report

Expressions in RDLC Report of BC

Hi, here is a simple explanation that I hope will give you some tips.

https://www.youtube.com/watch?v=wap76SJ95lM

For a brief description, the n-th field in the group of defined fields, such as the following example, (8,1) is WhseShptHeader_PostingDate.

=Code.SetData(Cstr(Fields!CompanyInfo_Name.Value) + Chr(177) +
Cstr(Fields!WhseShptHeader_ShptDate.Value) + Chr(177) +
Cstr(Fields!WhseShptHeader_No.Value) + Chr(177) +
Cstr(Fields!WhseShptHeader_ShipmentNo.Value) + Chr(177) +
Cstr(Fields!WhseShptHeader_LocName.Value) + Chr(177) +
Cstr(Fields!SalesHeader_SellToCustName.Value) + Chr(177) +
Cstr(Fields!SalesHeader_ShipToAddr.Value) + Chr(177) +
Cstr(Fields!WhseShptHeader_PostingDate.Value) + Chr(177) +
Cstr(Fields!OutboundType.Value)
, 1)

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report

Expressions in RDLC Report of BC

Hi,

The Choose function uses the first parameter as the index of one of the remaining function parameters. The first argument must be an integer.

You can refer to the blog about RDLC report functions:

https://topic.alibabacloud.com/a/rdlc-report-functions_8_8_31488740.html

Best Regards,

Judy

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,672 Moderator on at

Like (0)

Report

Expressions in RDLC Report of BC

Here's some good Learn stuff:

Build reports for Microsoft Dynamics 365 Business Central - Training | Microsoft Learn

Here's an amazing training:

Webinar Reporting with Microsoft Dynamics 365 Business Central | Plataan.TV

Training Microsoft Dynamics 365 Business Central, Dynamics 365 NAV, Dynamics 365 CRM, Power BI, Office 365 | Plataan.TV

Business Central Booster | Case-Based Learning | Plataan

Was this reply helpful? Yes No