Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Showing Added Column on report

Posted on by 105

Hi Guys,

I have added a new column to my sales line(from table and page extension) then up to posted sales invoice and the values are flowing well

pastedimage1671121303392v2.png

from one point user insert only value for narration column in sales line and post, then from posted document if i tried to print, that line is not showing on report

pastedimage1671121668997v3.png

How can I print that line to my report

thank you all

  • Maro9595 Profile Picture
    Maro9595 105 on at
    RE: Showing Added Column on report

    Hello Pankaj,

    This is base report i have just extend and add that column, I think there is a way report is skipping line which does not have type

  • Suggested answer
    pankaj.k Profile Picture
    pankaj.k 960 on at
    RE: Showing Added Column on report

    Hi Maro..

    I think this is your customize report. can you please show us your code??

    Note:

    1. if you are using any viability condition then please check it on layout line.

    2. if you are using filter Like  Type:: Item then please remove it.

  • Maro9595 Profile Picture
    Maro9595 105 on at
    RE: Showing Added Column on report

    Thank you Nitin,

    I did report extension before, now see once my image from invoice, report does not print that line which have narration only it skip it

  • Maro9595 Profile Picture
    Maro9595 105 on at
    RE: Showing Added Column on report

    Thank you ZHU,

    report extension is there already, but see my image there is a line which does not have type(item,fa,gl etc) in invoice, only narration is there, I want that empty line to show up on report as seen on invoice

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,023 Moderator on at
    RE: Showing Added Column on report

    Hi,

    That field is missing to be added the Posted report, you can create a report extension for it.

    learn.microsoft.com/.../devenv-report-ext-object

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,639 Super User 2024 Season 2 on at
    RE: Showing Added Column on report

    Hi, Here is a very simple example.

    https://yzhums.com/10723/

    pastedimage1671148187061v1.png

    pastedimage1671148195654v2.png

    pastedimage1671148204996v3.png

    pastedimage1671148218976v4.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: Showing Added Column on report

    ciao

    customize the report

    learn.microsoft.com/.../ui-rdlc-report-layouts

    learn.microsoft.com/.../ui-rdlc-report-layouts

    www.youtube.com/watch

    check my answer if it helped you, thanks

    DAniele

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,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans