Loading ...
Sorry, an error occurred while loading the content.

Re: XSL to display flat XML in Table format

Expand Messages
  • raithnwno
    Nevermind, It appears with a for+xml+auto,elements&root=ROOT in the hyperlink query I can get nested results for easier stylesheets. Although fix one problem
    Message 1 of 2 , May 23, 2003
    • 0 Attachment
      Nevermind, It appears with a for+xml+auto,elements&root=ROOT in the
      hyperlink query I can get nested results for easier stylesheets.
      Although fix one problem and 10 pop up heh.

      --- In XSL-FO@yahoogroups.com, "raithnwno" <skilzz@h...> wrote:
      > Ok here comes a newbie from left field.
      >
      > I have a reletively flat XML file.
      > I am wanting to display it in a multi-column table so it looks like
      > the following:
      > http://www.neverlostdata.com/dcr/
      > (the ATX link is active on that test)
      > Would this be possible using xsl stylesheets?
      > For hyperlinks I am referring to Robert Vieira's 'SQL Server 2000
      > Programming' from Wrox to do URL based queries. I am thinking the
      > following format witll work:
      > http://localhost/table?
      >
      SQL=SELECT+*+FROM+DailyTotal+for+xml+raw&xsl=stylesheet.xsl&root=ROOT
      >
      > to pull dynamically both the XML data as well as an XSL stylesheet.
      >
      > My biggest hangup at this point is finding a good format for
      getting
      > the following xml file into a table like shown in the link above.
      > Most examples I have seen are alot simpler table types consisting
      of
      > only a few columns. Is what I am trying to accomplish even possible
      > with xsl? Is there a good WYSIWYG for XSL tables (XML spy is a bit
      > cryptic, I was hoping for a draw table tool like frontpage and a
      > drag and drop for values).
      >
      > Any help or a shove in the right direction would be most
      appreciated
      > and might save this poor lug his job lol.
      >
      > Here is the format of my XML data:
      >
      > <?xml version="1.0" encoding="utf-8" ?>
      > <ROOT>
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="ATX" DayBWSDollars="70634.0982" DayActualDollars="0"
      > WtdBwsDollars="0" WtdActualDollars="0" MtdBwsDollars="70634.0982"
      > MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="Heat Treat" DayBWSDollars="15298.174"
      > DayActualDollars="0" WtdBwsDollars="0" WtdActualDollars="0"
      > MtdBwsDollars="15298.174" MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="Net Form" DayBWSDollars="2943.2414"
      > DayActualDollars="0" WtdBwsDollars="0" WtdActualDollars="0"
      > MtdBwsDollars="2943.2414" MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="NV1500" DayBWSDollars="6152.05" DayActualDollars="0"
      > WtdBwsDollars="0" WtdActualDollars="0" MtdBwsDollars="6152.05"
      > MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="NV2550" DayBWSDollars="9741.072"
      DayActualDollars="0"
      > WtdBwsDollars="0" WtdActualDollars="0" MtdBwsDollars="9741.072"
      > MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="NV3500" DayBWSDollars="95673.708"
      > DayActualDollars="0" WtdBwsDollars="0" WtdActualDollars="0"
      > MtdBwsDollars="95673.708" MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="NV4500" DayBWSDollars="22341.1752"
      > DayActualDollars="0" WtdBwsDollars="0" WtdActualDollars="0"
      > MtdBwsDollars="22341.1752" MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="NV5600" DayBWSDollars="62148.76"
      DayActualDollars="0"
      > WtdBwsDollars="0" WtdActualDollars="0" MtdBwsDollars="62148.76"
      > MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="NV900" DayBWSDollars="8256.476" DayActualDollars="0"
      > WtdBwsDollars="0" WtdActualDollars="0" MtdBwsDollars="8256.476"
      > MtdActualDollars="0" />
      > <row ProductionDate="2003-05-21T00:00:00" PlantID="3"
      > ProductLineID="T-350" DayBWSDollars="3175.992" DayActualDollars="0"
      > WtdBwsDollars="0" WtdActualDollars="0" MtdBwsDollars="3175.992"
      > MtdActualDollars="0" />
      > </ROOT>
    Your message has been successfully submitted and would be delivered to recipients shortly.