Monday, 9 January 2017

SSRS Trial Balance not sorting account numbers

So you try to print a GL Trial Balance but when you select the from and to accounts they are not sorted correctly.

Easy fix - change the sort order in stored procedure.

Edit the stored procedure that populates the drop down list (seeglSRSAccountListing in the company database) to end with this:
select * from #accountsegment order by segmentlisting

Originally it does not sort.

Also, you can technically change the drop down lists to text boxes and type in account segments instead of using that pre-populated drop down list if you want.

No comments:

Post a Comment