Hello Folks,

I ve a requirement - Importing/Exporting of Microsoft Project plan to Salesforce on a Custom Object.

In detail- Have to show the data( MPP's File) on a Custom object with the same fields .Should be able to export the same data from Custom object to MPP file

Any suggestions , highly appreciated.

Hello Folks,

I've created a gantt chart with JS Library. (Fetched it on VF Component page with the controller),

Time scale showing dates in a month.

I wanted to display as weekly format instead of dates f month.

Any suggestions , greatly appreciated.

Thank you. 

Hello Experts,

Can anyone refer me how to achieve below requirement.
Report has to look as below on a VF Page , Can i use matrix report/Visualforce Pageblocktable/repeat.Kindly suggest.



Appreciate all your references on this.

Thank you.

Hello Folks,

Can you help me any references to have VF Page as below:



Here, Cash Inflows/benefits, Cashoutflows/Costs are custom fields.
Net Effert is (Cashoutflows/Costs - CashInflows/benefits)
NPV has below formula 
 
Ct = net cash inflow during the period ( Custom Field)
Co= initial investment ( Custom Field)
r = discount rate,( Custom Field) 
t = number of time periods ( Custom Field)

Kindly suggest.

Thank you so much 

 

Hello Experts,

Can you please help me placing the below formula on VF Controller Page.

The following is the formula for calculating NPV: 

Ct = net cash inflow during the period
Co= initial investment
r = discount rate, and
t = number of time periods 

Thank you so much .
 

Hello Folks,

I ve a requirement - Importing/Exporting of Microsoft Project plan to Salesforce on a Custom Object.

In detail- Have to show the data( MPP's File) on a Custom object with the same fields .Should be able to export the same data from Custom object to MPP file

Any suggestions , highly appreciated.

Hello Folks,

I've created a gantt chart with JS Library. (Fetched it on VF Component page with the controller),

Time scale showing dates in a month.

I wanted to display as weekly format instead of dates f month.

Any suggestions , greatly appreciated.

Thank you. 

Hello Experts,

Can anyone refer me how to achieve below requirement.
Report has to look as below on a VF Page , Can i use matrix report/Visualforce Pageblocktable/repeat.Kindly suggest.



Appreciate all your references on this.

Thank you.

I'm able to create a Visuaforce bar chart that's either stacked or grouped with multiple series similar to the example below.  However, I'm trying to figure out how to make the series title a little more dynamic so it could be data driven.  Any suggestions on how to make that happen?

 

<apex:chart data="{!data}" height="400" width="500">
<apex:legend position="left"/>
<apex:axis type="Numeric" position="left" title="Closed Won" grid="true"
fields="data1,data2,data3" dashSize="2">
<apex:chartLabel/>
</apex:axis>
<apex:axis type="Category" position="bottom" fields="name" title="Stacked Bars">
<apex:chartLabel rotate="315"/>
</apex:axis>
<apex:barSeries orientation="vertical" axis="left" stacked="true"
xField="name" yField="data1,data2,data3" title="MacDonald,Promas,Worle"/>
</apex:chart>

Hello,

 

I have created a VF page and a custom controller that creates some tables (similar to Salesforce reports) and a pie chart.  The controller and VF page below work fine for the tables.  The controller saves fine with the code as is, but when I uncomment the pie chart section in my VF page, I get the error below:

 

Error: ScorecardDB1: Invalid qname for tag 'apex:'

 

Does anyone know what causes this?

 

Controller:

 

public class theController1 {

 

public list<Client_Status_Scorecard__c> Scorecard { get; set; }
public list<Client_Status_Scorecard__c> Scorecard2 { get; set; }

 

public theController1() {
Scorecard = [SELECT id,Name,Client_Name__c,Type_of_Client__c,Projected_Annual_Revenue__c,Overall_Percent__c,Overall_Score__c,Overall_Status_Icon__c,Renewal_Date__c
FROM Client_Status_Scorecard__c
WHERE Type_of_Client__c <> 'Health Plan'
ORDER BY Projected_Annual_Revenue__c DESC limit 3];

 

Scorecard2 = [SELECT id,Name,Client_Name__c,Type_of_Client__c,Projected_Annual_Revenue__c,Overall_Percent__c,Overall_Score__c,Overall_Status_Icon__c,Renewal_Date__c
FROM Client_Status_Scorecard__c
WHERE Type_of_Client__c = 'Health Plan'
ORDER BY Projected_Annual_Revenue__c DESC limit 10];

 

}

public AggregateResult[] getChartData() {

 

return [SELECT Overall_Status__c Status, SUM(Projected_Annual_Revenue__c) Revenue
FROM Client_Status_Scorecard__c
WHERE Type_of_Client__c = 'Health Plan'
GROUP BY Overall_Status__c];

 

}

 

}

 

 

VF Page:

 

<apex:page controller="theController1" >

<apex:form >

<apex:pageBlock >

<style>

body .bPageBlock .pbBody .red .pbSubheader {
background-color:#8DA5C4;
font-size:12pt;
font-family:verdana;
}

body .bPageBlock .pbBody .red .pbSubheader h3
{
color:white;
}

.TableHeader1 {text-align:left;background-color:#9BC7FA;font-size:10pt;font-family:Arial;border-bottom-style:solid;border-color:#236FBD;border-width:2px}
.TableHeader2 {text-align:center;background-color:#9BC7FA;font-size:10pt;font-family:Arial;border-bottom-style:solid;border-color:#236FBD;border-width:2px}

</style>

 

<apex:outputPanel styleClass="red" layout="block">

 

<apex:pageBlockSection collapsible="true" columns="1" title="Top 10 By Market (Employers/Distributors)">

 

<apex:dataTable width="80%" columns="6" value="{!Scorecard}" var="csc">

 

<apex:column width="20%" headerValue="Scorecard #" headerClass="TableHeader1">
<apex:commandLink action="/{!csc.Id}" value="{!csc.Name}"/>
</apex:column>

<apex:column width="20%" Value="{!csc.Client_Name__c}" headerValue="Client Name" headerClass="TableHeader1"/>
<apex:column width="20%" Value="{!csc.Projected_Annual_Revenue__c}" headerValue="Revenue ($k)" headerClass="TableHeader2" style="text-align:center"/>
<apex:column width="20%" Value="{!csc.Overall_Percent__c}" headerValue="Score(%)" headerClass="TableHeader2" style="text-align:center"/>
<apex:column width="20%" Value="{!csc.Overall_Score__c}" headerValue="Score (pts)" headerClass="TableHeader2" style="text-align:center"/>
<apex:column width="20%" Value="{!csc.Overall_Status_Icon__c}" headerValue="Status" headerClass="TableHeader2" style="text-align:center"/>

 

</apex:dataTable>

 

</apex:pageBlockSection>

 

</apex:outputPanel>

 

</apex:pageBlock>

 

 

<apex:pageBlock >

<style>

body .bPageBlock .pbBody .red .pbSubheader {
background-color:#8DA5C4;
font-size:12pt;
font-family:verdana;
}

body .bPageBlock .pbBody .red .pbSubheader h3
{
color:white;
}

.TableHeader {background-color:#9BC7FA;font-size:10pt;font-family:Arial;border-bottom-style:solid;border-color:#236FBD;border-width:2px}

</style>

<apex:outputPanel styleClass="red" layout="block">

 

<apex:pageBlockSection collapsible="true" columns="1" title="Top 10 By Market (Health Plans)">

 

<apex:dataTable width="80%" columns="6" value="{!Scorecard2}" var="csc" >

 

<apex:column width="20%" headerValue="Scorecard #" headerClass="TableHeader1">
<apex:commandLink action="/{!csc.Id}" value="{!csc.Name}"/>
</apex:column>
<apex:column width="20%" Value="{!csc.Client_Name__c}" headerValue="Client Name" headerClass="TableHeader1"/>
<apex:column width="20%" Value="{!csc.Projected_Annual_Revenue__c}" headerValue="Revenue ($k)" headerClass="TableHeader2" style="text-align:center"/>
<apex:column width="20%" Value="{!csc.Overall_Percent__c}" headerValue="Score(%)" headerClass="TableHeader2" style="text-align:center"/>
<apex:column width="20%" Value="{!csc.Overall_Score__c}" headerValue="Score (pts)" headerClass="TableHeader2" style="text-align:center"/>
<apex:column width="20%" Value="{!csc.Overall_Status_Icon__c}" headerValue="Status" headerClass="TableHeader2" style="text-align:center"/>

 

</apex:dataTable>

 

</apex:pageBlockSection>

 

</apex:outputPanel>

 

</apex:pageBlock>

 

<apex:pageBlock >

<style>

body .bPageBlock .pbBody .red .pbSubheader {
background-color:#8DA5C4;
font-size:12pt;
font-family:verdana;
}

body .bPageBlock .pbBody .red .pbSubheader h3
{
color:white;
}

.TableHeader {background-color:#9BC7FA;font-size:10pt;font-family:Arial;border-bottom-style:solid;border-color:#236FBD;border-width:2px}

</style>

<apex:outputPanel styleClass="red" layout="block">
<apex:pageBlockSection collapsible="true" columns="1" title="At Risk">

 

<Table columns="1" width="100%">
<tr>
<td width="100%" >Revenue At Risk</td>
</tr>
<tr>
<td width="100%" >
<apex:chart height="300" width="600" data="{!chartData}">  /*FIXED LINE*/

*/<apex:
height="300" width="600" data="{!chartData}">  ORIGINAL INCORRECT LINE*/
<apex:pieSeries dataField="Revenue" labelField="Status" colorSet="#FF0000,#3EAD3E,#F6FF00"/>
<apex:legend position="bottom" font="10px Arial"/>
</apex:chart>
</td>
</tr>
</Table>

 

</apex:pageBlockSection>

 

</apex:outputPanel>

 

</apex:pageBlock>

</apex:form>

 

</apex:page>