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:
Why should you use RDS
Cancel

RDS

Lesson 1: What is RDS?

Let’s go over two situations without using RDS and one situation with RDS, to give you an overview of the structure.

Situation one without RDS:

Illustrated above is the DataFlex Reports studio, which you use to create a report, when designing the report, you first choose a database, either with the wizard, or using the database expert. The report can be executed in the DataFlex Reports studio, and what will happen is that the OCX will run the report. The OCX will also facilitate the connection to a database for you, and create the output, no RDS needed for this situation.


Situation two without RDS:

Another option is the integrate the report with a DataFlex application. Programming in the DataFlex studio allows you to create a user friendly interface for the end user to make certain selections before running the report. 

Launched by the DataFlex application, the report is executed by the OCX, and again the OCX is taking care of the data collection, again, no RDS needed.


The next step introduces RDS.

The conceptual difference with the previous situation is that the data will no longer be collected by the DataFlex OCX. In this case the application collects data from the database, fills a RDS array in memory, and passes the data in the RDS array to the OCX. Just like before the OCX produces the output.


The new reports integration wizard will do two things for you:

  1. It will create an RDS report.
  2. Generate DataFlex source-code to populate the rds array with data from a database, using data dictionary’s.

From here in DataFlex Studio, you can use custom code to enhance the DataFlex application. In DataFlex Report you can fully design the report layout. This gives you full control over data and design. 


Finally there is a similar situation, but instead of using a database and data dictionary’s, a totally different type of source for data collection can be used. The data may come from a webservice, embedded SQL, a file based system, excell sheets or anything else. The report must be created in the DataFlex reports studio, and produces the output. But the DataFlex application will take care of the data.