|
| [WB20] different sort order |
| Iniciado por guest, 08,dic. 2015 10:37 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 08,diciembre 2015 - 10:37 |
Hi,
I am using the following command to run the reports under webdev 20.
sFile is string = fDataDir()+“\”+DateSys()+TimeSys()+“.pdf”
iDestination(iPDF, sFile)
iInitReportQuery()
iPrintReport()
How do i change the sort order (with end-user selection) based on the same query/report ?
Regards,
PETER ZHOU |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,diciembre 2015 - 20:12 |
Hi,
Is there any command/function to change the sort order within the report ( based on query )?
Regards,
PETER ZHOU |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,diciembre 2015 - 22:57 |
Hi,
in WD (I dont know WB) you can define in Report / edit sorts at any position a user defined function/procedure which return a valid field name. this gives you a kind of dynamic sort order
Example :
PROCEDURE sortval()
SWITCH FBPARAM.PA_SortBJ
CASE 1
RESULT Fbbjour.FBBJ_DAT
CASE 2
RESULT Fbbjour.FBBJ_BNR
CASE 3
RESULT Fbbjour.FBBJ_BELEG
CASE 4
RESULT Fbbjour.FBBJ_BETRA
CASE 5
RESULT Fbbjour.FBBJ_KTO
OTHER CASE
RESULT Fbbjour.FBBJ_DAT
END |
| |
| |
| | | |
|
| | | | |
| | |
|