CrossCompass ®
Ad Hoc Reporting Tools & Embedded Query Components

Bespoke Reporting


Bespoke  Querying Solutions

CrossCompass is extensible to allow users to execute bespoke reports developed in-house specific to the user's requirements and format/layout.

Using the example code provided, the reports can developed in any COM compliant language e.g. Visual Basic or Powerbuilder etc.

The example reports invoke CrossCompass back-office components to extract data from all the catalogued data sources. The extracted data can then be saved to Excel in many styles, PDF, Microsoft report formats and even drilldown reports.

The developed report is given a name e.g. R01 and then within the administration suite, the report is cross-referenced and stored within the CrossCompass repository.

From here the administrator can decide which group of users will utilise this report, adding an extra level of security on the data extracted.

Also reports can be developed to be executed by the batch process based on the server and output to various file formats, for example HTML.

This scheduled submission of reports is useful as the end-user can simply use the lightweight reporter to either run reports or look for the output of the scheduled hourly/daily reports run in batch i.e. the HTML output already providing the end-user with the results they need.

Bespoke Manipulation

Bespoke adds flexibility

CrossCompass will invoke the provided Dynamic Link Library (DLL), developed to generate bespoke output as required, adding an extra level of flexibility.

This ability gives CrossCompass the edge as any data can extracted and manipulated, displayed as required by the end-users.

Using the provided sample Visual Basic code that works with the sample Access database, developers can:

  • Produce new reports against your own catalogued data sources. 
  • Accept a recordset fom the Adhoc query system, transform the recordset and pass it back to the query screen for the end-users to then either manipulate again or dump to the required format.
  • Retrieve data from the backoffice components of CrossCompass in various formats to cater for troublesome data content.

Resultset Manipulation 

The end-user can extract data from a data source into the result grid and simply right-clicking on the grid, run the filter option. This will allow the end-user to either filter the data further themselves or run bespoke routines developed in-house (based again on example code) applying the changes to the extracted data prior to loading into the grid for further transformation if required prior to outputting to the user's required format.

All in all adding total flexibility to end-user requirements

For more information on the capabilities of CrossCompass please download the overview documentation:

CrossCompass Overview (PDF)