Printing dynamic parameters (AX 2012 / SSRS)

In addition to parameters specified in data contracts, reports can also use queries. It’s very handy, because users can specify filters and sorting in exactly the same way as they’re used to from other places in Dynamics AX, they can use query expressions and so on. A relative common request is printing parameter values on …

Continue reading ‘Printing dynamic parameters (AX 2012 / SSRS)’ »

Aggregation of expressions in SSRS

Imagine you have an SSRS report with a tablix, which contains a calculated field. For example, there is a date field (from a data set) and a calculated field showing the difference between the given date and the current date: The Diff field is calculated by the following expression: =DateDiff("d", Fields!GivenDate.Value, Today) Now we want …

Continue reading ‘Aggregation of expressions in SSRS’ »

«Expr» in SSRS reports

Do you like report designs that look like this? Me neither. It may print the right data, but it’s difficult (= expensive) to maintain. Fortunately you can easily show something descriptive instead of «Expr». Right-click the value and pick Placeholder Properties… and type a description of the placeholder to Label: The designer will then display …

Continue reading ‘«Expr» in SSRS reports’ »

Printing reports from code in AX2012

How to print a report from X++ and change print settings in AX2012? I have a concrete example for you – it should give a good idea how to do that even if your situation is a little bit different. SrsReportRunController controller = new SrsReportRunController(); SysUserLicenseCountRDPContract rdpContract = new SysUserLicenseCountRDPContract(); SRSPrintDestinationSettings settings;   // Define …

Continue reading ‘Printing reports from code in AX2012’ »