Column size reports AX 2009.

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi All,

I’m asked to change the column width of the AccountNum column on the Trial balance report in AX2009, however changing the stringsize of the AccountNum EDT from 20 to 10, will affect all other EDT’s extending from this.

I can imagine that the better option would be to no longer have the LedgerAccount EDT extend from AccountNum and change the stringsize of the LedgerAccount EDT?

Still, I’m not to keen on changing the standard EDT’s, so my question is if there’s another better way to work around this?

Or is changing the LedgerAccount EDT as described above the way to go?

The column width property on the report itself isn’t doing the trick either.

Kind regards,

2

Changing the width in report should be doing the trick. BTW, for which field in the report you are updating the width (the path)

3

I can see the ledger account number is added at two places in the report,

\Reports\LedgerTrialBalance\Designs\TrialBalance\AutoDesignSpecs\Body:LedgerTable_1\String:LedgerTable_AccountNum

\Reports\LedgerTrialBalance\Designs\TrialBalance\AutoDesignSpecs\ProgrammableSection(1):ProgrammableSection_1\String:Field_2_3

4

Hi Kranthi,

I’m doing this for Field String: LedgerTable_AccountNum in Body:LedgerTable_1 on the LedgerTrialBalance Report.

5

I’ve tried changing only the width of “\Reports\LedgerTrialBalance\Designs\TrialBalance\AutoDesignSpecs\Body:LedgerTable_1\String:LedgerTable_AccountNum” from Auto to Column width => nothing changes.

I’ve tried changing only the width of " \Reports\LedgerTrialBalance\Designs\TrialBalance\AutoDesignSpecs\ProgrammableSection(1):ProgrammableSection_1\String:Field_2_3" from Auto to Column width => nothing changes.

I tried by changing the properties of both to column width => nothing changes either, the column size remains the same as before, like I stated in my initial mail.

6

You should give char type value in width property .

7

What if I change the DisplayLength attribute on the LedgerAccount EDT?

This has the desired effect too, without touching the AccountNum EDT, and Ledgeraccount can still extend from AccountNum then.

Does this seem a proper solution, since changing the width property on the report is not having the desired effect?

8

Yes, spot on, Tamim, thank you!

I’m quite new to reports, so I only stuck to what was there in the dropdown.

This topic can be closed.