Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Count??
Message
De
07/08/2009 04:35:38
 
 
À
07/08/2009 04:05:02
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01416689
Message ID:
01416691
Vues:
67
Agnes,

I try to avoid calculated fields in reports as much as I can.

Instead I add them to the cursor

Advantages
- Easier
- The expression is always available. You can eg display the total in the group header, or a % of total in the detail

I would do something like this
	create cursor SchnapsTmp ;
	(	a	c(1), ;
		b	c(1),; 
		c	c(1) ;
	)
	insert into SchnapsTmp values ('', 'x', 'y')
	insert into SchnapsTmp values ('', 'x', 'y')
	insert into SchnapsTmp values ('a', 'x', 'y')
	insert into SchnapsTmp values ('b', 'x', 'y')
	insert into SchnapsTmp values ('c', 'x', 'y')
	
	select * ;
		from SchnapsTmp, ;
			( select count(*) as NumberA from SchnapsTmp where ( a <> '') ) XX;
		into cursor Schnaps
		
	use in SchnapsTmp 
	
	&& report cursor = Schnaps
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform