Distinct Count Function, where to look

[mpompey]

I'm new to Cold Fusion Reports. I'm familiar with Crystal Reports. I need to perform a distinct count of one of the fields in the report and display it on the report. But I can't find that function anywhere. I've been looking for cold fusion report builder texts and web sites with no luck.

Can anybody help me with this? Or point me to a good resource for building reports with Cold Fusion Report Builder?

[Cozmo2]

I am also trying to get a distinct count from a function Here is what I have. It is not working.

Any ideas?

<CFARGUMENT name="Award" required="yes">

<CFSET variables.ct = 0>

<CFQUERY name="soc_sec_ct"  dbtype="query">

SELECT count(distinct soc_sec) as ss

FROM CFReportDataQuery

WHERE nmprg.prg_cod <> 'UNGRDTR   ' AND name.level_ = '2' AND transact.awd_id = '#arguments.Award#'

</CFQUERY>

<CFSET variables.ct = soc_sec_ct.ss>

<cfreturn variables.ct>