This section discusses how to setup tables and columns in a Data Connection so it can be displayed and used by end users in dotnet Report.
You can setup the schema manually on the online portal. However the preferred method is to set it up in your local environment after installing the dotnetreport nuget package in visual studio, and navigating to the route /dotnetsetup.
Once the page loads, dotnet Report will connect to your local database and pull in all the Tables and Views, and you will be able to view the schema of your database. All the tables and views from your database are shown along with all the fields/columns of those tables/views, and you can pick the ones you want to use in the Report Builder.
dotnet Report allows you to select or unselect all the tables and their respective columns at just a button click. You can also choose tables manually by clicking the check box next to the table name if you don’t want to include all. After selecting a table manually you can select all columns or check the columns manually that you want to include.
You can also change the displayed table name or column name by double clicking the table or column name and changing it as shown in the images below.
After you have selected a table manually you can select or unselect all the columns from a table as shown in above image.
If you select some tables and their columns manually and then press the select all button dotnetreport will select all the tables and columns except the tables and columns which are manually selected, enabling you to keep the preferences about the tables selected manually.
After selecting all the tables and columns you want to include in your reports, you can click on save all changes to commit the changes. You can also choose to individually save a single table at a time, by clicking on the “Save” button on the table.
Our next and final step for schema set up is to set up the relation ships between these tables. This is explained in next section.