To continue with this content, please log in with your Data Access ID or create a new account.
Cancel Data Access ID
You may not be authorized to see this content. Please contact Data Access Europe for more information.
Cancel Data Access Europe
You are not authorized to see this content.
Cancel Data Access Europe
Next lesson:
Working with non data in RDS


Lesson 3: Working with the new RDS feature

  1. To start the new wizard select ‘Create new..’ and choose the ‘DataFlex Reports wizard’ option.
  2. Press next and select the ‘Create New RDS Report (Using Data-Dictionaries) option.
  3. The next window shows a list of all data dictionaries for the current workspace.
  4. The toolbar above the list, let’s you sort the data dictionaries by number, or to search for a specific table. 
  5. Select the ‘OrderHea_DataDictionary(OrderHea)’ and go to the next window.
  6. The order header table relates to a customer and a salesperson table. The source table page will therefor automatically show three tables instead of only the selected order header table.
  7. Select the source column’s with the data that has to go into the RDS Array. Selecting the first column pops up a dialog where you need to pick a table to collect the data from. Click the ‘Order_Number’, you’ll notice that the ‘OrderHea’ is pre-selected.
  8. In the column labelled index, select the correct index, in this case ‘Order_Number’. 
  9. As a result, the list on the right now shows the name of the RDS table, the selected table index and column.
  10. Add some more colums from the order header and customer table, finally rename the ‘RDSTable1’ to ‘Orders'.
  11. In the next window, specify the file name, location and select a page setup.
  12. Accept the default options in the Name Fields window.
  13. Skip the part that would allow end users to make selections. You can do that later by writing DataFlex source code.
  14. On the ‘Sort Fields’ page, select the sort ‘OrderDate’ option, we won’t allow end users to make any changes.
  15. The options page lets you define which output destinations should be available and where to show the preview.
  16. The project options page is for specifying which projects images need to be embedded for use in toolbars. Finally click next to complete the wizard.
  17. The result is loaded in the studio.
  18. Switch to source code, to see what the wizard created.
  19. On line 18 to 23, the wizard created 2 data dictionary objects that will be used for finding data.
  20. Scrolling down the code you can find the function ‘AddRDSData'.
  21. In this function the order header data dictionary is instructed to find all order header records sorted by the first index as we told the wizard to do. 
  22. For each of the selected source columns a statement has been coded to move the data into the array. The RDS array is named vData and is a two dimensional array. Each record from the order header table will take up a row in the first dimension, and each selected column will be stored in the second. 
  23. Before running the report, set up a filter in the customer data dictionary.
  24. We only want to see customers from Florida and New York. Compile the application and view the results in the integrated RDS report.
  25. The layout can be improved. For example, the order date shows a window long-date, while there is not enough space for a long-date.
  26. Switch over to DataFlex Reports studio to load the report and change the layout.
  27. After saving the changes, the report can be previewed within the application. It is not necessary to make any application changes. The report looks much better already!
  28. Now you know how the new wizard works. It was designed so that it would take you little time to get this result.