samantha_sana
Well Known Member
we have a requirement to sequence the fields of a report dynamically based on customer number.
Each customer have different sort order.
The sort order is stored in a seperate table using customer number and sequence number.
The idea is to achieve this through set user sequence but there is a challenge while using set user sequence
we do not want to create new version for each customer with different sequence as number of cutomers may increase in future.
steps
1.Use table i/o to fetch the 'field to sort' and 'sort order' using while loop
2.assign the fetched field in set sequence system function
The issue here is based on the fetched value from the table i/o how to identify which BC column to map in the set user sequence system function
will writing an if condition to check the value of the 'field to sort' with a constant value before set user sequence is the only option or
do we have any better options to achieve this.
Please provide your thoughts and let me know if you need more inputs.
Thanks
Each customer have different sort order.
The sort order is stored in a seperate table using customer number and sequence number.
The idea is to achieve this through set user sequence but there is a challenge while using set user sequence
we do not want to create new version for each customer with different sequence as number of cutomers may increase in future.
steps
1.Use table i/o to fetch the 'field to sort' and 'sort order' using while loop
2.assign the fetched field in set sequence system function
The issue here is based on the fetched value from the table i/o how to identify which BC column to map in the set user sequence system function
will writing an if condition to check the value of the 'field to sort' with a constant value before set user sequence is the only option or
do we have any better options to achieve this.
Please provide your thoughts and let me know if you need more inputs.
Thanks