(URGENT) Counts in Report Studio for the Same Car ID for Certain Condition

[gosoccer]

Hi, :) :)
I have a Relational Implementation,

I have the following situation in our database table.
CAR ID          DATE SOLD            STATUS
BMW-1010     01/02/2015            IN GARAGE
BMW-1010     01/03/2015            NEW
BMW-1010     01/04/2015            IN GARAGE
BMW-1010     01/05/2015            NEW
BMW-1010     01/06/2015            IN GARAGE
BMW-1010     01/06/2015            NEW

So, the above should show me a count of 3 based on IN GARAGE and NEW for the SAME CAR ID.
Is there a way to handle this within the Report Studio or Framework Manager?

Thanks for your time.

[Drisya]

Try this.
Count([DATE SOLD] for [STATUS])

[hespora]

almost, I'd say

Code Select Expand


count([date sold] for [Car ID],[Status])


If you just count for status, that fails as soon as multiple cars are in the report.

[gosoccer]

Thanks so much! I'll try that..  :) :)

[Drisya]

almost, I'd say

Code Select Expand


count([date sold] for [Car ID],[Status])


If you just count for status, that fails as soon as multiple cars are in the report.

You are right. Of course, it depends on the underlying dataset.

[gosoccer]

Yes, that worked. Thanks a lot