I want to sort my accounts payable aging, but I cannot find a sort option. Is it possible to do this such that I can put the A/P aging in order by vendor name?
Thank you.
I want to sort my accounts payable aging, but I cannot find a sort option. Is it possible to do this such that I can put the A/P aging in order by vendor name?
Thank you.
Thank you very much for your help!
You will need to do a custom report layout change which is very easy to complete if you stick to RDLC. Note you will need at least SQL Report builder 2016 installed to do this.
Go to the custom report layouts page and create one for the corresponding report ID. GB is 322 so I've done that one. Export the layout and open it to reveal the below detail. Place the cursor where you see mine, you want that big orange bar on the left to appear.
right click to get the tablix properties open. And this:
Save and then import the layout to BC. Run the report and the sorting should be changed:
André Arnaud de Cal... 291,602 Super User 2024 Season 2
Martin Dráb 230,340 Most Valuable Professional
nmaenpaa 101,156