web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... How to use a flowfield...

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

Suggested Answer

How to use a flowfield in requestfield from report?

(0) Share

Report

Report

Posted on by InsertX

450

Hi,

So i've created a report that has to contain some requestpage fields. Now i've created 2 fields that are dates just by using global variables.

Now i also want to to make sure they can select the currency by using a flowfield based on the Currency table.

In what way can i implement this?

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

divyeshchitte 970 on at

Like (0)

Report
Copy link

Link copied!

You can apply the SetFilter on "DATE FILTER" in Currency Table and obtain the Output.

Can you please elaborate more to provide you detailed answer.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you elaborate more on what you are trying to do ?

Do you want to select the currency ? If yes, why use flowfield ?

Was this reply helpful? Yes No
InsertX 450 on at

Like (0)

Report
Copy link

Link copied!

I actually might be mistaken about using a flowfield. So what i am trying to do is:

You can add options to your requestfields of your report. Now at the moment i have 2 fields in there where i can select a date. Now I want to add a third field where i can pick one of the values in the Currency table. So when i click the field the Currency table with all it's stored lines should appear like you would be using a filter.

Was this reply helpful? Yes No
Suggested answer

divyeshchitte 970 on at

Like (0)

Report
Copy link

Link copied!

to do this

1) Add new variable CurrencyCode: Code[20]; in the report

2) Add field in request page and give TableRelation. You can use this CurrencyCode var in report to filter the records.

field(CurrencyCode;CurrencyCode)

{

TableRelation = Currency.Code;

}

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,386 Super User 2026 Season 1

#2

YUN ZHU 1,774 Super User 2026 Season 1

#3

AndrewThomas81 1,515

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans