Ad-hoc reports are the type of reports which can be created instantly by using ‘Drag n Drop’ method. Users can select the columns from the tables present in the database and create reports on the fly. Multiple data sources can also be used to create Adhoc reports. The steps for creating a simple adhoc report are as follows:
Step 1: Click on the ‘Reports’ tab
Step 2: Open the file browser and choose the metadata (double click) required for creating the Report.
Step 3: Double click on the Table/Tables present in the left panel which then will show the columns present in that table/tables. Choose the column/columns and drag them to the selection area in the right panel.
Users can search the column name by using the search bar present above the Tables. Columns can also be added to the selection area by double-clicking on the column/columns present in the left panel.
Step 4: Click on ‘Generate report’ iconand then a tabular report will generate below the selection area on the right panel.
Custom column: User can add a custom column by writing SQL query and use this column for generating reports. For creating a custom column, click onicon and write the SQL query.
Different icons are used to represent different type of data. This helps the user to identify the type of data while creating a firstname.lastname@example.org