Eclipse Community Forums: BIRT » Counting on a xml data sources

Home » Archived » BIRT » Counting on a xml data sources(noob needing a little help)

Counting on a xml data sources [message #675462]

Tue, 31 May 2011 11:26

Eclipse User

Hi there !

I'm trying to make a report from a Xml data sources.

I've got a xml file full or things like

<answer value="yes" from="client1" uselessdata="xxx" />
<answer value="no" from="client2" uselessdata="xxx" />

I was able to make a Data set, allowing me to make a table with all the answer "yes" and who made it.

But now i would like to count how many "yes", and how many "no" there is, but i don't know how do that, and where i have to do that.

I know a sql request can do that, but Xpath seems to be less powerful.

Can someone help me ?

Thanks !

Re: Counting on a xml data sources [message #675489 is a reply to message #675462]

Tue, 31 May 2011 12:12

Eclipse User

Is value a column in your dataset? If so you should be able to add a
computed column to the dataset that does a count and add a filter to the
computed column on value == yes. If you have a test xml file and simple
report post it and I can modify it for you.

Jason

On 5/31/2011 11:26 AM, forums-noreply@eclipse.org wrote:
> Hi there !
>
> I'm trying to make a report from a Xml data sources.
>
> I've got a xml file full or things like
>
> <answer value="yes" from="client1" uselessdata="xxx" />
> <answer value="no" from="client2" uselessdata="xxx" />
>
> I was able to make a Data set, allowing me to make a table with all the
> answer "yes" and who made it.
> But now i would like to count how many "yes", and how many "no" there
> is, but i don't know how do that, and where i have to do that.
>
> I know a sql request can do that, but Xpath seems to be less powerful.
>
> Can someone help me ?
>
> Thanks !

Re: Counting on a xml data sources [message #675668 is a reply to message #675489]

Wed, 01 June 2011 03:23

Eclipse User

It's all that i needed, it works, thank you !

Previous Topic:	Hyperlinks do not work in PDF format
Next Topic:	Report Width Formatting Question

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 19:33:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter