Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Sheet Formatting
Message
 
 
À
06/03/2006 13:27:56
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01087027
Message ID:
01101779
Vues:
10
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform