[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Formatting Flat XML data into Report
Hi
I am getting the records from a database as result set (rows and columns) and the XML is not structured hierarchically. I am using the Muenchian method to group them (by Client Name and Order #). How do I list all the "Security" and "Puposes" for a given order number and without repeating all the order fields like Order Number, title etc. for an order. Also I do not know how many ?security Items? or ?Pupose? items will be there for a order number. I am having problems formatting the report as listed below. Client Name order # Title Security Purpose --------------------------------------------------------------- XXX 1 AAA Papers AA 2 BBB Coins |<-- Multiple Security Items in the same order Buildings |<- Order # ... Purpose and Other fields |<- should not be repeated BBB 1 XZX Building CC | <-- Multiple Purpose in the same Order DD | <-- Order # ... Security and Other fields |<- should not be repeated My XML looks like this <client> <clientname>XXX</clientname> <OrderNumber>1</clientname> <title>AAA</title> <security>papers</security> <purpose>AA</purpose> </client> <client> <clientname>XXX</clientname> <OrderNumber>2</clientname> <title>BBB</title> <security>coins</security> <purpose>AA</purpose> |<- Purpose is same for the same order and it should not be listed in the report </client> <client> <clientname>XXX</clientname> <OrderNumber>2</clientname> <title>BBB</title> <security>buildings</security> <purpose></purpose> </client> <client> <clientname>BBB</clientname> <OrderNumber>1</clientname> <title>XZX</title> <security>Buildings</security> <purpose>CC</purpose> </client> <client> <clientname>BBB</clientname> <OrderNumber>1</clientname> <title>XZX</title> <security>Buildings</security> <purpose>DD</purpose> </client> Thanks in advance Ravi _________________________________________________________________ Think Marriage! Think BharatMatrimony.com http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?74 XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|