web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS Report Format
Microsoft Dynamics AX (Archived)

SSRS Report Format

(0) ShareShare
ReportReport
Posted on by JEMT 178

Hi Guys,

Sorry for the subject i don't know how to name my question.

Let me explain. I want to print Product serial numbers Dynamically based on quantity when posting sales order.

Honestly this report is already done in Morphx Report in AOT, we planing to transfer this report to SSRS report but with new requirements which to put the serial number.

I create Customizte Report (RDP) with three temporary table and in SSRS three dataset.

a. HeaderFooterTmp
b. BodyTmp
c. SerialTmp

Now, the format requirements is quite hard, So that i try to ask here for a help.

Please see below format needed.

3247.Capture.JPG

Any help or suggestion would be greatly appreciated.

Should have any question please let me know.

TIA

*This post is locked for comments

I have the same question (0)
  • JEMT Profile Picture
    JEMT 178 on at

    Thanks for the response Crispin,

    I understand what you said and i think you right, i do combine the bodytmp and serialtmp.

    But, i don't know how get the proper group bys  and aggregate.

    Since the the SerialTmp before has 4 fields and move it to Bodytmp.

    • InventTransId
    • SerialNumber_1
    • SerialNumber_2
    • SerialNumber_3

    how i can do the format/image above?

    Thank you and regards,

  • JEMT Profile Picture
    JEMT 178 on at

    Yes it returns like that.

    I try the next one you said and add the serial. Below it shows the result.

    ITEMNAME-Head
    SerialABCD1 SerialABCD2 SerialABCD3
    ITEMNAME-Head
    SerialABCD4 SerialABCD5 SerialABCD6
    ITEMNAME-Head
    SerialABCD7 SerialABCD8 SerialABCD9

    And to share with the tablix looks like.

    tab.JPG

    Can you help me on how to group this?

    Thank you very much

  • JEMT Profile Picture
    JEMT 178 on at

    Thank you Crispin .

    It helps me a lot.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans