We have seen an issue with the Trial Balance report for SQL SRS, showing the Starting/Ending account drop-down fields mixed up when deployed on SQL Reporting Services 2016.
The work-around, is the following:
1. To modify the report, you can go to the SSRS Report Manager site, and click on the drop down next to the SSRS GL Trial Balance Detail or Trial Balance Summary Report, then select Edit in Report Builder. Once Report Builder is installed and the report is opened, you can expand the Parameters folder.
2. Once you have expanded the Parameters folder, right click on the I_cStartingAccountNumber parameter, and select Parameter Properties. Click on the Available Values tab in the Report Parameter Properties window, and select None. Then click the Default Values tab, and select No Default Values. Click OK.
3. Repeat this step for the I_cEndingAccountNumber parameter as well, then click the Save button in Report Builder.
I know I've tested this on a older and newer version of SQL Reporting Services, then SQL 2016, and the account numbers sort correctly.
Thanks
