[SalesForce] Display multiple List objects as columns in a visualforce page

I understand that this needs to be done using the infamous wrapper class, but for some reason I am not able to get it to work. Any help would be great.

Goal: Display multiple List<String> as columns.

Something like this:
enter image description here

I would like to use pageblockTable to accomplish this (or perhaps a pageblockTable within a pageblockTable).

I am storing each column data in a List<String> and it does NOT have a fixed number of entries. Each such List<String> needs to repeat as columns for as many years as specified by user input.

    public class Summary{
            public List<String> summary_list {get; set;}

            public Summary(List<String> s){
                summary_list = s;
            }
        }

        public List<Summary> summary_list_wrap {get; set;}
        public List<String> items_in_column {get; set;}

public void build_Table(){
     //populating the data here - which is working as per the screenshot below
}

The values of summary_block_wrap look like this when printed using the below code:

<apex:pageblockTable value="{!summary_list_wrap}" var="slw">
                        <apex:column value="{!slw}"/>
                    </apex:pageblockTable>

enter image description here

How do I tweak my visualforce page to match the desired layout?

EDIT: After implementing the answer suggested by Ashwani, the output looks like below. How can we format the table to remove the spacing between the columns and trim the column widths?

enter image description here

Best Answer

You should create a 2 dimensional array or we can say List of List which looks like List<List<String>> twoDimArray and try to iterate it like:

<apex:repeat value="{!twoDimArray}" var="dimension1">
  <apex:pageBlockDataTable value="{!dimension1}" var="dimension2">
    <apex:column value="{!dimension2}"/>
    <!-- etc -->
  </apex:pageBLockDataTable>
</apex:repeat>

Here you will have to arrange the collection properly. Possible iteration can be:

<apex:repeat value="{! summary_list_wrap}" var="dimension1">
  <apex:pageBlockDataTable value="{!dimension1. summary_list}" var="dimension2">
    <apex:column value="{!dimension2}"/>
    <!-- etc -->
  </apex:pageBLockDataTable>
</apex:repeat>

OP ADDED OUTPUT: enter image description here

I would like the output table style to look like that of pageblockTable. But is there a way to get rid of the spacing between the columns? And why is the last column squeezed as opposed to others? I would like to have a 'space trimmed' table instead of something with 100% width and wide spaces in between. How?

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

This is untested so you may need to have play, however this should return a List of the RevenueWrapper classes which contains the 4 columns you are looking to use in your VF page:

public class RevenueController{

Map<String, RevenueWrapper> ResultList = new Map<String, RevenueWrapper>(); 

public RevenueController(){
    List<AggregateResult> result =  [
    SELECT FISCAL_YEAR(Date__c) Date, Type__c, sum(Amount__c) Amount
    FROM Revenue__c
    GROUP BY FISCAL_YEAR(Date__c), Type__c];

    for(AggregateResult ar : result){

        RevenueWrapper RW = new RevenueWrapper();

        //If the RevenueWrapper already exists grab it from the Map
        if(ResultList.containsKey(String.valueOf(ar.get('Date')))){
            RW = ResultList.get(String.valueOf(ar.get('Date')));
        }

        //Set the amount
        RW.setAmount(ar);

        //Save back to the Map
        ResultList.put(String.valueOf(ar.get('Date')), RW);
    }
}

public List<RevenueWrapper> getResults() {
    return ResultList.values();
}


public class RevenueWrapper{
    public String revenueDate { get; set; }
    public Integer budgetAmount { get; set; }
    public Integer actualAmount { get; set; }
    public Integer varianceFYPercent { set; }
    public Integer varianceFYAmount { set; }

    public RevenueWrapper(){

    }

    public void setAmount(AggregateResult ar){
        revenueDate = String.valueOf(ar.get('Date'));

            //Set the amount value based on type
        if(ar.get('Type__c') == 'Budget'){
            budgetAmount = Integer.valueOf(ar.get('Amount'));
        }else if(ar.get('Type__c') == 'Actual'){
            actualAmount = Integer.valueOf(ar.get('Amount'));
        }else{ //Catch all for a type that isn't recognised
            return;
        }

    }

    public Integer getVarianceFYAmount(){
        return actualAmount - budgetAmount;
    }

    public Decimal getVarianceFYPercent(){
        if(budgetAmount != 0){
            return Decimal.valueOf((Double.valueOf(actualAmount) / Double.valueOf(budgetAmount)) * 100).setscale(1);
        } else{
            return 0;
        }
    }
}

}

[SalesForce] Unable to display map of in repeat

This controller:

public class MyController {
    public Map<String, List<String>> myMap {
        get {
            return new Map<String, List<String>>{
                    'abc' => new List<String>{'123', '456'},
                    'def' => new List<String>{'654', '321'}
                    };
        }
    }
}

and page:

<apex:page controller="MyController">
    <apex:repeat value="{!myMap}" var="key">
        <apex:pageBlock >
            <apex:pageBlockTable value="{!myMap[key]}" var="listItem">
                <apex:column value="{!listItem}"/>
            </apex:pageBlockTable>
        </apex:pageBlock>
    </apex:repeat>
</apex:page>

produces the expected repeated page block tables (as the apex:repeat automatically iterates over the map keys).

So I think your problem lies in the code that builds myMap or in the code that exposes it from your controller and you have not posted that code.

Best Answer

Related Solutions

[SalesForce] Split a single field into 2 columns for a VF page

[SalesForce] Unable to display map of in repeat

Related Topic