Telerik Forums
Kendo UI for jQuery Forum
3 answers
72 views
Hi there,

I have the following Table

    <table cellpadding="0" cellspacing="0" id="spendPlanGrid" class="data-table">
    <colgroup>
        <col/>
        <col/>
        <col/>
        <col style="width:110px"/>
        <col style="width:120px"/>
        <col style="width:130px"/>
        <col/>
    </colgroup>


    <thead>
    <tr>
        <th data-field="projectTitle">Project Title</th>
        <th data-field="contractor">Contractor</th>
        <th data-field="pin">PIN#</th>
        <th data-field="amount">Funded Amount</th>
        <th data-field="initiatedAmt">Initiated Amount</th>
        <th data-field="pctInitiated">% Initiated</th>
<th></th>
    </tr>
    </thead>

    <tbody>


    <tr>
        <td class="contenttext">AD Fee for DSAC20003, Public Affairs (OY 1)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20132</td>
        <td class="contenttext" align="right">802.00</td>
        <td class="contenttext" align="right">802.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>
    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20033, Public Affairs for 3 months (OY 2)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20116</td>
        <td class="contenttext" align="right">903.00</td>
        <td class="contenttext" align="right">903.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20054, COOP (OY 4)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20111</td>
        <td class="contenttext" align="right">9,688.00</td>
        <td class="contenttext" align="right">9,688.00</td>
        <td class="contenttext" align="right">100</td>
    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20061, Facilities &amp; Administrative Spt (OY 3)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20112</td>
        <td class="contenttext" align="right">4,625.00</td>
        <td class="contenttext" align="right">4,625.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20062, IRMA (OY 2)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20110</td>
        <td class="contenttext" align="right">4,122.00</td>
        <td class="contenttext" align="right">4,122.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20082, Exec Sec add'l FTE (OY 3)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20152</td>
        <td class="contenttext" align="right">358.00</td>
        <td class="contenttext" align="right">358.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD fee for DSAC20087, Public Affairs (recompete)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20024</td>
        <td class="contenttext" align="right">3,137.00</td>
        <td class="contenttext" align="right">3,137.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20093, Exec Sec Support (OY 4)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20109</td>
        <td class="contenttext" align="right">8,821.00</td>
        <td class="contenttext" align="right">8,821.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20112, Webmaster Support (OY 2)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20236</td>
        <td class="contenttext" align="right">3,072.00</td>
        <td class="contenttext" align="right">3,072.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20124, SAPCO Spt (OY 2)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20113</td>
        <td class="contenttext" align="right">3,106.00</td>
        <td class="contenttext" align="right">3,106.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20125, Human Resources (OY 2)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20115</td>
        <td class="contenttext" align="right">3,116.00</td>
        <td class="contenttext" align="right">3,116.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">AD Fee for DSAC20137, Exec &amp; Spec Projects (recompete)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20025</td>
        <td class="contenttext" align="right">3,284.00</td>
        <td class="contenttext" align="right">3,284.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Additional Funds</td>
        <td class="contenttext">AVWashington</td>
        <td class="contenttext">20405</td>
        <td class="contenttext" align="right">60.00</td>
        <td class="contenttext" align="right">60.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Alpha Testing</td>
        <td class="contenttext">MITRE (DoD FFRDC)</td>
        <td class="contenttext">20404</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Ankara Turkey</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20413</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">April FFRDC Test</td>
        <td class="contenttext">MITRE (DoD FFRDC)</td>
        <td class="contenttext">20409</td>
        <td class="contenttext" align="right">300.00</td>
        <td class="contenttext" align="right">300.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Automated Time Attendance and Production System - Recurring Costs</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20088</td>
        <td class="contenttext" align="right">4,088.70</td>
        <td class="contenttext" align="right">4,088.70</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Construction/IT Installation (Willow)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20330</td>
        <td class="contenttext" align="right">405,000.00</td>
        <td class="contenttext" align="right">405,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Continuity of Operations (OY 4)</td>
        <td class="contenttext">CACI</td>
        <td class="contenttext">20083</td>
        <td class="contenttext" align="right">645,878.04</td>
        <td class="contenttext" align="right">645,878.04</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Contract Change FFRDC Test</td>
        <td class="contenttext">TBD</td>
        <td class="contenttext">20397</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">DCIPS Support Travel for end of OY 1</td>
        <td class="contenttext">SAIC</td>
        <td class="contenttext">20305</td>
        <td class="contenttext" align="right">797.00</td>
        <td class="contenttext" align="right">797.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Demolition of exisitng network cabling in 5D365</td>
        <td class="contenttext">Lockheed</td>
        <td class="contenttext">20362</td>
        <td class="contenttext" align="right">13,037.00</td>
        <td class="contenttext" align="right">13,037.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Desktop VTC Maintenance Agreement for 24 DVTCs and 20 VoIPs</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20336</td>
        <td class="contenttext" align="right">23,851.00</td>
        <td class="contenttext" align="right">23,851.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">DISES/DISL Performance Management Review</td>
        <td class="contenttext">Scitor</td>
        <td class="contenttext">20237</td>
        <td class="contenttext" align="right">97,992.00</td>
        <td class="contenttext" align="right">97,992.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">DTIC Unclas Website Host/Maintenance</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20087</td>
        <td class="contenttext" align="right">3,000.00</td>
        <td class="contenttext" align="right">3,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Executive and Spec Proj, St of Annual Assurance</td>
        <td class="contenttext">Scitor</td>
        <td class="contenttext">20086</td>
        <td class="contenttext" align="right">225,982.40</td>
        <td class="contenttext" align="right">225,982.40</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Executive Schedulers for front office</td>
        <td class="contenttext">Scitor</td>
        <td class="contenttext">20351</td>
        <td class="contenttext" align="right">191,272.00</td>
        <td class="contenttext" align="right">191,272.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Executive Secretariat additional FTE (new start within OY 3)</td>
        <td class="contenttext">General Dynamics</td>
        <td class="contenttext">20151</td>
        <td class="contenttext" align="right">23,871.12</td>
        <td class="contenttext" align="right">23,871.12</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Executive Secretariat Support (OY 4)</td>
        <td class="contenttext">General Dynamics</td>
        <td class="contenttext">20042</td>
        <td class="contenttext" align="right">588,097.92</td>
        <td class="contenttext" align="right">588,097.92</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Facilities and CoS Administrative Support (OY 3)</td>
        <td class="contenttext">MANTECH</td>
        <td class="contenttext">20085</td>
        <td class="contenttext" align="right">308,366.52</td>
        <td class="contenttext" align="right">308,366.52</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">FFRDC Study on Environmental Ponds</td>
        <td class="contenttext">MITRE (DoD FFRDC)</td>
        <td class="contenttext">19998</td>
        <td class="contenttext" align="right">250.00</td>
        <td class="contenttext" align="right">250.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">FFRDC Test</td>
        <td class="contenttext">Aerospace (DoD FFRDC)</td>
        <td class="contenttext">20418</td>
        <td class="contenttext" align="right">50.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Front Office Admin Support</td>
        <td class="contenttext">Alpha Tech</td>
        <td class="contenttext">19983</td>
        <td class="contenttext" align="right">525,000.00</td>
        <td class="contenttext" align="right">525,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Ankara Turkey</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20348</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Mexico City Mexico</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20383</td>
        <td class="contenttext" align="right">2,300.00</td>
        <td class="contenttext" align="right">2,300.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support (Baku, Azerbaijan)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20251</td>
        <td class="contenttext" align="right">8,000.00</td>
        <td class="contenttext" align="right">8,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support (Tel Aviv Israel)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20234</td>
        <td class="contenttext" align="right">2,100.00</td>
        <td class="contenttext" align="right">2,100.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund Cite for Official Travel Support - Egypt</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20384</td>
        <td class="contenttext" align="right">2,800.00</td>
        <td class="contenttext" align="right">2,800.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Amman Jordan</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20307</td>
        <td class="contenttext" align="right">775.00</td>
        <td class="contenttext" align="right">775.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Amman Jordan</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20349</td>
        <td class="contenttext" align="right">400.00</td>
        <td class="contenttext" align="right">400.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Doha Qatar</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20317</td>
        <td class="contenttext" align="right">800.00</td>
        <td class="contenttext" align="right">800.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Ethiopia</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20306</td>
        <td class="contenttext" align="right">699.52</td>
        <td class="contenttext" align="right">699.52</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Riyadh</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20316</td>
        <td class="contenttext" align="right">2,100.00</td>
        <td class="contenttext" align="right">2,100.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support Tunisia</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20253</td>
        <td class="contenttext" align="right">1,400.00</td>
        <td class="contenttext" align="right">1,400.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support US Embassy London</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20296</td>
        <td class="contenttext" align="right">6,680.00</td>
        <td class="contenttext" align="right">6,680.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Fund cite for official travel support: Rome Italy</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20233</td>
        <td class="contenttext" align="right">300.00</td>
        <td class="contenttext" align="right">300.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Funded FFRDC</td>
        <td class="contenttext">MITRE (DoD FFRDC)</td>
        <td class="contenttext">19999</td>
        <td class="contenttext" align="right">100.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Human Resources/DCIPS Support (OY 2)</td>
        <td class="contenttext">SAIC</td>
        <td class="contenttext">20091</td>
        <td class="contenttext" align="right">208,693.96</td>
        <td class="contenttext" align="right">208,693.96</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Install 2 VoSIP phones for ISR Task Force at Sequoia Plaza</td>
        <td class="contenttext">Lockheed</td>
        <td class="contenttext">20340</td>
        <td class="contenttext" align="right">3,407.00</td>
        <td class="contenttext" align="right">3,407.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Install VTC in Conf Rm 3D958</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20276</td>
        <td class="contenttext" align="right">200,922.00</td>
        <td class="contenttext" align="right">200,922.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Installation and Use of Red Switch Equipment</td>
        <td class="contenttext">Raytheon</td>
        <td class="contenttext">20225</td>
        <td class="contenttext" align="right">59,766.00</td>
        <td class="contenttext" align="right">59,766.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Installation of SIPR drops at 4th floor Sequoia</td>
        <td class="contenttext">Lockheed</td>
        <td class="contenttext">20334</td>
        <td class="contenttext" align="right">7,817.00</td>
        <td class="contenttext" align="right">7,817.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Installation of (5) Conference Phones in Sequoia Plaza</td>
        <td class="contenttext">ITD</td>
        <td class="contenttext">20254</td>
        <td class="contenttext" align="right">2,179.05</td>
        <td class="contenttext" align="right">2,179.05</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Installation of SIPR fiber connector for workstation outlet in 3B1088</td>
        <td class="contenttext">Lockheed</td>
        <td class="contenttext">20339</td>
        <td class="contenttext" align="right">14,247.00</td>
        <td class="contenttext" align="right">14,247.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Installation of VTC Circuit for CS2, Suite 502</td>
        <td class="contenttext">Lockheed</td>
        <td class="contenttext">20332</td>
        <td class="contenttext" align="right">5,402.00</td>
        <td class="contenttext" align="right">5,402.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Installation of VTC Upgrades and DVTCs for Enterprise</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20341</td>
        <td class="contenttext" align="right">1,162,000.00</td>
        <td class="contenttext" align="right">1,162,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">IRMA-I Database</td>
        <td class="contenttext">QSMI</td>
        <td class="contenttext">20082</td>
        <td class="contenttext" align="right">274,811.28</td>
        <td class="contenttext" align="right">274,811.28</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">IT Equipment Installation for 5E269</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20321</td>
        <td class="contenttext" align="right">11,798.00</td>
        <td class="contenttext" align="right">11,798.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">MITRE</td>
        <td class="contenttext">MITRE (DoD FFRDC)</td>
        <td class="contenttext">20000</td>
        <td class="contenttext" align="right">1,120,230.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Network Support</td>
        <td class="contenttext">TBD</td>
        <td class="contenttext">19989</td>
        <td class="contenttext" align="right">525,000.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Object Class Test</td>
        <td class="contenttext">Pacific Institute</td>
        <td class="contenttext">20378</td>
        <td class="contenttext" align="right">120.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Obligation Project</td>
        <td class="contenttext">ArgonST</td>
        <td class="contenttext">20415</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Public Affairs Advisory Support</td>
        <td class="contenttext">Booz Allen Hamilton</td>
        <td class="contenttext">20216</td>
        <td class="contenttext" align="right">209,101.32</td>
        <td class="contenttext" align="right">209,101.32</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Public Affairs Advisory Support (OY 1)</td>
        <td class="contenttext">Booz Allen Hamilton</td>
        <td class="contenttext">20131</td>
        <td class="contenttext" align="right">53,492.19</td>
        <td class="contenttext" align="right">53,492.19</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Public Affairs Advisory Support, 3 mo extension (OY 2)</td>
        <td class="contenttext">Booz Allen Hamilton</td>
        <td class="contenttext">20108</td>
        <td class="contenttext" align="right">60,178.71</td>
        <td class="contenttext" align="right">60,178.71</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Rent, Phone, and Copier Support Agreement (Willow)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20329</td>
        <td class="contenttext" align="right">166,892.12</td>
        <td class="contenttext" align="right">166,892.12</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">SAIC Budget Support (OY 2)</td>
        <td class="contenttext">SAIC</td>
        <td class="contenttext">20084</td>
        <td class="contenttext" align="right">204,804.00</td>
        <td class="contenttext" align="right">204,804.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">SAIC Webmaster Support (OY 2)</td>
        <td class="contenttext">SAIC</td>
        <td class="contenttext">20231</td>
        <td class="contenttext" align="right">204,804.00</td>
        <td class="contenttext" align="right">204,804.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">SAPCO Administrative Security and Technical Spt (OY 2)</td>
        <td class="contenttext">Booz Allen Hamilton</td>
        <td class="contenttext">20388</td>
        <td class="contenttext" align="right">207,057.00</td>
        <td class="contenttext" align="right">207,057.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Senior Advisor to USD(I)</td>
        <td class="contenttext">MITRE (DoD FFRDC)</td>
        <td class="contenttext">20001</td>
        <td class="contenttext" align="right">1,000.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Special Travel, Libya, Dept of State</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20171</td>
        <td class="contenttext" align="right">60,000.00</td>
        <td class="contenttext" align="right">60,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">Tandberg Desktop VTC License and Maintenance Agreement</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20103</td>
        <td class="contenttext" align="right">59,096.00</td>
        <td class="contenttext" align="right">59,096.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">testme</td>
        <td class="contenttext">3GI International</td>
        <td class="contenttext">20431</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0.00</td>
        <td class="contenttext" align="right">0</td>
        <td></td>

    </tr>


    <tr>
        <td class="contenttext">USD(I) Rep to NATO (Barger)</td>
        <td class="contenttext">Government In-House</td>
        <td class="contenttext">20081</td>
        <td class="contenttext" align="right">198,000.00</td>
        <td class="contenttext" align="right">198,000.00</td>
        <td class="contenttext" align="right">100</td>
        <td></td>

    </tr>


    </tbody>
    </table>




 
