HTML / XTML Reports 1

[fmoore0001]

Does anyone have experience with setting up the Report Writer to create HTML or XTML documents? The company where I am doing a temporary Clipper (yes, Clipper) job uses Clipper to create such documents, but I will bet someone has come up with a way to use the report writer in the same way.

Frank

 

[Mike Gagnon]

How about XML? Since XTML an an Excel version of XML.

Here is a sample (smoe of which come From Ramani's code in another example)

CREATE CURSOR test (cName C(20), email c(20))
INSERT INTO test (cName, email) ;
     VALUES ("experts","experts@Tek_tips.moc")
INSERT INTO test (cName, email) ;
     VALUES ("Dummy","dummy@dummy.moc")
INSERT INTO test (cName, email) ;
     VALUES ("ClayHead","clay@dummy.moc")
INSERT INTO test (cName, email) ;
     VALUES ("WoodBrain","wood@Tek_pits.moc")
INSERT INTO test (cName, email) ;
     VALUES ("IronHead","iron@dummy.moc")
INSERT INTO test (cName, email) ;
     VALUES ("BigHead","big@dummy.moc")
INSERT INTO test (cName, email) ;
     VALUES ("ShowMan","showbiz@dummy.moc")
INSERT INTO test (cName, email) ;
     VALUES ("NutHead","nuts@dummy.moc")
INSERT INTO test (cName, email) ;
     VALUES ("Ramani","ramani@Tek_tips.moc")
INSERT INTO test (cName, email) ;
     VALUES ("Mike","mike@Tek_tips.moc")
INSERT INTO test (cName, email) ;
     VALUES ("Rick","Rick@Tek_tips.moc")
INSERT INTO test (cName, email) ;
     VALUES ("Chris","chris@Tek_tips.moc")
INSERT INTO test (cName, email) ;
     VALUES ("Dsumzz","dsumzz@Tek_tips.moc") 
INSERT INTO test (cName, email) ;
     VALUES ("mySelf","me@Tek_tips.moc")
CursorToXML("test", "c:\myXMLFile.xml", 1, 512, 0, ;
       "mySchema.xsd", "[URL unfurl="true"]http://www.microsoft.com/mySchema.xsd")[/URL]

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[fmoore0001]

Now that is cool. Whole new area to research. Thanks Mike.

Frank

 

[baltman]

To gain more control you may want to look into TEXTMERGE() and SET TEXTMERGE, and/or the methodology used in faq184-3005.

Brian