You need to sign in to do that
Don't have an account?
Girbson Bijou
SOQL Result does not display in VF: see the attached picture
The Controller: public class FuelReportController { public List<Gas_Cargo__c> fuel{get;set;} public FuelReportController() { fuel = [ SELECT Tank__r.Name, Name, Date_Receive__c , Number_Of_Gallons__c, Cost_in_HTG__c, Old_Cargo_Balance__c, BeginingCargo__c, Given__c, Available__c , Status__c FROM Gas_Cargo__c WHERE Date_Receive__c = THIS_MONTH ORDER BY Date_Receive__c]; } } VF is: <apex:page showHeader="false" sidebar="false" standardStylesheets="false" Controller="FuelReportController" applyBodyTag="false" > <table style="width:100%;border-collapse: collapse;"> <tr> <td> <b>Id Cargo </b></td> <td> <b>Tank </b></td> <td> <b>Date Received </b></td> <td> <b># Gallons </b></td> <td> <b>Cost(HTG) </b></td> <td> <b>Old Balance </b></td> <td> <b>Begining Stock</b></td> <td> <b>Given</b></td> <td> <b>Available</b></td> <td> <b>Status</b></td> </tr> <apex:repeat value="{!fuel}" var="c"> <tr> <td>!c.Name</td> <td>!c.Date_Receive__c</td> <td>!c.Number_Of_Gallons__c</td> <td>!c.Cost_in_HTG__c</td> <td>!c.Old_Cargo_Balance__c</td> <td>!c.BeginingCargo__c</td> <td>!c.Given__c</td> <td>!c.Available__c</td> <td>!c.Status__c</td> </tr> </apex:repeat> </table> </apex:page>
Best Answer chosen by Girbson Bijou
Raj Vakati
Change your page as below .. Merge Syntax was wrong in your code