Flash grid tutorial

This Flash grid tutorial will demonstrate the use of the Flash grid and how it can be used to view and chart tabular data.

Creating a portlet as a Flash grid

1. In Web Studio, click the Portlets menu item on the far left menu.

2. In the right-hand frame, click New to open the Portlet Builder window.

3. In the Portlet Builder window, click the downward arrow button to the right of the Add button.

4. In the menu that displays, select Database Element to open the Database Element Definition window.

5. In the Database Element Definition window, select Connection Cache, and enter:

   • Conn Cache Name – sampledb

   • SQL Query String:

     select so.region as Region, sum(soi.quantity*p.unit_price) as Total, count(distinct so.id) as 'Number of Orders', round(Total/count(distinct so.id), 2) as 'Avg SO Total' from sales_order as so, sales_order_items as soi, product as p where so.id = soi.id and soi.prod_id = p.id group by so.region order by so.region
     

6. Click Preview to test the values entered.

   Click Next.

7. In the Split window, click Next as this example does not use the data splitting feature.

8. In the Define window, click Next as this example does not use this feature.

9. In the Filter window, click Next as this example does not use this feature.

10. Enter SO by Region as the name for the element, then click Next.

11. Click Finish to close the window and return to the Portlet Builder.

12. Save the portlet:

    1. Click Save, and in the windows that displays, enter:

       • Portlet Name – Regional Sales Grid

       • Version – select Off.

    2. Click Add All to add all the roles to the portlet.

    3. Click Finish.

13. Back in the Portlet Builder click Template. This template will replace the table/grid with the Flash Grid movie file.

14. In the Find Template window, from the Type drop-down list, select jsp. Click Search.

15. On the right hand side a list of JSP templates displays. Highlight the FlashGrid listing by clicking on it once, then click Select.

16. The Find Template window closes and the portlet preview in the Portlet Builder is replaced with the Flash Grid.

    The Flash Grid appears to be empty. You can fully view the Flash grid from Web Studio or by deploying it to the Portal Interface. The Flash Grid cannot be previewed from within the Portlet Builder.

    Click Save.

17. Click Close to close the Portlet Builder.

18. Back in Web Studio the new portlet appears under the New category on the Status menu. Right-click the Regional Sales Grid portlet and select Preview.

    A fully working preview of the portlet will appear in a new window

If there are enough records in the data set, the Flash Grid automatically paginates the set and creates buttons below the grid that allow you jump to any page in the page set.

While viewing the grid of data you can sort the data by clicking on the column headers. One click sorts the data in ascending order, while a second click sorts the data in descending order. Clicking the Printer icon will print the Flash Grid.

Copyright © 2004. Sybase Inc. All rights reserved.

View this book as PDF