I have the following jQuery code to initalize the Grid,




$("#spendPlanGrid").kendoGrid({
        sortable: true,
        columnMenu:true,
        groupable:false,
        columns:[
            { field: "projectTitle"},
            { field: "contractor"},
            { field: "pin"},
            { field: "amount",type:'number',attributes:{style:'text-align:right'},format:"{0:c}"},
            { field: "initiatedAmt",type:'number',attributes:{style:'text-align:right'},format:"{0:c}"},
            { field: "pctInitiated",type:'number',attributes:{style:'text-align:right'}},
            { command: { text: "Modify", click: showDetails }, title: " ", width: "180px" }

        ],
        aggregate:[
            {field:'amount',aggregate:'sum'},
            {field:'initiatedAmt',aggregate:'sum'}

        ]

    }); 

I get an error node not defined....































Boyan Dimitrov
Telerik team
 answered on 31 Mar 2015
1 answer
102 views
With the release the March, 2015 update, it seems Kendo still doesn't include built in grid cell hover tooltip like JQ grid. This is the only thing stopping me from migrating everything to Kendo grid. Is there an expected release that will include this function?
Dimiter Madjarov
Telerik team
 answered on 31 Mar 2015
3 answers
296 views
Hi,

First time posting to the Kendo forum(s).   I've done a lot of searching for this but could not find anything that was a good match.

