The Infolog

A blog of Dynamics AX development tips and tricks

Skip to: Content | Sidebar | Footer

Tag: SSRS

Class to find missing label translations

1 July, 2020 (13:19) | Uncategorized | By: Howard Webb

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 […]

Adding fields to PurchPurchaseOrder (Purchase order confirmation)

25 March, 2015 (14:25) | Dynamics AX, SSRS | By: Howard Webb

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 […]

Running a SSRS report via code

10 March, 2015 (11:22) | Dynamics AX, SSRS | By: Howard Webb

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. […]

Reprinting invoices using printJournal

29 August, 2014 (14:12) | Dynamics AX, SSRS | By: Howard Webb

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 […]

Printing external customer statements to multiple file names

10 June, 2014 (11:02) | Dynamics AX, SSRS | By: Howard Webb

One of our customers produce multiple PDF files for external customer statements. They wished to rename the file with the customer account number. To do this we have edited the following method:   \Classes\CustAccountStatementExtController\runPrintMgmt   I declared the following variables   To make sure that I get just the file name correctly I have used […]

Drill through on SSRS reports.

28 February, 2014 (15:48) | Dynamics AX, SSRS | By: Howard Webb

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 […]

Navigation links within a SSRS report

27 February, 2014 (16:38) | Dynamics AX, SSRS | By: Howard Webb

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 […]

Formatting on fields within SSRS

29 September, 2013 (01:18) | Uncategorized | By: Howard Webb

SSRS pulls the formatting direct from the field’s EDT in AX, however this only works if the field is on the report table and is not a aggregate function. As such it does not really work for values that will be used in a header or footer section. There are plenty of examples of this […]

Accessing and setting the SSRS print destinations

29 September, 2013 (00:57) | Uncategorized | By: Howard Webb

The SSRS print destinations are stored on the report’s contract and can be accessed and set with the following code on the controller: controller.parmReportContract().parmPrintSettings();