Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Counting groups
Message
De
08/01/2007 12:22:11
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Counting groups
Divers
Thread ID:
01183483
Message ID:
01183483
Vues:
71
My brain seems to be asleep today. Is there a simple way to count the number of groups in a report? If the report cursor is created with
select companies.company_name, companies.company_id, sites.site_name ; 
	from (lcCompanyfile) companies ;
	full join (lcSitefile) sites ;
	on companies.company_id = sites.company_id ;
	where sites.status = "TRP" ;
	order by companies.company_name, sites.site_name ;
	into cursor crsTemp
and the report is grouped on company_name, how would you count the number of unique company names? All my attempts result in counting every record. I could create a unique index before calling the report but that seems clumsey to me.

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform