Skip to main content

Notifications

Announcements

No record found.

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

report going into infinitive loop

Posted on by 20

Hi,

I am calling one stored procedure inside the report. below is a snapshot of the report.

when I am executing this report then, the system is calling CallProdedur1 again and again. I want to call this function one time only. why its heppeining?

pastedimage1653721398029v3.png

  • Ghanshyam2402 Profile Picture
    Ghanshyam2402 20 on at
    RE: report going into infinitive loop

    Thanks Nitin...i got the reference from your answer.

    I set the MaxIteration as 1 in DataItem property and its working for me.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: report going into infinitive loop

    Hi,

    There can be multiple reason, the first one is Integer table can be run Infinite loop if you will not put a specific row count condition or Sertableview with filter some values on Integer Data Item.

    Also If you dont want to provide any settableview on Integer Data Item, please use OnPreDataItem trigger of Integer DataItem table to run witha specific no. of rows count.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans