The Scheduler is an automation interface for the execution of tasks on a recurring and ad-hoc basis. Each task can have many actions and a task can be executed manually or a schedule. To allow concurrent activity, the Scheduler is only available on installations that have five or more full licenses.
- Optionally and conditionally execute reports that can store, save and email content.
- Include expression based logic to drive multiple scenarios.
- Send notification and exception reporting.
- Create, collate and deliver Board Report packs.
The Query Builder is a user interface with separate panes for filters, field selection and output. Simple enough for the infrequent user but it does have deep functionality with menus on each pane title and fields have right hand click menus. In the filter pane the user can select between different query styles using the mode filter and when the user selects the table, it becomes the focus for the query structure and it populates the fields and relationships in the selection pane.
- The datamodel acts as a presentation layer between the complexity of the data source and presents to the users a unified view of query tables, with available fields and relationships.
- The Query Builder uses drag and drop to select filters and outputs, most fields can be a filter and/or an output. The query engine will construct the query on the fly and optimise the syntax.
- The filters can inherit and display lookup lists from the datamodel and there are standard lookup wizards for dates and periods.
- Query results can be previewed in the Query Builder to assist in query design and Preview grid supports drill for further analysis.
Sharperlight can present dynamic tables, charts, pivot tables and presentation reports using its own web service. It has an application called Publisher, for managing and configuring these published queries. Each query can be filtered and refreshed in the web, and it will return the latest data.
- The core charting engine renders the graphics in HTML5.
- Every published query has a unique web address referencing the query and the output style. This means each query can be uniquely referenced in a webpage, or in an email, or bookmarked in a web browser.
- For pixel perfect report layouts, Publisher has a WYSIWYG report designer that can output reports to PDF, HTML and Microsoft Word.
The report designer provides more control on the positioning and layout of report pages, and it addresses many of the printing limitations inherit in web browser rendering. It uses a third party component library to provide the reporting engine and a graphical What You See Is What You Get (WYSIWG) designer interface.
- Uses the Query Builder to construct the data sets and it automatically integrates the query as a report data source.
- Allows pixel perfect control of field and object placement for reports and business documents.
- Reports can be accessed through the Sharperlight Web Service and run locally on computers that have the Sharperlight rich client.
- In the web the reports use the common filter bar to feed parameters back to the underlying reporting engine.
- The reports can be rendered into PDF and native HTML, it also supports output to Microsoft Excel and Word.
The Sharperlight Service delivers remote access to Datamodels and it has a REST Service that can render Query Builder queries in a browser. This web delivery supports filtering and the end-users can change the filter values and refresh the output. Multiple output layouts are available for the same query, so the same data set can be rendered as a table, chart, pivot table and an RSS feed.
- Each query has a unique URL address
- Accessible by any browser or integrated into an application
- Publish the query in real time with access to any Datamodel in the Sharperlight framework
- Rapid report development where the same dataset can be reused to deliver multiple styles
- Control access security and formatting