nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Distinct Data Set with xml source?

PhilippArndt · 2008-05-20T01:00:13+00:00

Hello, I need to have a distinct table for the following xml data source: [b] 1 1234 [/b] [b] 2 4321 [/b] [b] 2 4321 [/b] [b] 1 …

PhilippArndt

Hello, 
I need to have a distinct table for the following xml data source: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="iso-8859-1"?>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
</pre>
 
 
The Result should be a table like this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| 1 | 1234 |
| 2 | 4321 |

</pre>
How can I do this with BIRT?

Find more posts tagged with

Comments

averma

Hi PhilippArndt:
You XML file is malformed, you are missing the root element. I have modified the data to fix the issue and I am attaching a sample report that uses this file. The report design expects the file in C:temp.
Hope this helps.

Ashwini

PhilippArndt

thanks, the root node is really missing in my sample. But this is not the problem. Your sample returns a table: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| 1 | 1234 |
| 2 | 4321 |
| 2 | 4321 |
| 1 | 1234 |

</pre>
 
But it should only contain two elements (for example D as unique key). 
The result should be: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| 1 | 1234 |
| 2 | 4321 |

</pre>
 
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="iso-8859-1"?>
<F>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>2</D>
<E>4321</E>
[/b]
</A>
<A>
[b]
<D>1</D>
<E>1234</E>
[/b]
</A>
</F>
</pre>

averma

Hi PhilippArndt:
For this I would recommend using scripted data source.

Ashwini