Distinct Count Function, where to look

New Here ,
Jun 27, 2006 Jun 27, 2006

Copy link to clipboard

Copied

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?
TOPICS
Reporting

Views

627

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Mar 25, 2015 Mar 25, 2015

Copy link to clipboard

Copied

LATEST

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>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines