Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Question about COUNT vs COUNTDISTINCT
Question about COUNT vs COUNTDISTINCT [message #794066] Wed, 08 February 2012 22:11 Go to next message
Neil Wang is currently offline Neil WangFriend
Messages: 105
Registered: July 2009
Senior Member
Hi,

Please have a look at my report design in attachment. If I use COUNT as the function in aggregation, the value is 1; however, if I use COUNTDISTINCT as the function, the value is 0. I might understand it wrong but I thought COUNTDISTINCT should return 0 as well. Please advise. (I'm using 2.6.2)

Neil
Re: Question about COUNT vs COUNTDISTINCT [message #794090 is a reply to message #794066] Wed, 08 February 2012 22:41 Go to previous message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Neil,

This may be a bug. If you add the following filter:
row["STATE"] == "CA" && dataSetRow["COUNTRY"] == "UK"
and put the expression in as:
dataSetRow["STATE"]
It should work.

Jason

On 2/8/2012 5:11 PM, Neil Wang wrote:
> Hi,
>
> Please have a look at my report design in attachment. If I use COUNT as the function in aggregation, the value is 1; however, if I use COUNTDISTINCT as the function, the value is 0. I might understand it wrong but I thought COUNTDISTINCT should return 0 as well. Please advise. (I'm using 2.6.2)
>
> Neil
Previous Topic:Problem when integrating WebViewer into RCP application
Next Topic:Integrating BIRT and fileupload in GWT
Goto Forum:
  


Current Time: Fri Dec 19 21:03:12 GMT 2014

Powered by FUDForum. Page generated in 0.02092 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software