View RSS Feed

Development Team Blog

  1. DataFlex Report Writer: Currency symbol not relying on Windows Locale

    If you use a numeric column in a report where the value requires a currency symbol (e.g. article price, order total) you can format the field to print a currency symbol before the number. In the following screenshot is the Euro symbol seen in front of the Credit Limit, the Purchases and the Balance.



    For this you format the field and on the Number tab-page you can choose between "Windows Default ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Default Currency.jpg 
Views:	25773 
Size:	63.2 KB 
ID:	7439   Click image for larger version. 

Name:	Double Currency.jpg 
Views:	12086 
Size:	53.0 KB 
ID:	7440   Click image for larger version. 

Name:	Custom Mask.jpg 
Views:	10436 
Size:	59.7 KB 
ID:	7441   Click image for larger version. 

Name:	create mask parameter.jpg 
Views:	10223 
Size:	64.9 KB 
ID:	7442   Click image for larger version. 

Name:	currency mask function.jpg 
Views:	10941 
Size:	103.8 KB 
ID:	7443  
  2. More test data please...

    This blog covers a little project I recently have been working on to create a larger and more diverse data set for the order entry workspace delivered as one of the examples. The set of data in the database delivered with version 17.1 was already increased and changed. This was mainly done to get a better set of data for the demonstration of Dynamic AI integration in a DataFlex application. The data in older versions of the workspace was a bit outdated and limited in size. While the increase was ...
    Attached Thumbnails Attached Files
  3. Interactive Report in Windows with Visual Report Writer

    Now we are on the edge of delivering the final Visual Report Writer 3.0 I want to learn you how you can make use of the new interactive previewer that is available in the product. In this blog we create a report that shows all orders that used the current selected INVT item. Clicking on an order should bring up the order view with the clicked order found and displayed. Using the INVT table means that you can use the order entry example workspace.

    The Report
    The report needs to ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Inventory Ordered Report.png 
Views:	10672 
Size:	43.2 KB 
ID:	7061   Click image for larger version. 

Name:	select report.png 
Views:	10303 
Size:	15.6 KB 
ID:	7062   Click image for larger version. 

Name:	object names.png 
Views:	10272 
Size:	13.3 KB 
ID:	7063   Click image for larger version. 

Name:	remove filters.png 
Views:	10496 
Size:	9.8 KB 
ID:	7064   Click image for larger version. 

Name:	sort fields.png 
Views:	10067 
Size:	15.3 KB 
ID:	7065   Click image for larger version. 

Name:	options page.png 
Views:	10079 
Size:	13.5 KB 
ID:	7066   Click image for larger version. 

Name:	add image resources.png 
Views:	10414 
Size:	9.3 KB 
ID:	7067   Click image for larger version. 

Name:	options page 2.png 
Views:	10513 
Size:	9.6 KB 
ID:	7068   Click image for larger version. 

Name:	enlarged inventory view.png 
Views:	10372 
Size:	7.7 KB 
ID:	7069  

    Click image for larger version. 

Name:	invt view with report.png 
Views:	10396 
Size:	20.4 KB 
ID:	7070  
  4. How to use Windows API functions in Visual Report Writer

    by , 19-Jul-2013 at 04:37 PM (Development Team Blog)
    In this blog I’ll show you how to use Windows API functions in Visual Report Writer.
    We are using the function [B]PathFileExists[/B] exposed by the library ‘[B]Shlwapi.dll[/B] ‘

    Visual Report Writer uses the [B]VARIANT[/B] type to communicate with the External Library Functions (ELF). Because of this Windows API’s can’t be called directly, doing so will stop the rendering of the reports as Visual Report Writer expects a variant type to return and direct calling might even crash ...
  5. How to make your own ELF

    by , 19-Jul-2013 at 04:33 PM (Development Team Blog)
    In this blog, i'll show you how to make a function number2words for use in Visual Report Writer. We are creating a dynamic link library (DLL) containing useful routines that can be used by Visual Report Writer. Using External Library Functions (ELF) is a great way to extend the functionality of Visual Report Writer.

    This walkthrough uses C and assumes you understand the fundamentals of the C language and Microsoft Visual Studio 2008.

    [B]This blog covers the following:[/B] ...
  6. Visual Report Writer and The Web (XIII)

    In this thirtheenth blog about Visual Report Writer and the Web I want to tell you how you can make a report that is interactive. A demo of a report that does this can be found at the Live Demo website (European Server, USA server). If this is the first blog you read I encourage you to read the twelve 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), 8: Sick Leave), 9: FileList (RDS)), ...
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	2013-07-11_063308.jpg 
Views:	10604 
Size:	68.8 KB 
ID:	6611  
  7. Visual Report Writer and The Web (XII)

    In this twelfth blog about Visual Report Writer and the Web I want to take you some not really report related features that can be found at the Live Demo website (European Server, USA server). If this is the first blog you read I encourage you to read the eleven 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), 8: Sick Leave), 9: FileList (RDS)), 10: Four Wine Data Based Reports) ...
  8. Visual Report Writer and The Web (XI)

    In this eleventh blog about Visual Report Writer and the Web I want to take you to the last not yet discussed report that can be found at the Live Demo website (European Server, USA server) named top 10 sales persons. If this is the first blog you read I encourage you to read the ten 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), 8: Sick Leave), 9: FileList (RDS)) and 10: ...
  9. Visual Report Writer and The Web (X)

    In this tenth blog about Visual Report Writer and the Web I want to take you to the next four reports that can be found at the Live Demo website (European Server, USA server) grouped under Wines. If this is the first blog you read I encourage you to read the nine 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), 8: Sick Leave) and 9: FileList (RDS)). Meanwhile we have been able ...
  10. 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:	4736 
Size:	56.1 KB 
ID:	6502  
  11. 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 ...
  12. 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 ...
  13. 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 ...
  14. 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 ...
  15. 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 ...
  16. 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 ...
  17. 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:	3720 
Size:	253.9 KB 
ID:	6357  
  18. 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 ...
  19. 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:	5519 
Size:	80.7 KB 
ID:	6111   Click image for larger version. 

Name:	ChecboxFunctionInUse.jpg 
Views:	4201 
Size:	77.0 KB 
ID:	6112  
    Attached Thumbnails Attached Files
  20. 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
Page 1 of 2 12 LastLast