No such tuple on axis 0 error on iReport

Posted on May 21, 2014 at 1:11am

How can I get measures value on iReport?
 

    SELECT
     crossjoin(reg.region.children,
      {
        [measures].[mtot],
        [measures].[wtot]
      }
     ) ON COLUMNS,
     title.titlekhas.children ON ROWS
    FROM report1

There is my MDX query.

I have try add `fields` on iReport. <br>
When I add the `rows` and `cloumns` with this `expression` it works<br>

 
   <field name="Region" class="java.lang.String">
      <fieldDescription><![CDATA[Columns[Reg][ListRegion]]]></fieldDescription>
   </field>
   <field name="Title" class="java.lang.String">
      <fieldDescription><![CDATA[Rows[Title][Title]]]></fieldDescription>
   </field>


But when i add measures with this `expression`<br>

    <field name="mtot" class="java.lang.Number">
 
      <fieldDescription><![CDATA[Data([Reg].[region],?)]]></fieldDescription>
 
    </field>

It return `No such tuple (...) on axis 0`

Am I doing wrong?
Every answer will be thankful.

iReport Designer
mohammaduennurhadi's picture
mohammaduennurhadi
2
Joined: Nov 1 2013 - 12:37am
Last seen: 8 years 9 months ago

0 Answers:

No answers yet
Feedback
randomness