Report designer

Our client, a Ukrainian software company, needed outstaffing support for the development of the report formatting solution. So, our main goal was feature-rich desktop and web application creation for formatting and fine-tuning reports.

Project details

Platform
Web & desktop
Services
Business Analysis, Web & desktop development, QA, Support & maintenance
Partnership
2013 – 2014
Hours spent
47k+

The situation

Our main task was to develop a report designer app that empowers users to build reports and spreadsheets rich in data visualization. An app should generate a scheduled report, then display it on the screen or print it out.

Before development, we spotlighted such necessary app features as data grouping, editing, sorting, format changing. Besides, the report design app should export data in different formats like XLS, DOC, PPT, PDF, HTML. Moreover, many reports contain animation elements, images, links, so we added these features. We also considered the possibility of improving reports with graphs, charts, tables for data clarity.

Another challenging task was the fast and easy connection to the most commonly used SQL and NoSQL data sources.

The solution

So, the application contains such features:

  • Format and configure the layout of the report
  • Create spreadsheets (as in Microsoft Excel) and analytical notes (as in Microsoft Word)
  • Group, sort, filter, perform conditional formatting, and edit data
  • Insert text, images, links, animation, and other objects
  • Export to external formats such as XLS, DOC, PPT, PDF, HTML, XML, and others
  • Consume data from local or server databases
  • Print reports

Technology stack

Key results

We developed both web and desktop applications to create and visualize powerful reports using text, images, tables, links, lists, charts, graphs, and other elements. This solution will be useful for any type of business.