Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor for Summary
Message
De
23/09/2008 21:19:17
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
Cursor for Summary
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01350077
Message ID:
01350077
Vues:
76
I have this code that creates the result below it. How can I get that information into a report after the detail lines? Do I need to try and get them all on one row, or should I find a way to append them to the cursor that supports the detail?
CLOSE DATABASES

USE c:\fmsrun\prompt\EligAct IN 0

m.DOSBegin = DATE() -720
m.DOSEnd = DATE()

SELECT ;
	ICASE(;
		MONTH(DOSBegin)= 1,'Jan',;
		MONTH(DOSBegin)= 2,'Feb',;
		MONTH(DOSBegin)= 3,'Mar',;
		MONTH(DOSBegin)= 4,'Apr',;
		MONTH(DOSBegin)= 5,'May',;
		MONTH(DOSBegin)= 6,'Jun',;
		MONTH(DOSBegin)= 7,'Jul',;
		MONTH(DOSBegin)= 8,'Aug',;
		MONTH(DOSBegin)= 9,'Sep',;
		MONTH(DOSBegin)=10,'Oct',;
		MONTH(DOSBegin)=11,'Nov',;
		MONTH(DOSBegin)=12,'Dec','') AS ReportMonth, ;
	YEAR(DOSBegin) AS ReportYear, ;
	COUNT(*) AS DOSCnt ;
 FROM EligAct ;
	WHERE BETWEEN(EligAct.DOSBegin,m.DOSBegin,m.DOSEnd) ;
	GROUP BY ReportYear, ReportMonth ;
	INTO CURSOR ReportCursorSummary

BROWSE LAST 

CLOSE DATABASES

CANCEL
Oct 2007         2
Aug 2008         9
Feb 2008         4
Jul 2008         3
Sep 2008        20
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform