Display list of accounts group by picklist field value in visualforce page.

Sometimes we may have the requirement of displaying records of any object group by picklist field value.
In order to do this u need to generate 2 lists one is list of records and other is list of picklist field values.Then in visualforce page u can use nested <apex:repeat> and some conditions to display the records group by picklist field value.

The example below will explain it.
Here is the code for Apex Class:

public with sharing class GroupBy{
 
  public List<account> accounts {get;set;}  
  public Account ac {get;set;}
  public String[] states {get;set;}
  id x;
  public GroupBy()
  {
    ac = [ select Name FROM Account 

    WHERE id = :ApexPages.currentPage().getParameters().get('id')];
     x=ac.id;
  }
  public id getQuantity1() {
     
        return x;
    } 
 
  public void load() {
  List<String> lstPickvals=new List<String>();
  Schema.DescribeFieldResult fieldResult = 

account.active__c.getDescribe();
  List<Schema.PicklistEntry> ple =fieldResult.getPicklistValues();
  system.debug('....'+ple );
  for (Schema.PicklistEntry a:ple ){//forall values in picklist list
      lstPickvals.add(a.getValue());//add value to our final list
   }
   system.debug('....'+lstPickvals);
    // for demo purposes limit the states  
    accounts = [Select ID, Name,active__c From account
      Where Active__c IN: lstPickvals];
 
    // dynamically create set of unique states from query
    Set<String> stateSet = new Set<String>();
    for (account a : accounts)
      stateSet.add(a.Active__c);
 
    // convert the set into a string array  
    states = new String[stateSet.size()];
    Integer i = 0;
    for (String state : stateSet) { 
      states[i] = state;
      i++;
    }
 
  }
 
}

The code for visualforce page:

<apex:page controller="GroupBy" action="{!load}" sidebar="false">
 <apex:sectionHeader title="My Sample Display Page" 

subtitle="Group by picklist field value" description=

"shows how you can dynamically group results by field value."/>
 
 <apex:repeat value="{!states}" var="state">
 
 <apex:pageBlock title="{!state}">
 
  <apex:repeat value="{!accounts}" var="account"> 

<apex:outputPanel rendered="{!IF(state=account.Active__c,true,false)}">
    {!account.Name} - {!account.Active__c}<br/>
</apex:outputPanel>
 
   </apex:repeat>
 
    </apex:pageBlock>
 
  </apex:repeat>
 {x}
</apex:page>

When we run the visualforce page with accountid,

the output will be as follows

 

Generation of pdf,word and excel files from visualforce page

We can generate pdf , word and excel files from visualforce page.Visualforce page is used to display the contents.

Generation of pdf file:
If u want to generate pdf file then u can use "renderAs" attribute of <apex:page> tag.
For example the below sample vf code will generate pdf file.

<apex:page renderAs="pdf">
  <!-- Begin Default Content REMOVE THIS -->
  <h1>Congratulations</h1>
  This is your new Page
  <!-- End Default Content REMOVE THIS -->
</apex:page>

When we run the above sample code,the output will be a pdf file as shown in below image.

U can observe from above code I  used  renderAs="pdf" in <apex:page>  to generate pdf file.

Generation of Ms-word file:
If u want to generate word file then u can use contentType="application/vnd.msword" attribute of <apex:page> tag.
For example the below sample vf code will generate word file.

<apex:page contentType="application/vnd.msword">
  <!-- Begin Default Content REMOVE THIS -->
  <h1>Congratulations</h1>
  This is your new Page
  <!-- End Default Content REMOVE THIS -->
</apex:page>

When we run the above sample code,the output will be a word  file as shown in below image.

 Generation of Ms-Excel File:
If u want to generate Excel file then u can use contentType="application/vnd.ms-excel" attribute of <apex:page> tag.
For example the below sample vf code will generate Excel file.

<apex:page contentType="application/vnd.ms-excel">
  <!-- Begin Default Content REMOVE THIS -->
  <h1>Congratulations</h1>
  This is your new Page
  <!-- End Default Content REMOVE THIS -->
</apex:page>

When we run the above sample code,the output will be a Excel file as shown in below image.

Salesforce Certifications Verification

If u want to know Salsforce.com professionals certifications details or if u want to verify certification details then u can get that information easily by following below steps.

step 1:
    Go to the following url  http://certification.salesforce.com/verification
The following page will be displayed.











step 2:
            Enter their full name (first and last) or primary email address in the search areas  present in above image.
Results will be displayed if they are currently certified and have selected to share their certification information.

For example if u type "jeff Douglas" in Full Name search area and click search button,then the results will be displayed as below

If u click "view certifications " results will be displayed as below