Start Building Professional
Web Apps Today
| Categories | Question details Back To List | ||||||||
smart rendering, split mode on grid I have a split grid. If i turn on smart rendering and load lots of rows the data in the split cols does not always load. it seems to be intermittent, loading data once every 3 or 4 rows. if i turn off smart rendering all works just fine. Answer posted by Support on Dec 09, 2008 02:16 Please be sure that each row has unique ID , and such id as "0" not used If issue still occurs - please provide info - which version of dhtmlxgrid used? Answer posted by chad on Dec 10, 2008 08:30 below is a sample of the xml. i am using the latest version: <rows total_count="23" pos="0"><head><column width="200" type="link" align="left" sort="server" id="Product Category" format="" hidden="false">Product Category</column><column width="80" type="link" align="right" sort="server" id="# Products" format="" hidden="false"># Products</column><column width="80" type="ron" align="right" sort="server" id="# Cases Sold" format="0,000.00" hidden="false"># Cases Sold</column><column width="100" type="ron" align="right" sort="server" id="Sales$" format="$0,000.00" hidden="false">Sales$</column><column width="100" type="ron" align="right" sort="server" id="COGS$" format="$0,000.00" hidden="false">COGS$</column><column width="100" type="ron" align="right" sort="server" id="GP$" format="$0,000.00" hidden="false">GP$</column><column width="80" type="ron" align="right" sort="server" id="GP$ % of Sales" format="0,000.00%" hidden="false">GP$ % of Sales</column><column width="100" type="ron" align="right" sort="server" id="Earned Income$" format="$0,000.00" hidden="false">Earned Income$</column><column width="100" type="ron" align="right" sort="server" id="Adj. GP$" format="$0,000.00" hidden="false">Adj. GP$</column><column width="100" type="ron" align="right" sort="server" id="Total ABC$" format="$0,000.00" hidden="false">Total ABC$</column><column width="100" type="ron" align="right" sort="server" id="True Profit$" format="$0,000.00" hidden="false">True Profit$</column><column width="80" type="ron" align="right" sort="server" id="True Profit$ % of Sales" format="0,000.00%" hidden="false">True Profit$ % of Sales</column><column width="80" type="ron" align="right" sort="server" id="True Profit$ % of Total" format="0,000.00%" hidden="false">True Profit$ % of Total</column><afterInit><call command="attachFooter"><param>&nbsp;,6\,971.00,835\,966.26,$25\,973\,795.33,$21\,453\,777.83,$4\,520\,017.50,17.40%,$292\,585.10,$4\,812\,602.60,$3\,932\,764.97,$879\,837.62,3.39%,100.00%</param><param>text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right,text-align:right</param></call><call command="splitAt"><param>3</param></call></afterInit></head><row id="1"><cell><![CDATA[RED MEATS^javascript: drillDownClicked(0,0,83)^_self]]></cell><cell><![CDATA[709^javascript: drillDownClicked(0,1,4)^_self]]></cell><cell><![CDATA[93291.9820]]></cell><cell><![CDATA[4343116.8200]]></cell><cell><![CDATA[3743817.0423]]></cell><cell><![CDATA[599299.7777]]></cell><cell><![CDATA[13.79]]></cell><cell><![CDATA[44851.2064]]></cell><cell><![CDATA[644150.9841]]></cell><cell><![CDATA[416842.9771]]></cell><cell><![CDATA[227308.0070]]></cell><cell><![CDATA[5.23]]></cell><cell><![CDATA[25.8352224121113]]></cell></row><row id="2"><cell><![CDATA[SEAFOOD^javascript: drillDownClicked(1,0,83)^_self]]></cell><cell><![CDATA[365^javascript: drillDownClicked(1,1,4)^_self]]></cell><cell><![CDATA[24662.6470]]></cell><cell><![CDATA[1856103.9000]]></cell><cell><![CDATA[1589954.2940]]></cell><cell><![CDATA[266149.6060]]></cell><cell><![CDATA[14.33]]></cell><cell><![CDATA[7490.9035]]></cell><cell><![CDATA[273640.5095]]></cell><cell><![CDATA[121313.4296]]></cell><cell><![CDATA[152327.0799]]></cell><cell><![CDATA[8.2]]></cell><cell><![CDATA[17.3130900250423]]></cell></row><row id="3"><cell><![CDATA[DRY GROCERIES^javascript: drillDownClicked(2,0,83)^_self]]></cell><cell><![CDATA[2043^javascript: drillDownClicked(2,1,4)^_self]]></cell><cell><![CDATA[222974.9070]]></cell><cell><![CDATA[5739435.1100]]></cell><cell><![CDATA[4672706.7804]]></cell><cell><![CDATA[1066728.3296]]></cell><cell><![CDATA[18.58]]></cell><cell><![CDATA[73056.4462]]></cell><cell><![CDATA[1139784.7758]]></cell><cell><![CDATA[1020002.5395]]></cell><cell><![CDATA[119782.2363]]></cell><cell><![CDATA[2.08]]></cell><cell><![CDATA[13.6141298173916]]></cell></row><row id="4"><cell><![CDATA[MILK PRODUCTS^javascript: drillDownClicked(3,0,83)^_self]]></cell><cell><![CDATA[235^javascript: drillDownClicked(3,1,4)^_self]]></cell><cell><![CDATA[53647.9180]]></cell><cell><![CDATA[1903539.8600]]></cell><cell><![CDATA[1572291.8720]]></cell><cell><![CDATA[331247.9880]]></cell><cell><![CDATA[17.4]]></cell><cell><![CDATA[10946.7726]]></cell><cell><![CDATA[342194.7606]]></cell><cell><![CDATA[227483.5885]]></cell><cell><![CDATA[114711.1721]]></cell><cell><![CDATA[6.02]]></cell><cell><![CDATA[13.0377661722997]]></cell></row><row id="5"><cell><![CDATA[BEVERAGE DISPENSER^javascript: drillDownClicked(4,0,83)^_self]]></cell><cell><![CDATA[109^javascript: drillDownClicked(4,1,4)^_self]]></cell><cell><![CDATA[8866.4030]]></cell><cell><![CDATA[558204.6600]]></cell><cell><![CDATA[424905.7735]]></cell><cell><![CDATA[133298.8865]]></cell><cell><![CDATA[23.87]]></cell><cell><![CDATA[23012.7700]]></cell><cell><![CDATA[156311.6565]]></cell><cell><![CDATA[45309.1760]]></cell><cell><![CDATA[111002.4805]]></cell><cell><![CDATA[19.88]]></cell><cell><![CDATA[12.6162461668741]]></cell></row><row id="6"><cell><![CDATA[POULTRY^javascript: drillDownClicked(5,0,83)^_self]]></cell><cell><![CDATA[281^javascript: drillDownClicked(5,1,4)^_self]]></cell><cell><![CDATA[62519.5840]]></cell><cell><![CDATA[2594456.6600]]></cell><cell><![CDATA[2246447.0161]]></cell><cell><![CDATA[348009.6439]]></cell><cell><![CDATA[13.41]]></cell><cell><![CDATA[35656.8400]]></cell><cell><![CDATA[383666.4839]]></cell><cell><![CDATA[278690.2139]]></cell><cell><![CDATA[104976.2700]]></cell><cell><![CDATA[4.04]]></cell><cell><![CDATA[11.9313231383171]]></cell></row><row id="7"><cell><![CDATA[DISPOSABLES^javascript: drillDownClicked(6,0,83)^_self]]></cell><cell><![CDATA[621^javascript: drillDownClicked(6,1,4)^_self]]></cell><cell><![CDATA[45632.3570]]></cell><cell><![CDATA[1363964.3500]]></cell><cell><![CDATA[1023755.3935]]></cell><cell><![CDATA[340208.9565]]></cell><cell><![CDATA[24.94]]></cell><cell><![CDATA[11753.7822]]></cell><cell><![CDATA[351962.7387]]></cell><cell><![CDATA[278646.6730]]></cell><cell><![CDATA[73316.0657]]></cell><cell><![CDATA[5.37]]></cell><cell><![CDATA[8.33290867637787]]></cell></row><row id="8"><cell><![CDATA[CHEMICALS- U.S. CHEM^javascript: drillDownClicked(7,0,83)^_self]]></cell><cell><![CDATA[60^javascript: drillDownClicked(7,1,4)^_self]]></cell><cell><![CDATA[3914.7500]]></cell><cell><![CDATA[306433.4300]]></cell><cell><![CDATA[216369.8650]]></cell><cell><![CDATA[90063.5650]]></cell><cell><![CDATA[29.39]]></cell><cell><![CDATA[1468.3770]]></cell><cell><![CDATA[91531.9420]]></cell><cell><![CDATA[20856.2061]]></cell><cell><![CDATA[70675.7359]]></cell><cell><![CDATA[23.06]]></cell><cell><![CDATA[8.032815826484]]></cell></row><row id="9"><cell><![CDATA[ENTREES -FROZEN^javascript: drillDownClicked(8,0,83)^_self]]></cell><cell><![CDATA[303^javascript: drillDownClicked(8,1,4)^_self]]></cell><cell><![CDATA[26428.4960]]></cell><cell><![CDATA[1139105.9100]]></cell><cell><![CDATA[952202.5097]]></cell><cell><![CDATA[186903.4003]]></cell><cell><![CDATA[16.4]]></cell><cell><![CDATA[9436.3520]]></cell><cell><![CDATA[196339.7523]]></cell><cell><![CDATA[126884.0830]]></cell><cell><![CDATA[69455.6693]]></cell><cell><![CDATA[6.09]]></cell><cell><![CDATA[7.89414630760256]]></cell></row><row id="10"><cell><![CDATA[CHEMICALS - OTHER^javascript: drillDownClicked(9,0,83)^_self]]></cell><cell><![CDATA[58^javascript: drillDownClicked(9,1,4)^_self]]></cell><cell><![CDATA[5020.2170]]></cell><cell><![CDATA[174017.3500]]></cell><cell><![CDATA[127592.4574]]></cell><cell><![CDATA[46424.8926]]></cell><cell><![CDATA[26.67]]></cell><cell><![CDATA[1016.2911]]></cell><cell><![CDATA[47441.1837]]></cell><cell><![CDATA[25352.6285]]></cell><cell><![CDATA[22088.5552]]></cell><cell><![CDATA[12.69]]></cell><cell><![CDATA[2.510526328948]]></cell></row><row id="11"><cell><![CDATA[PROCESSED SALADS^javascript: drillDownClicked(10,0,83)^_self]]></cell><cell><![CDATA[39^javascript: drillDownClicked(10,1,4)^_self]]></cell><cell><![CDATA[6077.6670]]></cell><cell><![CDATA[133422.4500]]></cell><cell><![CDATA[105417.9578]]></cell><cell><![CDATA[28004.4922]]></cell><cell><![CDATA[20.98]]></cell><cell><![CDATA[3727.9783]]></cell><cell><![CDATA[31732.4705]]></cell><cell><![CDATA[24451.6529]]></cell><cell><![CDATA[7280.8176]]></cell><cell><![CDATA[5.45]]></cell><cell><![CDATA[0.827518328635094]]></cell></row><row id="12"><cell><![CDATA[TABLETOP^javascript: drillDownClicked(11,0,83)^_self]]></cell><cell><![CDATA[583^javascript: drillDownClicked(11,1,4)^_self]]></cell><cell><![CDATA[2832.5360]]></cell><cell><![CDATA[69106.6900]]></cell><cell><![CDATA[49924.8900]]></cell><cell><![CDATA[19181.8000]]></cell><cell><![CDATA[27.75]]></cell><cell><![CDATA[216.3120]]></cell><cell><![CDATA[19398.1120]]></cell><cell><![CDATA[12206.6383]]></cell><cell><![CDATA[7191.4737]]></cell><cell><![CDATA[10.4]]></cell><cell><![CDATA[0.817363739018435]]></cell></row><row id="13"><cell><![CDATA[EGG & EGG PRODUCTS^javascript: drillDownClicked(12,0,83)^_self]]></cell><cell><![CDATA[41^javascript: drillDownClicked(12,1,4)^_self]]></cell><cell><![CDATA[15590.5000]]></cell><cell><![CDATA[451308.9400]]></cell><cell><![CDATA[402507.1190]]></cell><cell><![CDATA[48801.8210]]></cell><cell><![CDATA[10.81]]></cell><cell><![CDATA[26664.5700]]></cell><cell><![CDATA[75466.3910]]></cell><cell><![CDATA[69342.9052]]></cell><cell><![CDATA[6123.4858]]></cell><cell><![CDATA[1.35]]></cell><cell><![CDATA[0.695979079964416]]></cell></row><row id="14"><cell><![CDATA[EQUIPMENT-PARTS^javascript: drillDownClicked(13,0,83)^_self]]></cell><cell><![CDATA[42^javascript: drillDownClicked(13,1,4)^_self]]></cell><cell><![CDATA[75.0000]]></cell><cell><![CDATA[24965.8500]]></cell><cell><![CDATA[18690.1600]]></cell><cell><![CDATA[6275.6900]]></cell><cell><![CDATA[25.13]]></cell><cell><![CDATA[0.0000]]></cell><cell><![CDATA[6275.6900]]></cell><cell><![CDATA[1138.3558]]></cell><cell><![CDATA[5137.3342]]></cell><cell><![CDATA[20.57]]></cell><cell><![CDATA[0.583895716715099]]></cell></row><row id="15"><cell><![CDATA[EQUIPMENT^javascript: drillDownClicked(14,0,83)^_self]]></cell><cell><![CDATA[20^javascript: drillDownClicked(14,1,4)^_self]]></cell><cell><![CDATA[144.0000]]></cell><cell><![CDATA[18825.1300]]></cell><cell><![CDATA[15296.0370]]></cell><cell><![CDATA[3529.0930]]></cell><cell><![CDATA[18.74]]></cell><cell><![CDATA[0.0000]]></cell><cell><![CDATA[3529.0930]]></cell><cell><![CDATA[874.0832]]></cell><cell><![CDATA[2655.0098]]></cell><cell><![CDATA[14.1]]></cell><cell><![CDATA[0.301761339578922]]></cell></row><row id="16"><cell><![CDATA[TRUCK RENTAL^javascript: drillDownClicked(15,0,83)^_self]]></cell><cell><![CDATA[1^javascript: drillDownClicked(15,1,4)^_self]]></cell><cell><![CDATA[87.0000]]></cell><cell><![CDATA[1693.6500]]></cell><cell><![CDATA[0.8700]]></cell><cell><![CDATA[1692.7800]]></cell><cell><![CDATA[99.94]]></cell><cell><![CDATA[0.0000]]></cell><cell><![CDATA[1692.7800]]></cell><cell><![CDATA[466.1734]]></cell><cell><![CDATA[1226.6066]]></cell><cell><![CDATA[72.42]]></cell><cell><![CDATA[0.139412837855569]]></cell></row><row id="17"><cell><![CDATA[EQUIPMENT-DISPENSER^javascript: drillDownClicked(16,0,83)^_self]]></cell><cell><![CDATA[2^javascript: drillDownClicked(16,1,4)^_self]]></cell><cell><![CDATA[22.0000]]></cell><cell><![CDATA[187.6400]]></cell><cell><![CDATA[199.0080]]></cell><cell><![CDATA[-11.3680]]></cell><cell><![CDATA[-6.05]]></cell><cell><![CDATA[1.7430]]></cell><cell><![CDATA[-9.6250]]></cell><cell><![CDATA[153.1987]]></cell><cell><![CDATA[-162.8237]]></cell><cell><![CDATA[-86.77]]></cell><cell><![CDATA[-0.0185061078973029]]></cell></row><row id="18"><cell><![CDATA[RETAIL PRODUCT^javascript: drillDownClicked(17,0,83)^_self]]></cell><cell><![CDATA[2^javascript: drillDownClicked(17,1,4)^_self]]></cell><cell><![CDATA[23.0000]]></cell><cell><![CDATA[55.3200]]></cell><cell><![CDATA[42.1100]]></cell><cell><![CDATA[13.2100]]></cell><cell><![CDATA[23.87]]></cell><cell><![CDATA[0.0000]]></cell><cell><![CDATA[13.2100]]></cell><cell><![CDATA[951.4731]]></cell><cell><![CDATA[-938.2631]]></cell><cell><![CDATA[-1696.06]]></cell><cell><![CDATA[-0.106640483938505]]></cell></row><row id="19"><cell><![CDATA[DISTRESSED MERCHANDISE^javascript: drillDownClicked(18,0,83)^_self]]></cell><cell><![CDATA[4^javascript: drillDownClicked(18,1,4)^_self]]></cell><cell><![CDATA[325.0000]]></cell><cell><![CDATA[1073.7900]]></cell><cell><![CDATA[4301.3100]]></cell><cell><![CDATA[-3227.5200]]></cell><cell><![CDATA[-300.57]]></cell><cell><![CDATA[0.0000]]></cell><cell><![CDATA[-3227.5200]]></cell><cell><![CDATA[57.7600]]></cell><cell><![CDATA[-3285.2800]]></cell><cell><![CDATA[-305.95]]></cell><cell><![CDATA[-0.373396171152303]]></cell></row><row id="20"><cell><![CDATA[MILK FLUID^javascript: drillDownClicked(19,0,83)^_self]]></cell><cell><![CDATA[37^javascript: drillDownClicked(19,1,4)^_self]]></cell><cell><![CDATA[15581.6920]]></cell><cell><![CDATA[240997.3400]]></cell><cell><![CDATA[185949.8967]]></cell><cell><![CDATA[55047.4433]]></cell><cell><![CDATA[22.84]]></cell><cell><![CDATA[261.0400]]></cell><cell><![CDATA[55308.4833]]></cell><cell><![CDATA[68239.6833]]></cell><cell><![CDATA[-12931.2000]]></cell><cell><![CDATA[-5.36]]></cell><cell><![CDATA[-1.46972573674227]]></cell></row><row id="21"><cell><![CDATA[BAKERY - FROZEN^javascript: drillDownClicked(20,0,83)^_self]]></cell><cell><![CDATA[457^javascript: drillDownClicked(20,1,4)^_self]]></cell><cell><![CDATA[49564.8120]]></cell><cell><![CDATA[1390406.9900]]></cell><cell><![CDATA[1163096.2359]]></cell><cell><![CDATA[227310.7541]]></cell><cell><![CDATA[16.34]]></cell><cell><![CDATA[10095.9686]]></cell><cell><![CDATA[237406.7227]]></cell><cell><![CDATA[259625.0882]]></cell><cell><![CDATA[-22218.3655]]></cell><cell><![CDATA[-1.59]]></cell><cell><![CDATA[-2.5252802217657]]></cell></row><row id="22"><cell><![CDATA[FRUITS & VEGS - FROZEN^javascript: drillDownClicked(21,0,83)^_self]]></cell><cell><![CDATA[206^javascript: drillDownClicked(21,1,4)^_self]]></cell><cell><![CDATA[66297.0600]]></cell><cell><![CDATA[1378145.2200]]></cell><cell><![CDATA[1168195.8408]]></cell><cell><![CDATA[209949.3792]]></cell><cell><![CDATA[15.23]]></cell><cell><![CDATA[17086.5800]]></cell><cell><![CDATA[227035.9592]]></cell><cell><![CDATA[310060.1210]]></cell><cell><![CDATA[-83024.1618]]></cell><cell><![CDATA[-6.02]]></cell><cell><![CDATA[-9.43630501182526]]></cell></row><row id="23"><cell><![CDATA[FRESH PRODUCE^javascript: drillDownClicked(22,0,83)^_self]]></cell><cell><![CDATA[753^javascript: drillDownClicked(22,1,4)^_self]]></cell><cell><![CDATA[132386.7300]]></cell><cell><![CDATA[2285228.2700]]></cell><cell><![CDATA[1770113.3900]]></cell><cell><![CDATA[515114.8800]]></cell><cell><![CDATA[22.54]]></cell><cell><![CDATA[15841.1632]]></cell><cell><![CDATA[530956.0432]]></cell><cell><![CDATA[623816.3248]]></cell><cell><![CDATA[-92860.2816]]></cell><cell><![CDATA[-4.06]]></cell><cell><![CDATA[-10.5542521798948]]></cell></row></rows> Answer posted by Support on Dec 10, 2008 09:45 Provided data works correctly with latest version of grid, working sample sent by email. Answer posted by chad on Dec 10, 2008 10:43 what do you get with the attached file? seems like Firefox handles things better than IE. IE is a real problem. Also if you scroll down slowly it loads each page fine. but if you scroll down quickly it causes the data to not show in the split columns Attachments (1)
Answer posted by Support on Dec 11, 2008 04:51 Latest versions of dhtmlxgrid_spllt.js and dhtmlxgrid_srnd.js sent by email, please try to use them instead of original one. Answer posted by chad on Dec 11, 2008 07:59 that fixed it , thank you! |
