If this is your first visit to our forums, welcome!
In this ninth blog about Visual Report Writer and the Web I want to take you to the next report that can be found at the Live Demo website (European Server, USA server) named FileList (RDS). If this is the first blog you read I encourage you to read the eight other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist, 6: The Credit and Balances Overview), 7: Inventory Stock Levels) and 8: Sick Leave). Meanwhile we have been able to release the Alpha II version of Visual Report Writer 3.0 ...
Updated 1-Dec-2013 at 12:35 PM by Vincent Oorsprong (Images enlarged)
In this eighth blog about Visual Report Writer and the Web I want to take you to the next report that can be found at the Live Demo website (European Server, USA server) named Sick Leave. If this is the first blog you read I encourage you to read the seven other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist, 6: The Credit and Balances Overview) and 7: Inventory Stock Levels). Between the fourth and the fifth blog we have been able to release the ...
Updated 1-Jun-2013 at 10:51 AM by Vincent Oorsprong
In this seventh blog about Visual Report Writer and the Web we look at the next report that is available on the Live Demo website (European Server, USA server) named Inventory Stock Levels. If this is the first blog you read I encourage you to read the six other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList, 5: The Orderlist and 6: The Credit and Balances Overview). Between the fourth and the fifth blog we have been able to release the Alpha I version of Visual Report Writer 3.0 ...
Blog number six in this category about Visual Report Writer and the web integration. I will talk about the next report that you can find on the Live Demo website (European Server, USA server) named Credit and Balances Overview. If this is the first blog you read I encourage you to read the five other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup, 4: The CustomerList and 5: The OrderList). Between the fourth and the fifth blog we have been able to release the Alpha I version of Visual Report Writer 3.0 ...
Updated 9-May-2013 at 03:38 AM by Vincent Oorsprong
In this fifth blog about Visual Report and The Web I will talk about the next report that you can find on the Live Demo website (European Server, USA server) named OrderList. If this is the first blog you read I encourage you to read the four other blogs (1: The Solution, 2: Invoices Report, 3: The Cleanup and 4: The CustomerList). Between the fourth blog and this one we have been able to release the Alpha I version of Visual Report Writer 3.0 and the 2.1+ Library only setup. The latter one is needed ...
Updated 8-May-2013 at 01:53 AM by Vincent Oorsprong
In this fourth blog the Customer List is the topic. Ehh, a customer list, isn't that too simple for a demo and a blog? Yes and no. A customer list running on the Web Order Customer table is in fact a simple report but as you discover below we have added a couple of features to make the report and integration more attractive. To see the here discussed report in action you should navigate to the live demo website (European Server, USA server). You are also advised to read the three previous blogs ...
This is the third blog about Visual Report Writer and the Web. Did you already digest the other two blogs (Solution Page and Invoices Report)? If not, I suggest you read them first. This blog is about cleanup at the server. It is not the last one in the serie. Cache files From the blog about Invoices Report you should have learned that the integration library instructs Visual Report Writer to create a PDF file with the output of the report. By default this output file is only ...
Updated 18-Aug-2013 at 10:03 AM by Vincent Oorsprong
As follow up story on Visual Report Writer and the web this time the first report available on the demo website for Visual Report Writer. You might think "only one?" but read on and discover that there is enough to tell about this report and the integration. Invoices Report The first report that can be started on the website is called Invoice. The report uses the Microsoft Adventure Works 2000 database as its data-source. The report uses 14 tables to build the results. Very ...
Updated 1-Dec-2013 at 12:36 PM by Vincent Oorsprong (Images enlarged)
At the just ended Synergy 2013 conference held in Nashville, Tennessee we have shown how easy it will be to make Web Based Applications using the DataFlex Web Application Framework. One of the parts of a Web Application will be reporting. Data Access advises two reporting solutions; Dynamic AI and Visual Report Writer. During the Synergy sessions (symposium and trainings) demonstrations were given how relative easy it is to integrate the two reporting solutions in a Web Application made with the ...
Updated 15-Apr-2013 at 07:25 AM by Vincent Oorsprong
This blog contains information on choosing and changing the data source in the Data Access report writer. Data Source? During the creation of a new report a data source needs to be selected. A data source makes it possible for the report writer to access the rows of data in tables. Currently 3 data source categories are available; DataFlex, ODBC and RDS. DataFlex For the DataFlex database the data source is either the list of tables (usually named filelist.cfg) ...
Updated 25-Feb-2013 at 10:24 AM by Vincent Oorsprong (Two functions added)
Often a picture says more than a 1000 words... Well, a checkbox is not a picture but if well used it can draw the same kind of attention to the reader of the report results. Assume you want a checkbox on results of your Visual Report Writer report, how could you do this? First look at the following screenshot that shows what I mean with using a checkbox in your report output. If the phone ...
Updated 1-Dec-2013 at 12:39 PM by Vincent Oorsprong (Images enlarged)
In this short blog I want to show you how you can make a line around the output of your Visual Report Writer report. Visual Report Writer does not have a box - or a line - object that can go over multiple sections. The development team has granted to need for such a feature and will implement this via a page layer. In general: objects should not go over sections. A Fake Box What is a box? A box is a rectangle consisting of two horizontal and two vertical lines. This means it is ...
Updated 19-Aug-2012 at 05:10 AM by Vincent Oorsprong
Did you know that in Windows most error messages can be converted to text using the Copy (Ctrl+C) function? This is a tremendous, yet somewhat hidden and thus underutilized, feature of Windows. Most importantly, it works with standard Visual DataFlex errors and all messages based on the standard Windows MessageBox interface (see Message_Box, Info_Box, Stop_Box, etc. in the Visual DataFlex help index). So, for example, if you run the Order sample workspace and try to ...
Updated 1-Dec-2013 at 12:40 PM by Vincent Oorsprong
In a recent post at the forums the question was given how to make use of a recursive struct. Years ago I wrote a training manual about Structs and Arrays and in one of the exercises the trainees had to write a routine that could read the files in a folder from a disk. A folder can have 0-N files and 0-N sub-folders. In this blog I will explain you how you can build the code to read the information using arrays and structs. Nested Structs Because a folder can have 0-N files and ...
There are many aspects to the discussions about how the new font system in Visual DataFlex works when compared to the old. This is actually a complex topic with a lot of different perspectives – so this blog might be on the long side. I promise to do my best not to ramble (too much). I’ll start by stating that the main goal in wirting this is to get everyone to a common understanding of the way fonts work: how the old system functioned, what we changed in moving to the new system and ...
This blog was created to tell you what to do when you get this error while starting a Visual DataFlex web application in particular Electos Studio. The error An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error.An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator ...
Updated 15-May-2012 at 02:46 AM by Vincent Oorsprong (Adding information about exposure of information)
One of the new features of Visual Report Writer version 2.0 will be support of a Runtime Data Source (RDS). A runtime data source is a virtual table that is defined during report definition while the data is supplied via integration. This opens the way to report of data that does not come from a "real" database. In this blog you will read how to make a report based on the filelist. Report Definition Start Visual Report Writer and press Ctrl+N for a new report (or choose New Report ...
Updated 30-Apr-2012 at 12:53 AM by Vincent Oorsprong
In september 2011 I published a blog about using other graphics in a cCJGrid class object. Today at the bi-monthly held drive-in support events in Germany hosted by Data Access Europe I was asked about how to do this with a database aware CodeJock based grid. With this short blog I will tell you how you can do this. Base For this blog I will be using a customer table that we also use for the Discovering Visual Report Writer book that is available from Data Access Europe. This ...
Updated 1-Dec-2013 at 12:42 PM by Vincent Oorsprong (Images enlarged)
In this blog I will show you how you can limit the amount of time that an application can call a webservice function. It is a small contribution to security and helps you against unwanted webservice calls. SOAP Headers A SOAP based WebService call always contains a body section and optionally can contain a header section. The use of a SOAP header section on both the Visual DataFlex server as well as client side is good documented in the help provided with the product. The good ...
Updated 31-Dec-2011 at 07:59 AM by Vincent Oorsprong (Made a link to the conversions library)
Do you use Windows 7 or Windows Vista? Are you having problems compiling your application in the Studio? I'm not talking about compiler errors, I'm talking about the Studio reporting that it cannot delete the old application .exe file before compiling the new one! If you are seeing that problem then read on, I may have the solution (or at least a little good advice)... [B]System Tune Up[/B] Ages ago I had turned off the windows [I]Application Experience[/I] service ...
Updated 1-Dec-2013 at 12:44 PM by Vincent Oorsprong (Images enlarged)