I am trying to build a small interface -
1. Get data from database with several rows and columns
2. Each column is has a where clause and hence I have built a query template that will accept parameters.
3. Put all the columns together to build a resultant recordset.
4. Put the resultset into excel and save the file.
I would like to know how to perform these steps in xMII. Can someone please help?
I greatly appreciate your response.