Quote Originally Posted by mrkensr View Post
Thanks for getting back so quick. Maybe I didnt explain well enough...Im will be calling a stored procedure to get data. My program needs to produce an xml file from the returned recordset. That file needs to match the layout that I am getting from the client. The idea for this program is to be flexible so that when a client wants a xml file generated, they only need to specify what data they need & what layout they want the file to match. Right now I have a VB6 program that will generate Excel files and text files.
Well in my humble opinion you will have to write some code each time the client wants some thing different. My suggestion to you would be to get all the data they could possibly want. And when the want different portions of it you can apply an XSL transform to output an xml with the layout and data the client wants to see.