Solved: Random number on the report ( pdf )

Yayasan_TL_BP · 04-29-2021 12:26 AM

Hello…

Today i have create report on my apps.

In myapps editor, number sort from smalles to large ( 1…3 )

But when i create report, the number is random…

the formula is

how to make report with number not random ( same with apps editor )

thank you
Deddy

Suvrutt_Gurjar

Please try expression as under No column in the template as

<<Start: ORDERBY([Related ta_ass_detils], [ta_detil_line], FALSE)>><<[ta_detil_line]>>

View solution in original post

Suvrutt_Gurjar

Please try expression as under No column in the template as

<<Start: ORDERBY([Related ta_ass_detils], [ta_detil_line], FALSE)>><<[ta_detil_line]>>

Yayasan_TL_BP

Hello…
Thank you for your help
And i will try it

Yayasan_TL_BP

Yeaaa…

Thank you so much…

Steve

For reference:

wsaico

Hello @Yayasan_TL_BP how have you managed to insert numbering in your report, I think there are many of us who are looking for this and we have not achieved it yet, could you explain the steps to follow? Thank you so much.

SkrOYC

Manual or

Suvrutt_Gurjar

Hi @wsaico ,

If you are dealing with a related table and if your key column length is fixed, then you could use the following expression to generate the serial numbers in the template.
The following example ( divides the result of FIND() by 11) works for a key column created with UNIQUEID() - 8 characters in the child table.

<<Start:[Related Table IDs]>>
<<(FLOOR(FIND([Related Table Key],[Related Table IDs])/11)+1)>>

The above expression needs to be in the first column. An example highlighted in RED from a sample app below. In this template “Order Details” is the child table of “Orders” table.

@Aleksi has another wonderful approach

wsaico

Thank you very much for your help, I saw that this trick also works