Need all childs

[sven.waibel]

Hi,

i got following xml:

 

Code:

<a>
   <b name="1" />
   <b name="2" />
   <b name="3" />
</a>

 

In my document it should be this way:

Code:

[code] Name: 1 2 3

My problem is, i got always 1 resp. selected one (XPATH: a/b/@name or a/b[2]/@name). Is there a kind of for-each or something similar?

 

Thanks a lot

Sven

 

Post edited by: sven.waibel, at: 2007/05/11 08:54

Post edited by: sven.waibel, at: 2007/05/11 09:23

[Case1182]

What are u trying to do here? What kind of function or output are u looking for?

[sven.waibel]

I want to list all "names", that's all.

I think i have to take sub reports, but at the moment i have no glue.

[Case1182]

if u are using jasper this is the xml

 

<field name="Ur field goes here" class="java.lang.String"/>

 

<textFieldExpression class="java.lang.String"><![CDATA[$F{Ur field goes here}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="false" pattern="##0.00" isBlankWhenNull="true" evaluationTime="Now" hyperlinkType="None" hyperlinkTarget="Self" >

<reportElement

x="74"

y="5"

width="74"

height="20"

key="textField"/>

<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>

<textElement>

<font/>

</textElement>

 

but u do have to setop the rest of the document and this would go in the details band.

Post edited by: Case1182, at: 2007/05/11 14:35

[sven.waibel]

"Ur field goes here" that's the important part, the rest i have already.

What is the right expression to get 1,2,3?

 

a/b/@name => 1

 

just 1

2 and 3 are missing

Post edited by: sven.waibel, at: 2007/05/14 08:19

[Case1182]

if u have already created ur connection to the database and table in the database, "Ur field goes here" is the column name in the table, but be sure it matches exactly, it is case sensitive.

[sven.waibel]

My database is a xml file, so have to use XPATH!

[sven.waibel]

I solved it.

You have to create a subreport and have to set the source path expression to the needed element.

In my case: /a/b

 

in the report:

field description: @name

 

that's it

Post edited by: sven.waibel, at: 2007/05/15 08:54