Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Go to next message
Valerian Merkling is currently offline Valerian Merkling
Messages: 71
Registered: May 2011
Member
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 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 Go to previous message
Valerian Merkling is currently offline Valerian Merkling
Messages: 71
Registered: May 2011
Member
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:
  


Current Time: Mon Sep 01 14:50:51 EDT 2014

Powered by FUDForum. Page generated in 0.01668 seconds