📄️ Grid Designer
The Grid Designer is a powerful tool in dReveal Desktop Authoring Tools that empowers power users to create detailed reports, elevating reporting to a new standard with a focus on grid-based data presentation.
📄️ Data Source Connection
Article Date
📄️ Managing your Grid Report
When you access dReveal Grid Designer, the first thing you will notice is an empty screen. Now, let's shift our focus to the ribbon, specifically to the five options detailed below. These options are crucial for managing your reports efficiently:
📄️ Column definition for your report
This 'Fields' icon allows you to define the columns of the model that will be used in your grid report. In the 'Included Fields' list, you will find the columns you have chosen to work with in your grid report. The columns listed under 'Available Fields' are those that you did not include in your grid report initially. Grid Designer provides you with the flexibility to include them later or remove some columns that you included at the beginning without any issues.
📄️ Change Name
Grid Designer allows the user to assign a personalized title to each report. This not only facilitates identification and organization but also enables users to convey the desired narrative for their data.
📄️ Columns Properties
In this tutorial, we will explore the properties and behavior of columns in dReveal. Columns play a crucial role in determining which data you want to display in your report.
📄️ Group By Anchor Column
Defines whether or not a grouping of the columns that are set as anchors will be performed throughout the entire report. This functionality refers to when a specific column is used as an anchor to group data according to the unique values found in that column.
📄️ Pagination Offset
dReveal's grid pagination control has been enhanced to improve performance and flexibility. A new pagination method, leveraging SQL OFFSET FETCH clauses, has been introduced to calculate the total row count within a single query.
🗃️ Actions you can apply to your report
6 items
🗃️ Filters
4 items
📄️ Select column
Grid Designer allows the user to apply sorting to their column groups. This makes it easier for the user to identify and organize their columns in the "Columns" section displayed in their report.
📄️ SQL Query and Select TOP
Grid Designer provides the user with the options 'Query' and 'Select TOP' to be used when needed. Next, we will detail the benefits of these options in the report for the user.
📄️ Report Export
Grid Designer not only provides users with the flexibility to create detailed reports but also offers the convenience of exporting them in various formats. This ensures that you can easily share, analyze, and present your data in the most suitable format for your specific requirements.
📄️ Skins
Grid Designer not only allows the efficient creation of detailed reports but also provides our clients with the ability to select their preferred 'Skin' or visual appearance directly in the tool.