I am using an AutoComplete in a cell editor in a KendoGrid.  I assume this is a common use case.  

My issue. without launching into code/JSFiddle straight away, is that I want to update the data model in the Grid with more than one field from the AutoComplete.  The data that backs the AutoComplete has several fields, one of which is the text field I show in the dropdown, but there's also an id field.  When I select a (text) value from the drop drop I want to update the calling Grid data with the new text AND id (or the data is inconsistent).

Feel free to direct me at any tutorials or previous answers.  

I did find this JSFiddle that shows how to get hold of the full data row with a select callback, but I can't see how I get to communicate it back to the Grid data model.

Apologies if my explanation is unclear.









Chris
Top achievements
Rank 1
 answered on 31 Mar 2015
1 answer
114 views
Hi,
I have created the following dojo to show how the dropdownlist is maintaining its value when a new record is added into the grid.

http://dojo.telerik.com/@bhaidar/urogi/3

Appreciate checking it out and letting me know what's wrong in the code.

Regards
Bilal
Georgi Krustev
Telerik team
 answered on 31 Mar 2015
2 answers
95 views
We have been doing all server-side SharePoint 2010 development for a while and we want to step into using Kendo UI with our server.

I haven't found any postings about how to do this.

SharePoint puts a number of hurdles in the way; some of you have figured this out because I see postings here about Kendo controls on SharePoint 2010 systems. Specifically I am trying to implement the example in this article into a new page on our SharePoint server so that I can experiment with using Kendo in our environment.  Can anyone help with this?
Kiril Nikolov
Telerik team
 answered on 31 Mar 2015
