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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

passing a temp table from a form to a ssrs report

(0) ShareShare
ReportReport
Posted on by 3,851

Hi All,

    I have  created a form with temporary table as a data source , I am populating the data through X++ code.

What ever the data filled in a grid I want to shown in a SSRS report , how can I pass that data source to the RDP class Or query based reports.

Could  anyone guide me , I am looking from a long time

thanks

Veer

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Brandon Wiese Profile Picture
    17,788 on at

    Look for any box report that uses the SrsTmpTblMarshaller class.  Basically you call the class to store your temp table as a container into an actual database table, and then pass the record Id of that record as a parameter in your data contract.  Then the data provider fetches that record back, unpacks the temporary table, and either consumes it (uses the temp table as a form of parameter for building other data) or in some cases just passes it directly to the report as raw data.

    msdn.microsoft.com/.../srstmptblmarshaller.aspx

    Seeing an existing report that uses it makes a lot more sense than trying to read about it, I find.

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans