If this is your first visit to our forums, welcome!
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
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)
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 blog is about XML readability. Since 1999 DataFlex is capable to handle XML in and XML out via classes defined in the FleXML.pkg (cXMLDomDocument etc). One of the most heard remarks in support questions is how to make XML readable for the human being as Microsoft XML writes the XML data as one long line of text. While OK most developers want to be able to read the content in an editor. You can easily format the XML file with tools like Notepad++ but how to do this from your own code? ...
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 ...
If you are migrating a web application from Visual DataFlex 17.1 to DataFlex 18.0, you might need to take an extra step to get your application to successfully compile and run in the new revision. This is due to a change in the tWebRow structure used in DataFlex Web Framework. Background To understand the two main reasons for this change it is important to understand how this worked under 17.1. When the DataFlex web framework was developed, ...
Updated 24-Apr-2014 at 10:03 AM by Dennis Piccioni
It takes one mouse click on a total column heading in a Dynamic AI report to make it a Top 10 or Bottom 10 report, and just a few mouse clicks can combine multiple Top 10 reports into a single presentation like this Top 10 dashboard. But what if you want to let the user choose the number to rank, and choose if the report ranks from the bottom instead of the top of the totals? What if, unlike the examples presented in the above Top 10 Dashboard, you also want the rank number to appear on each row? ...
Dear Developers, we have moved our blogging environment from the forums to our new web site. We hope to continue to provide fresh and useful information to you, our customers. Please visit our new blogging home. There are already numerous blog posts waiting for you.
A standard feature of the Internet Information Server is HTTP compression. This module is available to optimize the performance of web applications by compressing HTTP responses that are sent to the client. The goal is to decrease the size of the responses to allow faster network transmission. Of course this has the side effect that the CPU usage increases on the server (and on the client). So we are trading CPU usage against bandwidth here. This means that HTTP compression doesn't always make your ...
Updated 17-Feb-2014 at 04:26 AM by Harm Wibier
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 ...
Updated 16-Dec-2013 at 12:24 AM by Vincent Oorsprong
At the Data Access forums I found a question if it was possible to respond when the computer enters the sleep modus. The topic draw my attention and I decided to play around a bit. In this blog you learn how to make respond code. Notification event Windows can send a notification message to your application when changes occur in the power status. To be able to receive the notification message the application needs to register itself for receiving these messages. This is done with ...
Depending on what you are working on, certain improvements in security that Microsoft implemented become annoyances in your test environment. On Windows Server 2003, my favorite two that I need to turn off immediately are: 1. Internet Explorer Enhanced Security Configuration 2. Shutdown Event Tracker 1. Internet Explorer Enhanced Security Configuration By default, this is enabled on Windows 2003. Whenever you open IE, you get the message below displayed ...
In [URL="http://support.dataaccess.com/forums/blog.php?b=26"]Part I[/URL] we were just getting warmed up and started looking at the basics of arrays and struct types. Now things are about to get more complicated as we dig in deeper. [B]Sorting Arrays[/B] If you have [I]Integer[] myArray[/I] for example, then sorting is very simple and straightforward. You simply do [I]Move (SortArray(myArray)) to myArray[/I], and you're done. The runtime takes care of all the magic ...
Always wanted to know what drives are available in your computer? Wanted to know what the status of the drive is? Wanted to know the serialnumber (e.g. 503E-A401)? Wanted to know is filename casing preserved? No... then go to the next blog. Yes, read on... Drives Visual DataFlex has a command called GetDskInfo. You pass it an integer and because drives can be assigned to a drive letter there is a maximum of 26 drives. So we can make a loop through all the drives. In the following ...
What??? Connectivity Kits and Visual DataFlex combined in one serial number? How can I use it? What about the web server? Can I use the same registration program to enter all my licenses? Which license should be active? And what does being active mean anyway? If those questions have crossed your mind but you never really asked them, just carry on reading; this is your chance to get them all answered. The Pieces: Types of Licenses How does Data Access ...
Updated 29-Jun-2016 at 05:04 PM by Marcia Booth
In Visual DataFlex 14.0 we made a major change in the way we size dialogs. Instead setting a size based on the dialog's outer window size, we sized it based on the Client Area Size. It might be worth explaining how we came about making the Client Area Size change. We recognized that moving Views and modal panels to Windows Vista was going to create the exact same size issues that occurred when developers moved the applications up to Windows XP. In both cases either borders or caption ...
Updated 27-Jul-2009 at 02:14 PM by Development Team
A normal uninstall procedure of DataFlex revision 19.0 and earlier requires three simple steps: Run Programs and Features (accessible through Control Panel on your Windows machine)Select to uninstall DataFlexRestart your computer to finalize the process (and release anything DataFlex that was loaded in memory) Sometimes users fail to execute step 3 and go straight to installing another build of DataFlex. What might happen is that files not released from memory will still be ...
Updated 8-Apr-2023 at 09:05 AM by Marcia Booth