Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2nd detailband not showing
Message
De
15/12/2005 09:12:37
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Titre:
2nd detailband not showing
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01078203
Message ID:
01078203
Vues:
59
i finally have a need for the new report features
I have payee info in the group band, deductions in the detail band and now I added a second detailband with payments from another table
SELECT ;
	cc1.payee_id,;
	IDNUM,;
	PAYEETYPE,;
	NAME1,;
	.....
        BenefitType,;
	numDeductions,;
	emplact.shortname AS dedtype,;
	nvalue,;
	effdate,;
	enddate ;
	FROM cc1;
	LEFT JOIN emplact ON cc1.payee_id=emplact.payee_id ;
	AND emplact.shortname IN ("GARNISH","OPMNT");
	LEFT join claims ON cc1.BUSSEG_ID = claims.claim_id;
	LEFT join statute ON claims.statute_ID = statute.statute_id;
	INTO CURSOR ccPrint;
	order BY 4,5,2


	SET REPORTBEHAVIOR 90
	SET RELATION TO payee_id INTO timesht && (payschedule comes from here)

	SELECT ccPRINT
	REPORT FORM reports\r_employee_list2 preview
the report has info from ccPRINT in the group and detail bands
and info from related timesht table in 2nd detail band


the 2nd detailband does not show anything!

Thanks


Peter
Peter Cortiel
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform