I got asked to find some missing labels in a report and when I counted them the report hit well over 300 labels. Rather than comparing by hand I built the below class to find the label Ids and then compare them. It allowed me to learn using Regular Expressions: using System.IO;using OfficeOpenXml;using OfficeOpenXml.Style;using OfficeOpenXml.Table;using […]
I needed to create a report which gathered the totals for a pending purchase invoice. Investigating the totals form You can see that it uses the class PurchTotals to calculate the total values. However this uses a PurchParmUpdate record, and at this point a permanent record in the table is not created yet. To get […]
Hi, Sometimes we need to add fields to a report that uses transactional data. Normally these have their own transactional tables such as CustInvoiceJour, however this report is different. If you check the method \Classes\PurchPurchaseOrderDP\createData you can see that the DP class uses PurchLineAllVersions and PurchTableAllVersions to get its data for the report. We will […]
Sometimes we would like to run an SSRS report via code to produce a report without user interaction or to call it during a process. To do this we could call the menu item that launches the report, but more often than not we would like to prepopulate it or call it without user interaction. […]
I was on site with a 2009 customer the other day who were starting to develop their own reports. Being quite a few years since I have done it I had forgotten this trick to get the report name that is being run. If you modify the method \Classes\SysReportRun\run and include this line: […]
If you need to reprint a sales invoice there is a method on the CustInvoiceJour table called printJournal. Calling this method will print using the original print management destination but you can override the destination by passing in an instance of SalesInvoiceJournalPrint. Below is an example of calling it and forcing the print destination to […]
Drill through links in SSRS are controlled by C# code which produces a URL that can be processed to call AX which can open a form with the appropriate record. There is a common class (DrillThroughCommonHelper) that will need to be either referenced or modified if you would like to use a lookup in Your […]
If you are developing a larger auto-design report which groups data together it might be worth adding document navigation to the query to allow the end user to jump between sections of the report: To do this you will need to set up grouping on your table to allow the jumping. The label […]
I have added a graph to the top 100 customers report in AX2012 and it already has the percentage field on the report. I had thought that it would be just a case of referencing that field and then creating a chart. While this might be possible in the end I modified the DP class […]