Announcements
Hello,
Does anyone know how to fix the sorting on account numbers in the GL Trial Balance Summary and Detail in SSRS?
I have a new deployment and it is messed up. I tried redeploying as well as editing the stored procedure to include this at the end but nothing. (select * from #accountsegment order by segmentlisting)
Hi Derek,
This morning I got it to work. Apparently there was already a select statement at the end of the stored procedure. Thus, once i removed that and left my select * from #accountsegment order by segmentlisting then it worked. I will surely try the above next time to see if it does resolve the issue. Thanks much. This was for SQL 2019, GP18.3 and of course I wanna say SSRS newer than 2016.
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
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
