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 17:11 Go to next message
Neil Wang is currently offline Neil Wang
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 17:41 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
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 Jul 25 03:10:17 EDT 2014

Powered by FUDForum. Page generated in 0.09751 seconds