CREATING A DATA SOURCE WITH DataTime, CREATING ARBITRARY JOIN WITH THE INSTRUMENT OF VISUAL DataTime, DATAGRID MULTIPLE.
In creating a simple report, we start from a table already exists within the DBMS and by this reference are made all the subsequent analysis of query reporting. In
DataTime you can also create Data Source, ie the join between tables, which can also be from different DBMSs, and result in a single table from which to extract the reports and perform analysis.
It is very easy to create a Data Source to get enough start the application, open a new project and then establish a new connection to the database of our interest (for example Northwing Access, used in class). The next step is to save the database connection created and click on "New Data Source".
This will open a new dialogue since extradite "Data Source desiner" in which the user is prompted to select the tables of interest. To reach the end of the implementation of the Data Source must follow all the steps guided the program until you get to the end and saved by clicking the "Save". If the user has a good familiarity with SQL can egli stesso generare uno script. In questo modo salterà tutta la procedura e giungerà prima alla creazione del Data Source.
Una volta salvato il DataSource, l’utente può iniziare a effettuare nuove query reporting andando a selezionare la voce “New Report”. A questo punto si possono estrarre dati dalle tabelle, creare grafici, datagrid, cruscotti, ecc…
0 comments:
Post a Comment