Manage Database
You can select and manage display names for the Tables and Columns you would like to allow in Dotnet Report Builder.
Data Connection groups data schemas (including tables and stored procedures and other configuration), Reports, and Dashboards into a single environment. You can create multiple Data Connections and easily switch between them for separate environment management.
Define Custom Tables using SQL Select Query to use in Dotnet Report for Reporting and Analytics. Select Tables or Views from your Database to use in Dotnet Report for Reporting and Analytics.
Setup your Database Relations for Dotnet Report to produce dynamic queries
|
Primary Table
|
Field
|
Join Type
|
Join Table
|
Field |
|
|---|---|---|---|---|---|
Select and manage Stored Procedures to use in Dotnet Report for more complex and coded Reports
No Stored Procedures have been setup yet.
You can setup access to invidiual Reports here
Create and manage Custom Function that you can use in building Reports and Dashboards
| Name | Display Name | Description | Data Type | Required | |
|---|---|---|---|---|---|
View Schedules setup for sending Reports and Dashboards
| Schedule | Email To | Format | Last Run | User ID | Time Zone | Actions |
|---|---|---|---|---|---|---|
| For | ||||||
Manage
Choose options that will determine how users interact with this column on Reports
Joins Diagram
Manage
Choose options that will determine how users interact with this parameter on Reports
Manage Access by Roles
Choose User Roles that will have Access
Note: All Users will have access if no restricted roles are setup
You can organize the display of tables in the Report Designer by assigning categories here.
| Category Name | Description | Actions |
|---|---|---|
Data Connection
Choose User Roles that will have Access
Note: All Users will have access if no restricted roles are setup
Preview Table
Enter Select SQL for your Data
Import Tables/Views JSON File Upload
Selected Tables/Views File:
Import Joins JSON File Upload
Selected Joins File:
Import Stored Procedures JSON File Upload
Selected Stored Procedures File: