Features
Here is a sampling of features of Pebble Reports:
- Tables, charts and crosstabs
- Multiple sheets per report
- Multiple data sources per report
- Display table and chart side-by-side showing same data
- Conditional formatting without writing code
- Full-featured graphical Query Builder; supports SQL Server, Oracle and MySQL
- Query builder supports editing join condition; supports building Where clause
- Work directly on data (no "layout mode")
- Slice and dice data to discover trends
- Drill-down to see more detail
- Drill-through to related reports
- Edit values displayed in the report and Write Back to the database
- PDF, XLS and MHTML export
- MHTML export compatible with Outlook and Microsoft Word
- Email formatted reports as in-line HTML (as opposed to attachment) via Outlook or SMTP
- On-report interactive sorting
- Flexible parameter prompting
- Embed data in report, with ability to filter embedded data
- Top N filter
- Build complex filters with And/Or conditions
- Apply style sheet
- Expand All / Collapse All
- Banded rows
- Compact, stepped and block style display of row group headers
- 16 different chart types
- Charts consistent with Edward Tufte and Stephen Few principles
- Performance and scalability that rivals most server-based reporting products
- Calculated fields
- Data displayed in controls (as opposed to paginated document) for quick browsing
- Deploy report to Report Server directly
- Save as RDL
Write Back
Often users export reports to Excel because they want to fix bad data. Storing and updating data in spreadsheets is problematic because you get "multiple versions of the truth" when multiple people update copies of the spreadsheet in inconsistent ways.
Now Pebble Reports lets you modify values right in the report and write your changes back to the database. Updating data in Pebble Reports is just as easy as updating data in a spreadsheet, however, since your updates are written to a central database there is only one version of the truth. And your coworkers can see your updates immediately.
(Note: The Write Back feature is turned on by default. To turn it off edit config.xml.)
Build Complex Filters Graphically
Pebble Reports makes it easy for end-users to filter data.
Embed data in the report
"It is desirable that the query tool even function in a remote network that is not physically connected to the DBMS, as long as no new queries are requested."
— Data warehouse pioneer Ralph Kimball