Forums
This topic is locked
Outputting Data...HELP!
Posted 22 May 2002 17:42:33
1
has voted
22 May 2002 17:42:33 carolus Holman posted:
Simple problem, after my customers fill in a 56 step form (12 Pages in paper) I need to output the Data from over 25 tables into a single comprehensive document. The only way I know how to do this is to use the Stored Procedures I have written to "Get" the data out of SQL2000 and then dump it section by section in to a page. The problem (I think) is having up to 12 Procedure calls per Section (7 sections in all) this would create a huge file. Some of the sections have repeating information like contacts, key personnel, these call the same tables but use a different "Key" like 1=Main Office, 2= Key Personnel etc. I have heard but not used XML, XSL is there any GOOD solutions out there? The total output could be (but not limited to) at minimum 250 fields.Carolus Holman