How do you show SUM aggregate values in a VF page.

First off I am not a full time programmer but can copy/modify code that I find online. The business case I have is that I need to show summary information from a custom object that is not related on an account using the external id of the account.  I.e. # of subscribers, total premiums, and the number of accounts.

I think I got the SOQL query correct but I cannot seem to get the information in a proper format to show up on my visualforce page.  I managed to do when I use COUNT but I cannot seem to get it to work correctly when I use SUM.

Also, I am using the standard Account Controller with an Extension.

Below is my Class & VF Page.

Thanks in advance for any and all help.

Kevin

CLASS

public class Agency_Client_Info
{
/*DECLARE VARIABLES */
public final Account acct;
public final Account acctINFO;
public list<AggregateResult> lstAR = new list<AggregateResult>();

/* 
Note that any query that includes an aggregate function returns its results in an array of 
AggregateResult objects. AggregateResult is a read-only sObject and is only used for query results. 
Aggregate functions become a more powerful tool to generate reports when you use them with a 
GROUP BY clause. For example, you could find the count of all opportunities for a CloseDate. 
*/  

public Agency_Client_Info(ApexPages.StandardController stdController)  
{
     /*Get the account information */
     this.acct = (Account)stdController.getRecord();
     acctINFO = [select External_ID__c from Account where ID =:acct.ID];
     
            lstAR=[ select count(ID) TotalSC, 
                    sum(Total_Subscribers__c) TotSubs,
                    sum(Earnedpremium_SUM__c) TotPrem
                    from Sub_Client__c where AOR1_TIN__c = :acctINFO.External_ID__c Or 
                                             AOR2_TIN__c = :acctINFO.External_ID__c
                                             ];
}

public list<AgencyInfoClass> getResults()
{
list<AgencyInfoClass> lstResult = new list<AgencyInfoClass>();  
for (AggregateResult ar: lstAR)  
{  
AgencyInfoClass objAgencyInfoClass = new AgencyInfoClass(ar);  
 lstResult.add(objAgencyInfoClass);  
}  
return lstResult;  
}  


//DEFINE CLASS TO HOLD THE INFORMATION TO BE PASSED
class AgencyInfoClass
{
public Decimal TotalSubs
{ get;set; }

public Decimal TotalPrem
{ get;set; }

public Integer TotalSC
{ get;set; }


//Convert the objects to type needed
public AgencyInfoClass(AggregateResult ar)
{
//Note that ar returns objects as results, so you need type conversion here
TotalSC =   (Integer)ar.get('TotalSC');
TotalSubs = (Decimal)ar.get('TotalSubs');
TotalPrem = (Decimal)ar.get('TotalPrem');

}
}

}

VF Page

<apex:page standardController="Account" extensions="Agency_Client_Info" standardStylesheets="true">

<apex:pageblocksection >
    <apex:pageBlockTable value="{!Results}" var="ar">
        <apex:column headerValue="# of Subs" value="{!ar.TotalSubs}"/>
        <apex:column headerValue="Earned Premium" value="{!ar.Totalprem}"/>

    </apex:pageBlockTable>
</apex:pageblocksection>
</apex:page>

Ihave a need to group and sum a custom object related list and show it in a standard page layout on the account page.

Related list items are as follows:

Order Widget Name  Qty

1        ABX                 5

2        ABX                 2

3        WWW              3

5        WWW              3

9        ABC                 3

Need it to show on the account page as follows:

Widget Name          Sum Qty

ABX                              10

WWW                             6

I am by no means a programmer but dabble in Apex/Visualforce.

Thanks for any help.

Kevin

We hae a look up field to Opportunites on the cases object.  I would like to update a field on the Opportunity when the Case is closed out.  I want to change the value from Sent for procesing, to Report Returned.

How can I get this done. 

FYI, I have no apex coding background so please take that into consideration in your answer.

Thanks in Advance.

Kevin Edelmann

Again, I beseach thee for any and all help that can be bestowed up this humble admin. 

Thanks in advance,

Kevin

I have a list of opportunity IDs and want to just display data from the opportunity record for those IDs.  I can see how you read from Salesforce and get data out but how do I use a selective list of IDs and get data out for just those IDs.

We hae a look up field to Opportunites on the cases object.  I would like to update a field on the Opportunity when the Case is closed out.  I want to change the value from Sent for procesing, to Report Returned.

How can I get this done. 

FYI, I have no apex coding background so please take that into consideration in your answer.

Thanks in Advance.

Kevin Edelmann