Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

How to display one same item has multiple quotations, and this list will be display on rdlc report

Posted on by 153

Hi Guys,

I want, if I have one req no. i.e. T00003 & it has multiple quotation no.like this QS/2023/00037,QS/2023/00038,QS/2023/00040,QS/2023/00041.

How to display this multiple quotation no.

And this multiple lines are disply in rdlc report textbox.like this QS/2023/00037,QS/2023/00038,QS/2023/00040,QS/2023/00041

pastedimage1680604805329v1.png

pastedimage1680605179627v1.png

pastedimage1680605007461v2.png

Is any way to do this.

  • Suggested answer
    sVerme Profile Picture
    sVerme 120 on at
    RE: How to display one same item has multiple quotations, and this list will be display on rdlc report

    Hi,

    You're overwriting your variable each time you go through the repeat. 

    Try:

    if Quotation_No := '' then
    Quotation_No := Rec_quot."Quotation No"

    else

    Quotation_no += (',' + rec_Quot."Quotation No";

    it will check if you already have something in the variable, if so, add a comma in front. 

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans