web analytics

Bv Of Euro Bv

Data Access Europe Kingsday 2016

Nick, we've got a great idea for the Kingsday tutorial for this year! We were thinking about an orange helicopter with our logo and… No Henri can you bring your orange motorcycleé …and drive the outline of our icon on one wheelé Whaté! No! Jeroen, Jeroen can you… No

Esther, Esther will you… No! Arnold, we want to. No Guys, will you wear an orange dress… …for the Kingsday tutorialé No! Nigel can you design a Kingsday theme…

…for DataFlex for the tutorialé Sorry guys, we have tried our hardest to create an awesome Kingsday tutorial again… Yes, but it didn't really work out this year Are the camera's goneé Yes, their gone!.

DataFlex Reports New feature in DataFlex Reports 40 Runtime Data Source RDS

Hello, welcome to this presentation aboutDataFlex Reports version 4.0. I am going to talk to you about RDS, which stands for Runtime Data Source. RDS was already available in previous versions of DataFlex Reports, butin version 4.0 we have added a new enhanced wizard to support it, and making live easyfor you as a developer. I want to show you what RDS is and what the benefits of using it are. Next, this tutorial explains how the new wizard works and howyou can even work with a nondatabase datasource, if you need to. RDS stands for Runtime Data Source, meaning the data is collected by a DataFlex application,at Runtime.

The data will be captured in an inmemory array, and can come from a database,or nondatabase, think for example about web services. So, RDS relates to DataFlex reports and how the data is fed into a report. To give you an overview of its architecture, let me show you the situation using DataFlex Reports without RDS, and then what your options are with RDS. Illustrated here, is the DataFlex ReportsStudio, with which you 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 theDataFlex Reports Studio and what will happen is that the OCX will run the report.

The OCX will also facilitate the connection to the database for you and create the output. No RDS needed here. Another option is to integrate a report ina DataFlex application. Programming in DataFlex Studio allows to provide a userfriendly interfacefor the enduser to make certain selections before running the report. Fired by the DataFlexapplication, the report is executed by the OCX, and again the OCX is taking care of thedata collection. No RDS needed here. Next step introduces RDS, let's have a lookat that. The conceptual difference with the previoussituation is that the data will no longer

be collected by the DataFlex Reports OCX.In this case the application collects data from a database, fills an RDS array in memoryand passes the data in the array to the DataFlex Reports OCX. Like before the OCX producesthe output. The new DataFlex Reports integration wizardwill do two things for you: firstly, it creates an RDS report and then it will generate DataFlexsourcecode to populate the RDS array with data from a database, using data dictionaries.From here, in DataFlex Studio, you can use custom code to enhance the DataFlex application. In DataFlex Reports you can fully design the report layout.

What this gives you, is fullcontrol over data and design. Finally, there is a similar situation, butinstead of using a database and data dictionaries, a totally different type of source for datacollection can be used. The data may come from a web service, embedded SQL, a filebased system, Excel sheet, you name it. The report must be created in the DataFlex Reports Studio and produces the output, but the DataFlex application will take care of the data. I hope that this gives a clear picture of your options. RDS gives the programmer full control over how the data is collected.

RDS is not always necessary, but let's look at some examples in which RDS would be smart to use, or in some case, could not be done without it. The Data Access football pool web application,for example, contains a number of web service functions. The DataFlex Reports OCX couldnot read from this, since it cannot connect to it as a database. Some of the functionsreturn statistic information such as the number of yellow and red cards shown to a player.A DataFlex Application can call these web service functions and process the returneddata into an RDS array. The DataFlex Reports OCX will format the data and produce the output.

Leave a Reply