Skip to content
AIV

Table

Ad-hoc reports means on the spot creation of reports (which are not pre-built) based on the client’s requirement by connecting to live environment.

Objective

Create Adhoc Report using Table

Prerequisite

Used Sales.cds for this example.

Download adhoc_analysis.zip file from link given adhoc_analysis.zip.

After downloading the zip file, add the Sales.cds into the Dataset Section of AIV for this example. To add it into AIV follow this Link.

This video contains information regarding How to Create Adhoc Report using Table in AIV.

Table component feature

Add the Table component: To add the table component in content page, drag and drop the table component from the menu to the center content page. the empty table looks as shown below: Image here!

Dataset: From dataset dropdown user can add the required dropdown and can create and view from here to. as user selects the dataset, the value column names appears on the Dataset Columns list below the dataset dropdown.

Columns: User can add more then one column in the adhoc report, user need to simply drag and drop the column from the list to the column area.

Group: It allows user to make the data group from the group area, user can add the column here and it takes the values automatically to form data groups in the adhoc report.

Filter: The filter column allows user to add the filtered values, the user can add the required filter values by editing the added column. the filter allows user to choose the condition from Equal to, Between, Not Between, Bottom N, Bottom Percent, Greater then, Greater then or equal, Less then, Less then or equal, Like, Match, Not Match.

Steps to Create Adhoc Report using Table

  1. Drag & Drop Table component to the empty area as shown below:

    Image

  2. As user perform the above step, window will look as per the image below:

    Image

  3. Now from the drop down list of Datasets select the Sales.cds as follows:-

    Image

  4. Add country to productLine & year to Columns field by dragging it from Dataset Columns. Similarly, add country to Groups & extendedPrice to Aggregation field by dragging it from Dataset Columns.

    Image

Group Sorting

  1. User can perform sorting on column added in group. To perform sorting, click on setting icon available just right side of group column added as shown in below image,

    Image

  2. Click on drop-down of Sorting as shown below:

    Image

  3. Select the type of sorting you want to apply on this column and click on submit. For this example: select Ascending Type.

  4. Now when you run your report, it will be grouped by Group column and group will be displayed by sorting order as we have selected.

  5. Click on Submit button & your sorting will be saved.

  6. The report will group the products with the same productLine, filter them based on the country name, sort the data in ascending order based on the extendedPrice.

  7. Click on button right next to extendedPrice Aggregation & your screen will look as per below:

Image

Image

  1. You can specify the format by clicking on the Image button right next to Format box will opens the following dialog box:

    Image

  2. Select Format Type as & Format AS as required from the drop-down. And as you click on Submit button your window will look as per below:

Image

  1. Fill the below detail:
  • Symbol: $

Image

  1. Click on Submit button & your window will look as per below:

Image

  1. In Aggregate On radio button select Groups & Select Country in Group drop-down.

Image

  1. Click on Submit button to Save the changes.

  2. Select LANDSCAPE VIEW from the Birt Template drop-down as shown.

Image

  1. You can also specify the number of records you want to show on a page from the following widget near the template selector widget:-

    Image

  2. User can select format in which they want to run the report from the drop-down near to RUN option.

Image

  1. For this example, we select Run as HTML.

  2. To run the Adhoc Report using Table Component, click on Run in the top most right corner as follows:-

    Image

  3. Click on RUN option, which will open the following dialog box:-

    Image

  4. As the table has no parameters, just click on SEND button & it will redirect you to another screen of the browser.

Image

  1. The Adhoc Report using Table component will be generated in HTML.

    Image

  2. If you want to save your table you can click on the Save Image button at the topmost right corner below admin which will open the following dialog box:-

    Image

  3. You can give your own Name in the selected column, and select Save As a Report / Template.

  4. For this example: give Name: Adhoc Table & Select Save As: Report and click on submit button to perform the save operation.

  5. If you want to change the settings of a widget click on Image below Run which will open the following dialog box:-

    Image

  6. Here you can change the Name, Width, Height, Visibility and Page Break of your table & click on Submit button to save the changes.

  7. Similarly press Image in order to delete the table component.

The following graphical elements are available in Adhoc reports:

Adhoc Table
Adhoc Chart
Adhoc Image
Adhoc Annotation
Adhoc Text
Adhoc Pivot
Adhoc Pre-defined Components