Be sure to
check out our forum FAQ. You must register
to post messages. To view messages, select the forum that you want to visit from the selection below.

----
Please note: messages from the forum administrator are sometimes being rejected by Spam filters. Please make sure you can receive the administrator's messages by whitelisting forumadmin@dataaccess.com.

Our migration of the Portuguese forum had file upload issues and will need to be rescheduled. We apologize for the inconvenience. The forums are now back online and available for use.

Development Team Blog

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
...

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
...

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?
...

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.

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
...

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
...

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
...

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
...

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)
...

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
...