0 Replies Latest reply: Feb 27, 2012 8:18 AM by MagnusGustafson RSS

    Manual crosstab not working in 11g

    MagnusGustafson
      Hi,

      I have a crosstab report in 10g, according to Vetsrini's http://1.bp.blogspot.com/_F24IZvIkLOI/ScKy1Pfs9MI/AAAAAAAAAeE/EIi26bO99S4/s1600-h/crosstab+-deficientcolumn.JPG, and have now migrated it to 11g and it is not working.

      I get this error in the log,
      [2012-02-27T15:00:48.954+01:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 39] [userId: <anonymous>] [ecid: 22bf1318a95b3a18:-528a5dc9:135b0d15f61:-8000-000000000002f821,0] [APP: bipublisher#11.1.1] XSL error:[[

      <Line 80, Column 151>: XML-23002: (Error) internal xpath error
      @Line 80 ==> <_G><xsl:if test="sum($G1[(./QADATE02 = current-group()/QADATE02)]/QATRQT) = '0'" xdofo:ctx="3">
      ]]

      Any ideas anyone??

      Thanks
      Magnus