• Could not find what you are looking for? open a support ticket.
  • Support

Adding table widget to the Ad-hoc Reports in the AIV application

In order to create a table follow the following steps:-

  1. Drag and drop the table to empty area as shown below:-



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



  3. You will see all the columns of the Dataset under Dataset Columns.
  4. Add productCode, productName, productLine, and priceEach in first Column by dragging the field and dropping it to Column 1.
  5. In a similar fashion, add orderNumber to Groups, order Date to sortable and priceEach to Aggregation.
  6. The report will group the products with the same order number, filter them based on country name, sort the data in ascending order based on the date on which the product was ordered.
  7. In aggregate we have mentioned priceEach, In order to perform an Aggregation function click on .
  8. This will open the following dialog box:-



  9. Enter the display name as Price and Data Type as Integer.
  10. In order to specify the Expression, click on Expression builder as follows:-

  11. In the Category select Available Data sets.
  12. Select All Columns in sub category and double click pricerEach to use the expression. Click the submit button.
  13. You can specify the format by clicking on the button which opens the following dialog box.



  14. Select format type as Number and Format As Currency from dropdown.
  15. Round up to 2 decimal places, with Rounding mode Half Up and Symbol $ with position of symbol Before the number.
  16. Hit the Submit button to save the format and again hit submit to save Aggregation.
  17. In order to run the table widget click on Run in the topmost right corner as follows:-



  18. For this example, we select Run as HTML.
  19. Click on HTML which will open the following dialog box:-



  20. As the table has no parameters, just click on Send.
  21. The following table will be generated in HTML.



  22. You can change the template format from the BIRT Templates as follows:-



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



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



  25. You can give your own name in selected column, and select format as Report/Template and press submit button to perform save operation.
  26. If you want to change the settings of a widget click on below Run which will open the following dialog box:-



  27. Here you can change name, width, height and visibility of your table.
  28. Similarly press in order to delete the table widget.

In the next section we will learn how to create chart widgets.

Could not find what you are looking for? open a support ticket.