I developed and maintained most of the seventeen standard pre-built reports available in ResourceOne. This included creating and tuning all of the various SQL Server stored procedures and functions required to retrieve the data. Some of these stored procedures became very complicated to accommodate all the various possibilities and permutations of the different parameters submitted to each report. I developed the configuration screens and the application layer methods that allow the user to specify the parameters of their report and methods for returning that data. Each report uses Telerik reporting controls that are dynamically built in the C# code behind.
Reports can be run for one employee, for groups of subordinates, for a whole branch, or for the entire organization. Each report has useful grouping options, such as running the Pipeline report with the Loan and Deposit pipelines split out and sub-grouped. You can export report data to CSV, XLS, PDF, Word and other formats for further sorting, filtering, merging, and graphing.