Creating only record counts as a report

[rggelinas]

Having a difficult time creating a selected record count from Rational ClearQuest. What I want to do is create a count of records that are one of two states (open, closed) and a third count that is a subset of 'closed' based on date. No other information, other than a total count is wanted on this report.

I don't have the ability to adjust the query very much (it doesn't use true SQL for the queries), but I can supply the fields.

-Robert Gelinas

 

[synapsevampire]

Supplying fields is helpful, but perhaps a little theory will suffice:

A simple means to do this is by creating three formulas:

@open formula:
if {table.State} = "Open" then
1
else
0

@closed formula:
if {table.State} = "Closed" then
1
else
0

@other formula:
if {table.State} = "Closed"
and {table.Date} > currentdate-14 //replace with yours
then
1
else
0

Place these three fields in the detail section, right click and select Insert Summary->Sum.

Suppress the details section.

You now have 3 counts.

You might also do this using Running Totals.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[rggelinas]

Is there a way to not display the records except the totals? I can normally just extract the values in the query, but I can't do that in ClearQuest, so I need to grab the record counts, but not display the record.

-Robert Gelinas

 

[stormtrooper]

Vampire's suggestion will not display any records, just counts.