I am new to SSRS 2012 and am trying to create several financial reports (trial balance, profit & loss, balance sheet, etc.).
Our general ledger account numbers are in the ###-###-### format (i.e 481-389-810)
The problem I am having is that the finance dept wants the P&L report in a specific format using groups/headings and with the GL accounts appearing in a non-sequential order.
See example in attached image file that shows GL Account Description, GL Account Number, Company Number fields
How do I get SSRS to use, display and keep the non-sequential order?
Example 1 using simplified account numbers:
100 Truck Repairs
150 Rail Repairs
120 Warehouse Inventory
110 Auto Repairs
160 Property Maintenance
I am assuming others have had a similar problem and possible solution(s). I would appreciate any assistance in resolving this issue.