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?
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;
}
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.
Can you elaborate more on what you are trying to do ?
Do you want to select the currency ? If yes, why use flowfield ?
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.
#1
André Arnaud de Cal...
294,325
Super User 2025 Season 1
#2
Martin Dráb
233,025
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
