Doxserá® DB offers powerful reporting features through its new Data Tables and Data Functions, enabling users to gather and analyze data directly from external sources like SQL databases. This demonstration showcases how Doxserá® DB transforms complex data into actionable reports, making it ideal for law firms, insurance companies, venture capitalists, and other knowledge workers.

We begin by working with a SQL database named Sakila, which simulates a video rental store. This database contains multiple tables and relationships, such as tables for actors, films, and customers. By leveraging these relationships, we can ask sophisticated questions, like "What films has Penelope Guinness appeared in?" Traditionally, accessing this information required SQL queries—complex statements that most non-programmers wouldn’t be able to write.

With Doxserá® DB, you can now extract this information without needing to understand SQL. For instance, using the Data Function feature, you can easily count how many films are in the database. Simply point the form to the Sakila database, select the film table, and the system will return the total number of films with a single click. If we want to refine this, we can use filters to count only the films rated PG-13, which is instantly generated through the same simple interface.

We also demonstrate the creation of Data Tables to display more detailed information, such as listing all PG-13 films along with their running time. These tables are built dynamically, allowing users to view relevant data on demand.

This capability extends to creating more complex queries, such as finding the longest movie in the database or identifying all movies that are 185 minutes long and providing a synopsis for each.

The flexibility of Doxserá® DB allows knowledge workers to interact with live data, explore relationships between tables, and generate sophisticated reports without the need for programming skills. This transforms the way professionals can analyze data, making critical business decisions faster and more efficiently.

13:20