1 answer
210 views
Hi,

I'm absolutely new in KendoUI sorry for that :).
Is it possible to hide some dimensions or measures in Configurator ?
Or i should add everything what user can see in PivotGrid and don't use Configurator?

thanks,
Georgi Krustev
Telerik team
 answered on 31 Mar 2015
3 answers
517 views
I have the following grid defined in my HTML;

<kendo-grid id="reportGrid"
        k-sortable="true"
        k-pageable="true"
        k-filterable="true"
        k-resizeable="true"
        k-selectable="'row'"
        k-options="reportGridOptions">
</kendo-grid>

and in my adminController.js file I have;

$scope.reportGridOptions = {
    dataSource: {
        transport: {
            read: function (options) {
                $.ajax({
                    url: "/Home/GetReports",
                    dataType: "json",
                    success: function (result) {
                        options.success(result);
                    }
                });
            },
            update: function (options) {
                $.ajax({
                    url: "/Home/UpdateReport",
                    dataType: "json",
                    type: "post",
                    data: options.data,
                    success: function (result) {
                        options.success(result);
                    },
                    error: function (result) {
                        options.error(result)
                        alert("An error occurred updating the report");
                    }
                });
            },
            create: function (options) {
                $.ajax({
                    url: "/Home/UpdateReport",
                    dataType: "json",
                    type: "post",
                    data: options.data,
                    success: function (result) {
                        options.success(result);
                    },
                    error: function (result) {
                        options.error(result)
                        alert("An error occurred creating the report");
                    }
                });
            },
            batch: false,
            pageSize: 10,
            schema: {
                model: {
                    id: "id",
                    fields: {
                        id: { type: "number", editable: false, nullable: true, defaultValue: 0 },
                        name: { type: "string", validation: { required: true } },
                        reportTypeId: { type: "number", validation: { required: true } },
                        reportType: { type: "string" },
                        reportDt: { type: "date", validation: { required: true } },
                        releasedDt: { type: "date" },
                        updatedBy: { type: "string", editable: false, nullable: true },
                        updatedDtTm: { type: "date", editable: false, nullable: true },
                        rowVersion: { type: "string", editable: false, nullable: true },
                    }
                }
            },
            sort: [{ field: "reportDt", dir: "asc" }]
        },
        error: function (e) {
            // The error message returned will contain the name of the procedure followed by a colon followed by the error message;
            // <procedure name>:<errorr1></br><error2>...</br><errorn>
            var err = e.errorThrown.split(":");
            console.log(err[0]);
            console.log(err[1]);
 
            // Set the error title and message then display the modal error dialogue...
            $scope.formData.errorTitle = err[0];
            $scope.formData.errorMsg = err[1];
 
            // If the changes aren't "applied" the dialogue won't contain the title and the message...
            $scope.$apply();
 
            // Display the error...
            $('#errorDialogue').modal('show');
        }
    },
    //height: "500px",
    toolbar: ["create"],
    editable: { mode: "inline", update: true, destroy: false },
    columns: [
        { field: "reportTypeId", title: "Rpt Type ID", width: "100px" },
        { field: "reportType", title: "Report Type", width: "100px", editor: '<input name="\'reportTypeId\'" kendo-drop-down-list required k-data-text-field="\'name\'" k-data-value-field="\'id\'" k-data-source="lstRptTypes" data-bind="value:' + "reportTypeId" + '"/>' },
        { field: "name", title: "Report Name", width: "200px" },
        { field: "reportDt", title: "Report Date", format: "{0:d MMM yyyy}", width: "125px" },
        { field: "releasedDt", title: "Released", format: "{0:d MMM yyyy}", width: "125px" },
        { command: ["edit"], title: " ", width: "220px" }
    ]
};

