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
Solved! Go to Solution.
Please try expression as under No column in the template as
<<Start: ORDERBY([Related ta_ass_detils], [ta_detil_line], FALSE)>><<[ta_detil_line]>>
Please try expression as under No column in the template as
<<Start: ORDERBY([Related ta_ass_detils], [ta_detil_line], FALSE)>><<[ta_detil_line]>>
Helloโฆ
Thank you for your help
And i will try it
Yeaaaโฆ
Thank you so muchโฆ
For reference:
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.
Manual or
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
Thank you very much for your help, I saw that this trick also works
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |