Hello,
I've created a report that displays entries grouped by different time periods (year, month, week, ...) in multiple levels.
As a caption for these layers, I have each created a date field that will be displayed in a matching format.
For example, MM.yyyy (MMM.) For month, will be formatted as follows: 01.2018 (Jan).
I also use the groups in my table of contents.
For this I have created corresponding levels and deposited in the group editor in each case a TocText as an expression.
That works so far everything, but is sometimes very complicated.
If you want to have a formatting as above that is very expensive.
The expression looks like this:
The simple variant
I've created a report that displays entries grouped by different time periods (year, month, week, ...) in multiple levels.
As a caption for these layers, I have each created a date field that will be displayed in a matching format.
For example, MM.yyyy (MMM.) For month, will be formatted as follows: 01.2018 (Jan).
I also use the groups in my table of contents.
For this I have created corresponding levels and deposited in the group editor in each case a TocText as an expression.
That works so far everything, but is sometimes very complicated.
If you want to have a formatting as above that is very expensive.
The expression looks like this:
The simple variant
= IIf (Len ("" + Fields.ticket_closed_at.Month) < 2, "0" + Fields.ticket_closed_at.Month, Fields.ticket_closed_at.Month ) + "." + Fields.ticket_closed_at.YearThat's easy.
But if you also want the month in short form, as above, I have the following expression:
= IIf (Len ("" + Fields.ticket_closed_at.Month) < 2, "0" + Fields.ticket_closed_at.Month, Fields.ticket_closed_at.Month ) + "." + Fields.ticket_closed_at.Year + "(" + IIf (Fields.ticket_closed_at.Month = 1, "Jan", IIf (Fields.ticket_closed_at.Month = 2, "Feb", IIf (Fields.ticket_closed_at.Month = 3, "Mar", IIf (Fields.ticket_closed_at.Month = 4, "Apr", IIf (Fields.ticket_closed_at.Month = 5, "May", IIf (Fields.ticket_closed_at.Month = 6, "Jun", IIf (Fields.ticket_closed_at.Month = 7, "Jul", IIf (Fields.ticket_closed_at.Month = 8, "Aug", IIf (Fields.ticket_closed_at.Month = 9, "Sep", IIf (Fields.ticket_closed_at.Month = 10, "Oct", IIf (Fields.ticket_closed_at.Month = 11, "Nov", "Dec") ) ) ) ) ) ) ) ) ) ) + ".)"That works, but nice is different.
And if you still want to localize it is over.
My question on you is:
Is there a way to apply formatting to TocTexte, such as on a text box?
Or maybe there is another way how to solve something?