Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

SSRS Report convert expression value from amount to %

(0) ShareShare
ReportReport
Posted on by 404

Hi, im trying to convert the value of a field to be shown in my ssrs report in %, anyone can provide me the full expression.

THANKS

  • D365FO DEV Profile Picture
    D365FO DEV 404 on at
    RE: SSRS Report convert expression value from amount to %

    Hi, all my root cause is line disc % field, thats why other fields changed values.

    i am actually trying to debug my code but for some reason the debugger is not working on this sales invoice. is that possible u provide me a correct version of the code? ( also note i need to show each line its own line disc % thats why im using taxtrans table ) if u can provide correct version of code, i will be thankful!

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: SSRS Report convert expression value from amount to %

    Hi, Not just LineDisc but few other fields are also changed. I can't help here much, you need to debug the code and find root cause. Just one suggestion is to review your code where you have created unnecessary table buffers like taxTrans. Please check if you really need it or can use method parameter just like custInvoiceTrans.

  • D365FO DEV Profile Picture
    D365FO DEV 404 on at
    RE: SSRS Report convert expression value from amount to %

    Hi mohit, i am now facing the following issue: if i create a sales invoice with multiple packing slips, the Line disc % is being divided  by 2. i will share screenshots:

    pastedimage1684663618025v1.png

    here is the second picture where the line disc % is being divided by 2:

    pastedimage1684663694606v2.png

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: SSRS Report convert expression value from amount to %

    You should comment your select statement for custInvoiceTrans and use _custInvoiceTrans table buffer you have in the parameters of this method.

  • D365FO DEV Profile Picture
    D365FO DEV 404 on at
    RE: SSRS Report convert expression value from amount to %

    if i comment the last part of the code, i get 3 lines.

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: SSRS Report convert expression value from amount to %

    If you comment this code, are you getting 3 lines. If No, then this is not the root cause.

  • D365FO DEV Profile Picture
    D365FO DEV 404 on at
    RE: SSRS Report convert expression value from amount to %

    pastedimage1684507228976v1.png

    i debugged, the issue is with this part of the code that is responsible of mapping the field sumlinedisc from custinvoicetrans.its only reading 1 line in debugger. i used the same logic i did in the first loop in taxtrans table.

    i dont know whats wrong with my code that is showing only 1 line.

  • Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: SSRS Report convert expression value from amount to %

    You can debug the SalesInvoiceDP class. populateSalesInvoiceTmp and insertIntoSalesInvoiceTmp methods.

    Also, try printing report for another sales order to rule out data issue.

  • D365FO DEV Profile Picture
    D365FO DEV 404 on at
    RE: SSRS Report convert expression value from amount to %

    i cannot check the table browser since the table is a tmp table, i get this message: You've received multiple errors.

    You are not authorized to access table ‘Show invoice’ (SalesInvoiceTmp). Contact your system administrator.

    The menu item with name systablebrowser could not be opened.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: SSRS Report convert expression value from amount to %

    You can check if 3 records are inserted in tmp table for this report. Either debug it or change the TableType property to Regular, so you can see the records in SQL server or table browser after report is executed.

    If 3 records inserted then issue in report design or SSRS service, if 1 record then issue in class level.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,187 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,966 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans