This is the screenshot I have taken from Accounting software and I want to create a similar type of report using C# Windows Form Application, I have a data against all account numbers, What I think of is running multiple quires for all account numbers and that is a lengthy process I am using MS SQL Compact Edition Database any suggestions will be highly appreciated.
General Ledger report screenshot from peach tree
