Add SORT command to XLReporter Studio function list.
Excel has a function called SORT that is able to be used in the formula bar but this is not an availble/ supported function to use in the XL Reporter Template Studio.
Yes but this functionality has limitations when trying to utilize real time shift report creation and switching between multiple workbook names during a set time period. This would then force us to have to make individual templates for not only each machine but also each product we run on each machine. I have been in contact with Mark Wallace about this.
Long story short though this "sort range" function does not seem to be a sufficient replacement of native Excel's "SORT" function.
Although the SORT function is not supported in the XLReporter Template Studio, we do have a Management Function called Sort Range that will accomplish the same thing.
Yes but this functionality has limitations when trying to utilize real time shift report creation and switching between multiple workbook names during a set time period. This would then force us to have to make individual templates for not only each machine but also each product we run on each machine. I have been in contact with Mark Wallace about this.
Long story short though this "sort range" function does not seem to be a sufficient replacement of native Excel's "SORT" function.
Although the SORT function is not supported in the XLReporter Template Studio, we do have a Management Function called Sort Range that will accomplish the same thing.
See the bottom of page 30 for more details: https://downloads.smartsights.com/files/Products/XLR/docs/product/sytech-xlreporter-data-management.pdf#page=30