The data is displayed correctly when the grid is loaded as can be seen in the attached Grid1.png image.

The custom editor for the report type displays the correct options and when the report is changed to "Sustain" the Report ID is updated correctly as can be seen in Grid2.png and Grid3.png respectively.

However when I select Update nothing happens.  I have tried placing breakpoints within the "success:" and "error:" functions in both the "update" and "create" transport sections and also in the server-side code but none of the breakpoints are ever reached.

I also tried using;

dataSource: {
    transport: {
        read: {
            url: "/Home/GetReports",
            dataType: "json",
            type: "post"
        },
        update: {
            url: "/Home/UpdateReport",
            dataType: "json",
            type: "post"
        },
        create: {
            url: "/Home/UpdateReport",
            dataType: "json",
            type: "post"
        },
        batch: false,
        pageSize: 10,
        schema: {
            model: {
                id: "id",
                fields: {
                    // Field data types are String (default), Number, Boolean or Date...
                    id: { type: "number", editable: false, nullable: true, defaultValue: 0 },
                    name: { type: "string", validation: { required: true } },
                    reportTypeId: { type: "number", validation: { required: true } },
                    reportType: { type: "string" }, //, validation: { required: true }, defaultValue: { reportTypeId: 1, reportName: "Phase 1" }
                    reportDt: { type: "date", validation: { required: true } },
                    releasedDt: { type: "date" },
                    updatedBy: { type: "string", editable: false, nullable: true },
                    updatedDtTm: { type: "date", editable: false, nullable: true },
                    rowVersion: { type: "string", editable: false, nullable: true },
                }
            }
        },
        sort: [{ field: "reportDt", dir: "asc" }]
    },
    error: function (e) {
        // The error message returned will contain the name of the procedure followed by a colon followed by the error message;
        // <procedure name>:<errorr1></br><error2>...</br><errorn>
        var err = e.errorThrown.split(":");
        console.log(err[0]);
        console.log(err[1]);
 
        // Set the error title and message then display the modal error dialogue...
        $scope.formData.errorTitle = err[0];
        $scope.formData.errorMsg = err[1];
 
        // If the changes aren't "applied" the dialogue won't contain the title and the message...
        $scope.$apply();
 
        // Display the error...
        $('#errorDialogue').modal('show');
    }
},

