Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Too many Rows generate...
Small and medium business | Business Central, N...
Suggested answer

Too many Rows generated... please let me !

(1) ShareShare
ReportReport
Posted on by TL-04060938-0 50
I created report with AL language. and try to print report.
 
but the problem is too many rows generated as screenshot.
 
Can i reduce row generated and time to print?
 
Pleaseeeeeeeeeeee!!!!!!!
 
Categories:
Business Central
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,816 Super User 2024 Season 2 on at
    Too many Rows generated... please let me !
    As mentioned the best would be to add filters, it seems you're running this for all packing slips rather than only 1?
     
  • HeinKruger Profile Picture
    HeinKruger 40 on at
    Too many Rows generated... please let me !
    Besides adjusting the Filters you can add CurrReport.Skip() in the OnAfterGetRecord of the data Item. 
    For example 
    If Rec.Qty = 0 then 
    CurrReport.Skip
  • Suggested answer
    Saurav.Dhyani Profile Picture
    Saurav.Dhyani 17,965 Super User 2024 Season 2 on at
    Too many Rows generated... please let me !
    Hi,
     
    Make sure that in your report right filters are set.
     
    if there are multiple data items in the report, are they linked correctly?
     
    Regards,
    Saurav Dhyani
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 12,181 Most Valuable Professional on at
    Too many Rows generated... please let me !
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Too many Rows generated... please let me !
    Add filters when running the report or in the AL code if you always want to add filters.

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