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

Notifications

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans