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.
![Adhoc Report](https://www.helicalinsight.com/wp-content/uploads/2017/07/2-4.png)
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’ icon
![Adhoc Report](https://www.helicalinsight.com/wp-content/uploads/2017/07/4-1.png)
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 on
![Adhoc Report](https://www.helicalinsight.com/wp-content/uploads/2017/07/6.png)
Different icons are used to represent different type of data. This helps the user to identify the type of data while creating a report.
For More Info, Contact us at demo@helicalinsight.com