Skip to main content
M
mpompey
Participant
June 27, 2006
Question

Distinct Count Function, where to look

  • June 27, 2006
  • 1 reply
  • 775 views
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?
This topic has been closed for replies.

1 reply

C
Cozmo2
Inspiring
March 25, 2015

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>

Firefly Community Gallery
Adobe Firefly

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices