• The red Edit phpLens Settings icon to configure phpLens globally.
• The gray Edit Column Settings icons set column formating, charting (for numeric data), and cell colors.
• The two green Edit Visible Columns icons determine what columns are visible for the Grid and Details tables.

PHPLens
Product Supplier Qty/Unit Stock Price   0 1 Grandma's Boysenberry Spread Grandma Kelly's Homestead 12 - 8 oz jars 150  25.00   Subtotal: 150     Beverages 2 LEO Exotic Liquids 10 boxes x 20 bags  39  18.00 3 Guaraná Fantástica Refrescos Americanas LTDA 12 - 355 ml cans  20  4.50 4 Côte de Blaye Aux joyeux ecclésiastiques 12 - 75 cl bottles  17  263.50 5 Ipoh Coffee Leka Trading 16 - 500 g tins  17  46.00 6 Rhönbräu Klosterbier Plutzer Lebensmittelgroßmärkte AG 24 - 0.5 l bottles 125  7.75 7 Changie Grandma Kelly's Homestead 24 - 12 oz bottles  17  0.00 8 Sasquatch Ale Bigfoot Breweries 24 - 12 oz bottles 111  14.00 9 Steeleye Stout Bigfoot Breweries 24 - 12 oz bottles  20  18.00 10 Laughing Lumberjack Lager Bigfoot Breweries 24 - 12 oz bottles  52  14.00   Subtotal: 418     Total: 568		ProductID 6 Product Grandma's Boysenberry Spread Supplier Grandma Kelly's Homestead Category 0 Qty/Unit 12 - 8 oz jars Price 25.00 Stock 150 UnitsOnOrder 0 ReorderLevel 25 Discontinued 0 Notes   OrderDate
00> Visualize your Information   (Page 1)

Notes

The charting is configured in Column Settings: Stocks. Then we Generated PHP Code, and pasted the code (chartLens and chartParams properties) into ex180.php.