Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Sheet Formatting
Message
 
 
To
06/03/2006 13:27:56
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01087027
Message ID:
01101779
Views:
11
>Sorry I don't understand what you mean.
>Cetin

Here is how I'm trying to create my file which I when convert to Excel (this code would need some adjustments too):
text TO lcSQLStr TEXTMERGE noshow
	SELECT cCode_Description as cStatus, ;
	CAST(SUM(NVL(IIF(BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ;
	AS iOriginal, ;
	CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk) ,0,1),0)) AS I) as iCurrent ;
	FROM MMVisCollect!Trans ;
	INNER JOIN MMVisCollect!VisCodes ON Trans.cResolution_Codes_fk = VisCodes.cVisCodes_pk ;
	WHERE iBatch_Number = <<m.tiBatch_Number>> ;
	group BY 1 ;
	UNION ALL ;
	SELECT PADR('Total Closed:',100) as cStatus, ;
	CAST(SUM(NVL(IIF(BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ;
	AS iOriginal, ;
	CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk) ,0,1),0)) AS I) as iCurrent ;
	FROM MMVisCollect!Trans ;
	WHERE iBatch_Number = <<m.tiBatch_Number>> and cResolution_Codes_Fk IS NOT NULL ;
	UNION ALL ;
	SELECT PADR(cQueue_Name,100) as cStatus, ;
	CAST(SUM(NVL(IIF(not BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ;
	as iOriginal, ;
	CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk),1,0),0)) AS I) as iCurrent ;
	FROM MMVisCollect!Trans ;
	INNER JOIN MMVisCollect!Trans_Employees_Queues ON Trans.cTrans_pk = Trans_Employees_Queues.cTrans_fk ;
	INNER JOIN MMVisCollect!Queue_Names ON Trans_Employees_Queues.cQueue_Names_fk = Queue_Names.cQueue_Names_pk ;
	WHERE Trans.iBatch_Number = <<m.tiBatch_Number>> ;
	AND Trans.cResolution_Codes_fk is NULL ;
	group BY 1 ;
	UNION ALL ;
	SELECT PADR('Total Opened:',100) as cStatus, ;
	CAST(SUM(NVL(IIF(not BETWEEN(tResolution_Date,##START_DATE##,##END_DATE##),1,0),0)) AS I) ;
	as iOriginal, ;
	CAST(SUM(NVL(IIF(ISNULL(cResolution_Codes_Fk),1,0),0)) AS I) as iCurrent ;
	FROM MMVisCollect!Trans ;
	WHERE Trans.iBatch_Number = <<m.tiBatch_Number>> ;
	AND Trans.cResolution_Codes_fk is NULL ;
	UNION ALL ;
	SELECT PADR('Batch Total:',100) as cStatus, ;
	CAST(COUNT(*) AS I) as iOriginal, ;
	CAST(COUNT(*) AS I) as iCurrent ;
	FROM Trans ;
	WHERE iBatch_Number = <<m.tiBatch_Number>>
ENDTEXT
As you see, I create three lines with totals. I'd like to present them in different font (bold, bigger size).
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform