web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Report is repeating on...
Microsoft Dynamics NAV (Archived)

Report is repeating only one record in all pages

(0) ShareShare
ReportReport
Posted on by TNS 1,197

Hi Everyone,

When I am filtering my records in a request page default filter ... it is giving me the first report as many times as many records I have given in filter. e.g If I have given two records in a no. filter then it is taking the first record and giving me the report two times ... if i have given four then it will me report 4 times ... means the count of report is fine but its giving only first report..

4336.Untitled1.png

Like in fig I have selected two records in no. filter so i am getting the first record report two times... and not getting the second one ... 

If any one have any idea.. please let me know..

Thanks!

*This post is locked for comments

I have the same question (0)
  • Zaid Tariq Profile Picture
    Zaid Tariq 2,274 on at

    Can you shown me the report in dataset designer? Please post a screenshot.

  • TNS Profile Picture
    TNS 1,197 on at

    0245.Untitled2.png

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at

    I regret to tell you, but the report (and it is likely a custom report) is poorly written, and instead of looping on records or pages, it's looping on copies.

    A typical report (see Report 10074 for Sales Invoices) takes the dataitems, massages them, and then generates the output by running a Copy Loop, and within it a Page Loop, and within it the fields for the records.

    There is no simple fix. The current code is taking the count of records and using that integer value to drive the Copy Loop. The report developer will need to correct this - and perhaps he/she may be best served by rewriting it in a better thought out way.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    You need to check on layout how grouping is done on report . Is there any grouping ?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans