Problems with ordering grid columns

If there are problems with the ordering of grid columns of a grid inside a tab although the AllowUserSetup of the form is set to Yes. Check if the method tabChanged of the tab control is overwritten. Overwriting this method can cause problems with the re-ordering.
Instead of using the TabChanged on the tab control move the code to the pageActivated method of the TabPage.

Grouping data in SSRS

To group data on a report you need the grouping pane. If it is not visible click grouping on the view tab.
In the grouping pane right click a group an select add before or after to specify where to add the group. This group dialog opens:

Set the name of the group in this dialog. After that the group expression can be specified. Just add grouping criterias. It is possible to group by data fields or by expressions.

When closing the dialog a new grouping pane is added to the tablix data region. it contains a row or column where group values can be displayed.

Fast way to refresh args caller datasource

Cause I always forget these two lines of code to research the datasource of the calling args record in Dynamics AX. I will post it here so that I can google it every time I need it ;)


FormDataSource   callerDataSource;
;


if (_args != null
    && _args.record() != null)
{
    callerDataSource = _args.record().dataSource();
    callerDataSource.research(true);
}

Adding an AX table as Dataset to an SSRS Report

It is important to add the following code in the processReport Method of the DataProvider class in Dynamics AX to use a Table as a new Dataset in an SSRS Report:

newTableNameTmp.setConnection(this.parmUserConnection());

HTML Tags that can be used in SSRS

To use HTML to format text in SSRS it is important to change the placeholder properties (right click on to the placeholder). In the placeholder properties change the markup type to HTML.

After that it is possible to format text with HTML Tags. The following list of HTML Tags shows possible Tags that can be used in an SSRS control:

• Hyperlinks: <A href>
• Fonts: <FONT>
• Header, style and block elements: <H{n}>, <DIV>, <SPAN>,<P>, <DIV>, <LI>, <HN>
• Text format: <B>, <I>, <U>, <S>
• List handling: <OL>, <UL>, <LI>

For further information check out the following MSDN Page about Formatting Text and importing HTML.

Empty AX 2012 Project with all main nodes

To get an empty project with the AOT tree-nodes you can use this project:

EmptyProject.XPO

Change SSRS Report to orientation to landscape

If you need to change the orientation of a report to landscape or to a different format like letter or DIN A4 there is a real easy way. But you'll have to know this way :)

Right click on the background beside the report and select report properties. (or in german: Berichtseigenschaften...)

Than the following form opens where it's possible to change the orientation, the size and so on...