1,536
hi expert, i have very basic query, i have created new custom field(ProjectName) and added it in purchpackingslipheadertmp table,also in purchpackingsliptmp, then reference it purchpackingslipDP class,but neither data are populated in tmp's tables nor displayed on purchpackingslip Report, please guide me,where i just making mistake..
Regards
*This post is locked for comments
Just to update everyone that I tookup this issue with Munsif offline and advised him to use VendPackingSlipJour buffer to retrieve the PurchTable record. Previously, Munsif was using VendPurchOrderJour and wasn't getting the value in the new field.
Thanks,
Baber.
That is the inbound packing slip correct? Is thiis for a report? Some AX SSRS reports have a data source that can be RDP (AX class). If it is RDP class the pattern here is to draw back the data using a query or a select, then insert into the TMP table. Then the SSRS report is based on the TMP table. I use a tool called Dev Query Browser so I can validate that the query is drawing back data properly. Then you class calls the query, inserts the data into the TMP table and your field will have data when you PREVIEW the SSRS report
Hi Munsif,
With this report, you can debug the DP class, and so you can check if you are hitting your code that updates the field value.
Assuming that you are, try a refresh of the Datasource in VS, and clear the report cache etc before you start trying to debug the SSRS process.
Add a visible version number to the report, to see if the report has updated? If not, remove the report from the server, re-deploy from VS and AX.
I have found SSRS reports to be "buggy" sometimes, and so assuming that you can see your code update the table, i would start with the known AX "interesting features" first ;)
Hi Munsif,
Is the data not showing in any of the field or just this field? Did you debug the RDP class to find out if the data is successfully retrieved?
Also, I assume that you have generated incremental CIL and after that refresh the report dataset to make that field available in report's dataset.
Thanks,
Baber.
Hi,
Things you must remember while working SSRS reports whether it is customized or New reports from scratch.
-->Try to put static debugger (write breakpoint; in your code)in DP Class processReport() method.
--> Run the report from visual studio (go to Microsoft dynamics AX Configuration Utility, select developer tab, and select check boxes provided) and debug it.
--> Stress (While Debugging) on query in processReport() methods because that could also be one of the reason for your problem.
--> Put static debugger in insertIntoTempTable() as well to check whether data is populating in temp table or not, change TableType as regular.
--> Refresh Report Report Server in Tools-> Caches ->Refresh report server
--> Delete the Report from report Server and redeploy it.
--> Generate Incremental Cil and Full Cil generation (Recommended)
Note: This is as per AX 2012 and higher versions.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
