I have written a stand alone application at work to create custom reports on our DNN site.

I have been able to work out all the DNN tables and how to grab results, but I noticed that you've used XML to save multi results into one field.

Since you wrote the program, can you please let me know the SQL statement to read from FormMaster 1.6 results.

Looking for:
Extracting from the XML saved table fields...
 The FormMaster Form name.
 The FormMaster Field names (stored in xml)
 The FromMaster Field value (stored in xml)
 Count total entries by grouping the FormID

I have tried a few methods but failed :)

You obviously use the sql statement/s withing the report buttons of the module, so all I'm really asking for is something you already know.. please.

Data is stored as XML fragments in the database.
When the report is run fragments are returned for the specified datespan.
When the data is returned to the process an XSL transformation takes place to convert the data to an XML representation of a DataSet.
The DataSet is then used to bind to the DataGrid

In Form Master 1.6 There is not an easy way to access the data as you would a normal SQL Table
Form Master 2008 allows you to map your forms to normal SQL tables. In this case you could do what you want with the data.

If you were to upgrade you could map the existing form to a table and import the existing data as long as it is consistant as to datatype etc.