Analance BI Professional Reports

Analance BI Professional Reports are a collection of design surfaces and graphical tools for building reports interactively. One can use SSRS, Crystal Reports or Analance Designer to design and create a report. You can add data sets to accommodate a new report design idea, or adjust report layout based on preview results.

Analance BI Professional Reports designer supports tabular, matrix, or freeform reports. Tabular reports and matrix reports, also known as cross tab or pivot table reports, are easily created using the Report Wizard. Freeform reports, which can include tables, matrices, and charts, are created using the windows based designer applications.

Preview the Layout

While designing a report, you have the option of testing it locally before publishing it to a report server. When you preview a report, Report Designers can use the same processing and rendering extensions that the report server uses, ensuring that users see the report as it was intended when they ran the report. When ready, use Report Designer to publish reports to a report server.

Publish to a Server

Publishing a report copies it from the report definition on your hard drive to the report server database. Once a report is published to a report server, it can be managed, secured and viewed from the Analance portal.

 Features
  • Work with OLEDB, ODBC, SQL and XML file database
  • Data sorting, grouping, filtration with report engine
  • Unlimited hierarchical reports
  • Unlimited multicolumn reports
  • Comprehensive set of charts
  • Complete set of tools for rendering both simple and compound cross-reports.
  • Reports with grouping
  • Unique ability – containers
  • Unique ability - segmented pages
  • Dialog forms for parameters of the report output
  • Powerful system of calculation of totals
  • Custom formatting of reports
  • Applying filters and conditional report generation
  • Supports various data sources
  • Exporting to other user readable form
  • Applying condition to each column and page
  • Supports sub report and drill down reports
  • Supports Cross tab reports
  • Publish reports to the report server
  • Add reports to dashboards
  • Export to Excel, Word and Pdf
  • Personalized reports and folders
  • Easy access to functionalities with the help of the toolbar
 Benefits
  • Full support of all ADO.NET types of data: DataSet, DataTable, DataView, DataRelation. All data are output considering the hierarchy of data in the DataSet. All data are typified
  • Data receiving from MS SQL, Oracle, ODBC, OleDB, FirebirdSQL, and PostgeSQL is supported. You can make compound SQL queries to databases, with use of SQL parameters etc.
  • Data receiving from xml files. You can get data for the report directly from xml files
  • Professional Report Designer allows you to use hierarchically bound data from the DataSet. In addition you can sort data, and sorting is possible with use of DataRelations. Data filtration is available when output. Other kinds of data processing are available
  • The report designer has a professional and usable interface. Docking windows, toolbars, hotkeys are used etc.
  • You can setup the view of the report designer. It is possible to turn on/off any element of the menu, any button on toolbars, any docking window and many other elements. This allows you to simplify usage of the Designer by the end-user
  • Comprehensive set of charts designed to increase graphical impact of reports is available in report designer. The following types of charts are supported: Clustered Column, ClusteredBar, Area, Pie, Doughnut, Line, Spline, Spline Area, Stacked Bar, Stacked Column, Stacked Area, Stacked Line, Stacked Spline, Stacked Spline Area, Full-Stacked Column, Full-Stacked Bar, Full-Stacked Area, Full-Stacked Line, Full-Stacked Spline, Full-Stacked Spline Area
  • You can calculate total of a report, group, column, page, with growing total, with condition. Following aggregate functions are available: Sum, Count, Avg, Max, Min, First and Last