>>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).
Check conditional formatting in Excel (up to 3 conditions as I remember).
Cetin
