Skip to main content
Business Central forum
Suggested answer

Pass FlowFilter from RDLC report to flowfield

editSubscribe (0) ShareShare
ReportReport
Posted on by 2,166

Hi

I have flowfilter (date) defined in a flowfield. I'm trying to pass the the date filter when running a report so based on the date selected by end user, the flow field data is filtered:

Flow Fields on table

        field(60003; Balance; Decimal)

        {

            FieldClass = FlowField;

            CalcFormula = sum("G/L Entry".Amount

                                                            WHERE(

                                                                  "Global Dimension 2 Code" = FIELD(Code),

                                                                  "Posting Date" = field(DateFilterP1)

 

                                                            ));

            Caption = 'Balance';

        }

 

        field(60400; DateFilterP1; date)

        {

            Caption = 'Date Filter';

            FieldClass = FlowFilter;

        }

 

Report

 

                    trigger OnAfterGetRecord()//GL Entry

                    var

                        DimValue: Record "Dimension Value";

 

                    begin

                        begin

                           

                        end;

                        begin

                            DimValue.SetRange(Code, "Global Dimension 2 Code");

                            DimValue.SetFilter(DateFilterP1, '%1..%2', 20220501D, 20220610D);//'%1..%2',

                            if DimValue.FindFirst() then

                                DimValue.CalcFields(Balance);

 

                            StartDim2Balance := DimValue.Balance;

                        end;

Categories:
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,984 Super User on at
    RE: Pass FlowFilter from RDLC report to flowfield

    what is the error you are facing? please share your report here.

  • Samantha73 Profile Picture
    Samantha73 2,166 on at
    RE: Pass FlowFilter from RDLC report to flowfield

    the above code doesn't work or I cannot pass the flowfilter from report to flowfield. Couldn't find a standard report with an example - perhaps someone can point me to a standard report

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,984 Super User on at
    RE: Pass FlowFilter from RDLC report to flowfield

    Hi,

    What is the your question?

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans