Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

New column in report with multiple expression

Posted on by 2,988

5432.REPORT1.png3542.REPORT2.png

Hi Experts,

i am developing a report and one column which is strange for to deal with please check the requirement in above images.

Best Regards,

Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: New column in report with multiple expression

    2746.REPORT3.png

    Hi both,

    This is the customer auditor report and they want to add a new column as  I added the calculation as I shown above for this new column as well for more info check this image as well. Any below row will take value from its above row.

    Best Regards,

    Shabir Ahmad

  • Abdulaziz Albloshi Profile Picture
    Abdulaziz Albloshi 365 on at
    RE: New column in report with multiple expression

    I will suggest to make columns in your Tmp Table and do the necessary calculation in processReport() of RDP class. It will be difficult to do such calculation on design level.

  • Martin Dráb Profile Picture
    Martin Dráb 225,862 Super User on at
    RE: New column in report with multiple expression

    I'm afraid I'm not able to design an algorithm without knowing what it should do. And I don't think you'll either. So... you'll need to go back to the requirement gathering phase.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 2,988 on at
    RE: New column in report with multiple expression

    THIS IS RDP BASE REPORT  THIS WAS FINANCE DEPT GAVE TO ME BUT I DID'NT ASK FOR REASON JUST THEY SHOW ME HOW THE REPORT SHOW CALCULATE THESE VALUE.

  • Martin Dráb Profile Picture
    Martin Dráb 225,862 Super User on at
    RE: New column in report with multiple expression

    First of all, what kind of report you're trying to build? An SSRS report based on an RDP class, for example?

    What's the business reasoning of calculating the value from two different lines? How are they related from business point of view?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,513 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,862 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans