[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Pivot Reports

Subject: Pivot Reports
From: Vitaliy Paykov <vpay@xxxxxxxxx>
Date: Thu, 18 Jan 2007 14:06:38 +0200
 Pivot Reports
Hello all!

We met a strange problem with XML transformation.

Let us describe our task first:
We need to generate complex xml based reports which could contains multiple crosstab parts.
We have next requirements:


 1. Each crosstab could contains arbitrary number of rows and columns.
 2. Crosstab report can include other crosstabs
 3. Position of the crosstab is unknown  on design phase (user can
    build complex report using already designed blocks. crosstab is
    the one of the blocks)
 4. The highest level of XSLT is hardcoded so we can't change it for
    every report
 5. Each block have its own unique ID
 6. Several blocks can contain same columns and/or rows

Ours assumptions:

 1. Key tags for all crosstabs are standard (<item> - atomic set of
    information, <row> - name of the item's row, <col> - name of the
    item's col, <val> - value of the item)
 2. Combination of the row and the col is unique in scope of the block
 3. Source data doesn't cover all the combinations of rows and cols.
    So missing items should be interpreted as - or 0

Problem is the next:
First block is generated absolutely correct, all the next blocks contain only combinations of rows and cols which haven't been met in any of already generated blocks.


Sample:

We need take this
_____________________________
*     | C1    | C2   | Total |

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.