Hi

I was expecting to find this information easily but I've not found anything.

In my controller I run a SOQL statement with 'group by rollup' and I then display the records in a visualforce table.

Each time that a subtotal is displayed, I want to either indent or right justify the word 'Subtotal' and do the same for the grand total.  I can't find anything that explains how to apply this formatting in the controller.

Any help would be greatly appreciated.

Here's the controller:
 

public class SummariseQuotedWorks {
    private final Quote qte;
    
    public SummariseQuotedWorks(ApexPages.StandardController controller) {
        this.qte = (Quote)controller.getRecord();
        }
    
/* Use a wrapper class to store the aggregate values in a way that is accessible to Visualforce */

public class WISum{
        public String Acct {get; set;}
        public String WorkItem {get; set;}
        public Decimal TotalCost {get; set;}
        public WISum(string a,string w,decimal c){
                this.Acct=a;
                this.WorkItem=w;
                this.TotalCost=c;
        }
}

public List<WISum> WISumList = new List<WISum>();

public List<WISum> getWISumOut(){

		String theAcct = '';

        AggregateResult[] AgR = [SELECT Account__r.Name AC, WorkItem__r.Name WI, sum(cost1__c) TC FROM Quoted_Work__c
where Quote__c=:qte.Id
group by rollup(Account__r.Name, WorkItem__r.Name)]; 

        for (AggregateResult WIRecs : AgR) {


       
 /*      WISumList.add(new WISum((String) WIRecs.get('AC'), (String) WIRecs.get('WI'), (Decimal) WIRecs.get('TC'))); */
 	        WISumList.add(new WISum((String) ((WIRecs.get('AC') == theAcct) ? '' : WIRecs.get('AC')), (String) (WIRecs.get('WI') == null ? 'Subtotal' : WIRecs.get('WI')), (Decimal) WIRecs.get('TC')));
 
        	theAcct = (String)WIRecs.get('AC');
 
        }
        return WISumList;
}
    
}

Here's the VF:
 

<apex:page standardController="Quote" extensions="SummariseQuotedWorks">
	<apex:pageBlock title="Summary of Works for Quote: {!Quote.Name}">
		<apex:pageBlockSection >
			<apex:pageBlockTable value="{!WISumOut}" var="WISummary">
				<apex:column value="{!WISummary.Acct}">
					<apex:facet name="header">Site</apex:facet>
				</apex:column>
				<apex:column value="{!WISummary.WorkItem}">
					<apex:facet name="header">Work Item</apex:facet>
				</apex:column>
				<apex:column value="{!WISummary.TotalCost}">
					<apex:facet name="header">Total Cost</apex:facet>
				</apex:column>
			</apex:pageBlockTable>
		</apex:pageBlockSection>
	</apex:pageBlock>
</apex:page>

Here's the ouput:



Wherever 'Subtotal' appears, I want it indented or right justified.

I've not modifed the controller yet to display 'Grand Total' in the last line but will do and will want that formatted too.

Many Thanks,
Mike.