View RSS Feed

All Blog Entries

  1. Visual Report Writer and The Web (IX)

    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 ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2013-06-02_082810.jpg 
Views:	4022 
Size:	56.1 KB 
ID:	6502  
  2. Visual Report Writer and The Web (VIII)

    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 ...
  3. Visual Report Writer and The Web (VII)

    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 ...
  4. Visual Report Writer and The Web (VI)

    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 ...
  5. Visual Report Writer and The Web (V)

    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 ...
  6. Visual Report Writer and The Web (IV)

    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 ...
  7. Visual Report Writer and The Web (III)

    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 ...
  8. Visual Report Writer and The Web (II)

    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)

    Categories
    Uncategorized
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	invoice table relationship.jpg 
Views:	3375 
Size:	253.9 KB 
ID:	6357  
  9. Visual Report Writer and The Web (I)

    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 ...
  10. Report Data Sources

    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)

    Categories
    Uncategorized
  11. How to Create a Checkbox in Your Report?

    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 ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	CheckboxInResults.jpg 
Views:	4893 
Size:	80.7 KB 
ID:	6111   Click image for larger version. 

Name:	ChecboxFunctionInUse.jpg 
Views:	3551 
Size:	77.0 KB 
ID:	6112  
    Attached Thumbnails Attached Files
  12. A Line Around Your Report

    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 ...
    Attached Thumbnails Attached Files
  13. Saving Error Messages in Text Form

    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

    Categories
    Uncategorized
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	CannotDeleteError.png 
Views:	1469 
Size:	16.0 KB 
ID:	5294   Click image for larger version. 

Name:	UnhandledError.png 
Views:	1479 
Size:	22.2 KB 
ID:	5295  
  14. Recursive Use of Structs and Arrays

    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 ...
  15. Fonts in Visual DataFlex

    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 ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	16.1 XP 100.jpg 
Views:	2711 
Size:	46.2 KB 
ID:	5137   Click image for larger version. 

Name:	16.1 XP 125.jpg 
Views:	2331 
Size:	47.8 KB 
ID:	5138   Click image for larger version. 

Name:	17.0 (old) XP 100 system.jpg 
Views:	2386 
Size:	43.4 KB 
ID:	5140   Click image for larger version. 

Name:	17.0 (old) XP 125 system.jpg 
Views:	2170 
Size:	55.0 KB 
ID:	5141   Click image for larger version. 

Name:	17.0 (new) XP 100 system.jpg 
Views:	2257 
Size:	46.5 KB 
ID:	5142   Click image for larger version. 

Name:	17.0 (new) XP 125 system.jpg 
Views:	3466 
Size:	59.7 KB 
ID:	5143   Click image for larger version. 

Name:	16.1 Win7 100.jpg 
Views:	2370 
Size:	43.3 KB 
ID:	5144   Click image for larger version. 

Name:	17.0 (old) Win7 125.jpg 
Views:	2102 
Size:	42.5 KB 
ID:	5145   Click image for larger version. 

Name:	17.0 (old) Win7 100 system.jpg 
Views:	2309 
Size:	46.0 KB 
ID:	5147  

    Click image for larger version. 

Name:	Test 16.1 Win7 100.jpg 
Views:	1908 
Size:	18.6 KB 
ID:	5148   Click image for larger version. 

Name:	Test 17.0 Win7 100.jpg 
Views:	2029 
Size:	19.7 KB 
ID:	5149   Click image for larger version. 

Name:	Test 17.0 (new) Win7 100.jpg 
Views:	1970 
Size:	20.8 KB 
ID:	5150  
  16. An Error Has Occurred On The Server...

    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)

    Categories
    Uncategorized
  17. Use of Runtime Data Source with Visual Report Writer

    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 ...
  18. Displaying Country Flags in a cDBCJGrid

    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)

    Categories
    Uncategorized
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2012-04-24_225156.jpg 
Views:	1749 
Size:	66.4 KB 
ID:	5041  
  19. How to Use SOAP Headers to Limit the Lifespan of a WebService Call

    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)

    Categories
    Uncategorized
  20. Unable to Compile Applications in the Studio?

    by , 3-Nov-2011 at 01:21 PM (Development Team Blog)
    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)

    Categories
    Uncategorized
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	1456 
Size:	41.7 KB 
ID:	4706  
Page 2 of 8 FirstFirst 12345 ... LastLast