Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

issue on report

Posted on by 70

my custom report gives 2 copies of the invoice, the first one is correct but the second one has the invoice total, subtotal doubled

could anyone please help me on this ASAP .

comparing the subtotal from the 1st copy to the second copy its getting doubled , someone please help me on this !!!

Thanks in advance .

Regards,
Yathish

Categories:
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: issue on report

    The variable you got the sum in can have a different name. So i think you need to share the comple al code for your report.

  • Yathish JR Profile Picture
    Yathish JR 70 on at
    RE: issue on report

    when i searched for subtotal in my code , only those 2 lines are coming i dont know where its is getting calculated , Its not there

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,025 Moderator on at
    RE: issue on report

    Apart from label, I meant how it calculating the values, also you need to clear that values before creating the second copy of the report.

  • Yathish JR Profile Picture
    Yathish JR 70 on at
    RE: issue on report

    subtotal has only caption and reference , no particular variable is defined in the code . i searched for it

    SubtotalCaptionLbl: Label 'Subtotal:';

    column(SubtotalCaption; SubtotalCaptionLbl)

                           {

                           }

    only these 2 lines come .

    Thanks.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,025 Moderator on at
    RE: issue on report

    Hi,

    You have to clear your Subtotal variable before you are creating your second copy of the report.

    Thanks.

  • sVerme Profile Picture
    sVerme 120 on at
    RE: issue on report

    Probably something wrong with the calculation in the dataset.

    We need more information / code to help.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,564 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans