Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Large Database (Server Mode)

Time taken (ms): 1399
Page 1 of 6 (87 items)Prev123456Next
Sales Person[Filter]
Quantity
Unit Price
Revenue
Order Year(Ascending)[Filter]
Category Name(Ascending)[Filter]
Product(Ascending)[Filter]
20072008200920102011201220132014Grand Total
QuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenueQuantityUnit PriceRevenue
[Collapse]AccessoriesAncient Chocolate
Ancient Desk
Astonishing Armchair
Astonishing Keychain
Astonishing Notebook
Elegant Bicycle
Elegant Tea
Famous Frying Pan
Famous Napkin
Famous Yoghurt
Fancy Ice Cubes
Green Chocolate
Magnificent Armchair
Magnificent Desk
Modern Yoghurt
Grand Total
18595$1,739.00$86,220.0025679$2,328.00$117,677.0017122$1,559.00$74,875.0023824$2,183.00$107,376.0024519$2,188.00$111,016.0027202$2,387.00$121,202.0021549$2,144.00$103,949.0025156$2,250.00$113,157.00183646$16,778.00$835,472.00
21809$2,053.00$103,284.0024007$2,103.00$109,282.0015953$1,404.00$71,823.0023580$2,230.00$111,766.0021611$2,002.00$103,479.0024946$2,344.00$110,612.0022787$2,106.00$99,135.0022486$2,002.00$102,726.00177179$16,244.00$812,107.00
18707$1,706.00$83,750.0027952$2,414.00$125,781.0016493$1,561.00$74,390.0022262$2,016.00$103,065.0022165$2,028.00$98,848.0026610$2,322.00$118,364.0022382$2,040.00$99,123.0024582$2,228.00$113,605.00181153$16,315.00$816,926.00
21461$1,854.00$97,363.0024530$2,176.00$107,272.0018174$1,560.00$76,999.0022108$2,091.00$104,757.0026760$2,292.00$121,999.0024856$2,440.00$115,284.0021343$1,912.00$96,011.0022238$2,136.00$103,133.00181470$16,461.00$822,818.00
20351$1,864.00$90,411.0024112$2,209.00$106,981.0017610$1,748.00$81,036.0023996$2,117.00$110,950.0025357$2,472.00$118,161.0026578$2,427.00$121,879.0022545$1,998.00$104,169.0022437$2,050.00$101,222.00182986$16,885.00$834,809.00
22243$1,969.00$97,267.0025574$2,282.00$113,142.0017505$1,582.00$79,123.0023640$2,124.00$106,486.0024650$2,161.00$107,691.0025672$2,411.00$116,282.0024785$2,155.00$111,574.0022408$2,093.00$104,039.00186477$16,777.00$835,604.00
19968$1,847.00$88,455.0025609$2,356.00$119,397.0015899$1,553.00$72,316.0025768$2,288.00$117,492.0024522$2,257.00$113,499.0025914$2,352.00$121,836.0023877$2,127.00$104,441.0022878$2,030.00$100,421.00184435$16,810.00$837,857.00
20726$1,971.00$94,348.0027535$2,342.00$120,245.0017792$1,495.00$77,767.0025178$2,317.00$116,498.0023487$2,054.00$105,976.0026038$2,386.00$117,673.0022473$2,028.00$101,614.0023105$2,166.00$105,247.00186334$16,759.00$839,368.00
21316$2,033.00$100,096.0028086$2,405.00$128,797.0018375$1,591.00$82,849.0023025$2,204.00$109,403.0024735$2,239.00$111,781.0027189$2,414.00$120,124.0022276$2,058.00$103,742.0021456$2,034.00$93,213.00186458$16,978.00$850,005.00
21513$1,880.00$96,828.0026327$2,516.00$123,004.0018357$1,718.00$86,699.0024510$2,185.00$111,244.0022558$2,047.00$102,495.0024666$2,300.00$115,606.0023333$2,150.00$103,863.0026015$2,206.00$115,144.00187279$17,002.00$854,883.00
21065$1,867.00$93,595.0023561$2,136.00$106,052.0017305$1,663.00$83,351.0022567$2,201.00$103,948.0022857$2,083.00$101,327.0025216$2,406.00$116,004.0023299$2,140.00$104,702.0021655$2,017.00$101,965.00177525$16,513.00$810,944.00
21022$1,831.00$89,831.0025871$2,467.00$117,651.0019364$1,776.00$97,350.0023873$2,103.00$107,968.0022090$1,980.00$98,827.0027738$2,447.00$125,068.0023262$1,972.00$100,533.0023941$2,088.00$106,954.00187161$16,664.00$844,182.00
19221$1,727.00$87,407.0025964$2,348.00$111,533.0017069$1,628.00$80,243.0023625$2,151.00$108,188.0023941$2,156.00$107,034.0027162$2,470.00$121,187.0023398$1,995.00$103,002.0022876$2,190.00$105,230.00183256$16,665.00$823,824.00
22425$1,954.00$96,175.0026574$2,468.00$125,867.0018752$1,652.00$80,143.0024696$2,185.00$107,607.0025589$2,223.00$112,471.0025135$2,162.00$110,916.0023486$2,109.00$109,406.0023706$2,124.00$103,869.00190363$16,877.00$846,454.00
21539$1,951.00$97,140.0025310$2,308.00$115,639.0019312$1,754.00$90,282.0022188$2,088.00$102,654.0021920$2,089.00$99,422.0026721$2,403.00$117,980.0022266$2,038.00$102,776.0023660$2,221.00$109,046.00182916$16,852.00$834,939.00
1661395$150,990.00$7,544,244.002089456$189,747.00$9,501,421.001475943$134,512.00$6,733,500.001913125$174,506.00$8,699,979.001943740$176,224.00$8,814,464.002138480$194,301.00$9,636,589.001859961$169,320.00$8,451,063.001888382$173,153.00$8,628,249.0014970482$1,362,753.00$68,009,509.00
Page 1 of 6 (87 items)Prev123456Next
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

This demo illustrates how to bind the DevExpress ASP.NET Pivot Grid control to a large databases using LINQ to SQL.

With the ASPxPivotGrid control, you can easily bind to LINQ to SQL data sources via the LinqServerModeDataSource data providing component. Simply specify the type of objects retrieved from a data source and the table name. Internally, the LinqServerModeDataSource component was specifically designed to allow the Pivot Grid control to efficiently process large amounts of data. The LinqServerModeDataSource component automatically enables server mode to optimize the execution of all LINQ queries initiated by the Pivot Grid. In this mode, the Pivot Grid control performs data-aware operations on the database server side, which allows the control to quickly load and display data even if sorting, grouping, filtering, and summary are used. This technique significantly improves the Pivot Grid's speed and responsiveness.

You can try this feature in our Sales Viewer real world application demo.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos
SalesPersonID