but this didn't work either.

Any assistance in regards to this would be appreciated.
Vladimir Iliev
Telerik team
 answered on 31 Mar 2015
2 answers
632 views
I have a grid with parent records and when I click on a hyperlink in the Invoice Number column I want the child data to appear below the grid. I have nailed it down to the hashtag (#) symbol in the AjaxOptions for UpdateTargetId throws an invalid template exception and Telerik escape sequences (\\ and \\\\) do not work.

Grid is in partial view (_ExpenseGrid)
@(Html.Kendo().Grid(Model.ExpenseModels)
            .Name("ExpenseGrid")
            .DataSource(ds => ds
                .Ajax()
                .PageSize(5)
                .ServerOperation(false) // Paging, sorting, filtering and grouping will be done client-side
                .Model(model =>
                            {
                                // the unique identifier (primary key) of the model
                                model.Id(m => m.ExpenseId);
                                model.Field(f => f.ExpenseId).Editable(false);
                            })
                .Read(read => read.Action("GetExpenses", "Warehouse")
                                        )
            )
            .Columns(c =>
                        {
                            c.Bound(p => p.ExpenseId).Hidden();
                            c.Bound(p => p.DriverId).Hidden();
                            c.Bound(p => p.DriverName).Title("Contractor");
                            c.Bound(p => p.InvoiceNumber)
                                .ClientTemplate(Ajax.ActionLink(
                                                    "#= InvoiceNumber #",
                                                    "ExpenseDetail",
                                                    @ViewContext.RouteData.Values["controller"].ToString(),
                                                    new { @id = "#= ExpenseId #", @statusType = @Model.StatusType },
                                                    new AjaxOptions { UpdateTargetId = "targetDiv" }
                                                )
                                                .ToHtmlString());                          
                            c.Bound(p => p.InvoiceDate);
                            c.Bound(p => p.TotalSubmitted);
                            c.Bound(p => p.DateSubmitted);
                        })
            .Pageable(pager => pager.PageSizes(true)) // Enable paging
 
)

If I add a hashtag escaped or not to UpdateTargetId = "targetDiv" then the grid renders without the exception but Ajax fails to update the target Div because the data-ajax-update="targetDiv" when it should be data-ajax-update="#targetDiv"

Controller action
public ActionResult ExpenseDetail(int? id, string statusType)
        {
            ExpenseViewModel viewModel = new ExpenseViewModel();
            viewModel.SetStatusType(statusType);
            viewModel.ExpenseModels = GetExpenses(viewModel.StatusType);
 
            // load
            viewModel.ExpenseModel = LoadExpense(id);
                     
            if (viewModel.StatusType == StatusType.Return)
                return View("ReturnedForm", viewModel);
            else
                return View("_ExpenseItemDetail", viewModel.ExpenseModel);
        }

The view that holds the target Div
@using DriverPayroll.BusinessEntities.Enums;
@model DriverPayroll.WebUI.Areas.Expense.Models.ExpenseViewModel
 
<h4>Expenses Submitted for Approval</h4>
 
<div class="row" style="padding: 1em 0em">
    <div class="col-md-12">
        @Html.Partial("_ExpenseGrid", Model)
    </div>
</div>
 
<div id="targetDiv">This is the Expense Grid target div.</div>

The resulting Exception
Unhandled exception at line 10643, column 7342 in eval code
 
0x800a139e - JavaScript runtime error: Invalid template:'<tr data-uid="#=data.uid#" role='row'><td style="display:none" role='gridcell'>#:data.ExpenseId==null?'':data.ExpenseId#</td><td style="display:none" role='gridcell'>#:data.DriverId==null?'':data.DriverId#</td><td  role='gridcell'>#:data.DriverName==null?'':data.DriverName#</td><td  role='gridcell'><a data-ajax="true" data-ajax-mode="replace" data-ajax-update="#targetDiv" href="/Expense/Warehouse/ExpenseDetail/#= ExpenseId #?statusType=Submit">#= InvoiceNumber #</a></td><td  role='gridcell'>#:kendo.format("{0:d\}",data.InvoiceDate==null?'':data.InvoiceDate)#</td><td  role='gridcell'>#:kendo.format("{0:C\}",data.TotalSubmitted==null?'':data.TotalSubmitted)#</td><td  role='gridcell'>#:kendo.format("{0:d\}",data.DateSubmitted==null?'':data.DateSubmitted)#</td></tr>' Generated code:'var $kendoOutput, $kendoHtmlEncode = kendo.htmlEncode;with(data){$kendoOutput='<tr data-uid="'+(data.uid)+'" role=\'row\'><td style="display:none" role=\'gridcell\'>'+$kendoHtmlEncode(data.ExpenseId==null?'':data.ExpenseId)+'</td><td style="display:none" role=\'gridcell\'>'+$kendoHtmlEncode(data.DriverId==null?'':data.DriverId)+'</td><td  role=\'gridcell\'>'+$kendoHtmlEncode(data.DriverName==null?'':data.DriverName)+'</td><td  role=\'gridcell\'><a data-ajax="true" data-ajax-mode="replace" data-ajax-update="';targetDiv" href="/Expense/Warehouse/ExpenseDetail/;$kendoOutput+='= ExpenseId ';?statusType=Submit">;$kendoOutput+='= InvoiceNumber ';</a></td><td  role='gridcell'>;$kendoOutput+=':kendo.format("{0:d}",data.InvoiceDate==null?\'\':data.InvoiceDate)';</td><td  role='gridcell'>;$kendoOutput+=':kendo.format("{0:C}",data.TotalSubmitted==null?\'\':data.TotalSubmitted)';</td><td  role='gridcell'>;$kendoOutput+=':kendo.format("{0:d}",data.DateSubmitted==null?\'\':data.DateSubmitted)';</td></tr>;$kendoOutput+=;}return $kendoOutput;'


Any ideas on how to get this to work?
Mark
Top achievements
Rank 1
 answered on 30 Mar 2015
2 answers
791 views
Hi,

I have a series of tabs in my interface, and notifications belong in each.
So for this, I really need to insert my notification into the DOM of the TAB (which has it's own HTML content) - in order to show it "within that area"

Is this what the "appendTo" method is supposed to be used for?
I realize it says "Defines the element to which the notifications will be appended or prepended"
But why would you use it?

I'm asking because I cannot seem to get appendTo working, when I use it, my notification doesn't appear at all, and I just need a sanity check as to whether I should be bothering to use this to "position" the notification in the first place.
Dimo
Telerik team
 answered on 30 Mar 2015
1 answer
125 views
validation: {
                            pattern: {
                                value: "^\d+([ ](SS|FS|SF|FF))?([+]\d+)?([(]\d+[)])?[*]?$",
......



this is my string value   1 SS+1(1)*  

Why it is wrong ???? 

in console   :   /^\d+([ ](SS|FS|SF|FF))?([+]\d+)?([(]\d+[)])?[*]?$/.test( '1 SS+1(1)*' )     that is true .
also I am testing it on web service  https://regex101.com/#javascript    -    that is also true 
Petur Subev
Telerik team
 answered on 30 Mar 2015
Narrow your results
Selected tags
Tags
Grid
General Discussions
Charts
Data Source
Scheduler
DropDownList
TreeView
MVVM
Editor
Window
DatePicker
Spreadsheet
Upload
ListView (Mobile)
ComboBox
TabStrip
MultiSelect
AutoComplete
ListView
Menu
Templates
Gantt
Validation
TreeList
Diagram
NumericTextBox
Splitter
PanelBar
Application
Map
Drag and Drop
ToolTip
Calendar
PivotGrid
ScrollView (Mobile)
Toolbar
TabStrip (Mobile)
Slider
Button (Mobile)
Filter
SPA
Drawing API
Drawer (Mobile)
Globalization
LinearGauge
Sortable
ModalView
Hierarchical Data Source
Button
FileManager
MaskedTextBox
View
Form
NavBar
Notification
Switch (Mobile)
SplitView
ListBox
DropDownTree
PDFViewer
Sparkline
ActionSheet
TileLayout
PopOver (Mobile)
TreeMap
ButtonGroup
ColorPicker
Pager
Styling
Chat
MultiColumnComboBox
Dialog
DateRangePicker
Checkbox
Timeline
Drawer
DateInput
ProgressBar
MediaPlayer
ImageEditor
TextBox
OrgChart
Accessibility
Effects
PivotGridV2
Licensing
ScrollView
Switch
TextArea
BulletChart
QRCode
ResponsivePanel
Wizard
CheckBoxGroup
Localization
Barcode
Breadcrumb
Collapsible
MultiViewCalendar
Touch
RadioButton
Stepper
Card
ExpansionPanel
Rating
RadioGroup
Badge
Captcha
Heatmap
AppBar
Loader
Security
TaskBoard
Popover
DockManager
TimePicker
FloatingActionButton
CircularGauge
ColorGradient
ColorPalette
DropDownButton
TimeDurationPicker
ToggleButton
BottomNavigation
Ripple
SkeletonContainer
Avatar
Circular ProgressBar
FlatColorPicker
SplitButton
Signature
Chip
ChipList
VS Code Extension
AIPrompt
PropertyGrid
Sankey
Chart Wizard
OTP Input
SpeechToTextButton
InlineAIPrompt
StockChart
ContextMenu
DateTimePicker
RadialGauge
ArcGauge
AICodingAssistant
SmartPasteButton
PromptBox
SegmentedControl
+? more
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Chester
Top achievements
Rank 1
Iron
Simon
Top achievements
Rank 1
Iron
Douglas
Top achievements
Rank 2
Iron
Iron
SUNIL
Top achievements
Rank 3
Iron
Iron
Iron
Marco
Top achievements
Rank 3
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?