Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
2nd detailband not showing
Message
From
15/12/2005 09:12:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
2nd detailband not showing
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01078203
Message ID:
01078203
Views:
58
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
Next
Reply
Map
View

Click here to load this message in the networking platform