147
ADOR, MDB (JET) 

with AxPivot1 do
begin
	rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.mdb',3,3,Nil);
	end;
	DataSource := (rs as ADODB.Recordset);
end
146
ImageSize property on 32 (specifies the size of control' icons/images/check-boxes/radio-buttons)

with AxPivot1 do
begin
	BeginUpdate();
	ImageSize := 32;
	DefaultItemHeight := 36;
	HeaderHeight := DefaultItemHeight;
	Font.Size := 16;
	FilterBarFont.Size := AxPivot1.Font.Size;
	ToolTipFont.Size := AxPivot1.Font.Size;
	Indent := 26;
	Images('gBJJgBAIDAAEg4AEEKAD/hz/EMNh8TIRNGwAjEZAEXjAojKAjMLjABhkaABAk0plUrlktl0vmExmUzmk1m03nE5nU7nk9miAoE+oVDolFo1HpFJpU5h8Sf9OqFNqUOqN' + 
	'UqdPq9VrFWrlbr1QpdhAFAkFis1ntFptVrtkrpszrNvmVxqk3uVtm1kmF3sdBvF/wGBmV+j9BYGHwWJulfxdax2NyFdx2JlV6l9Nw7AAGZymdz2Cy2GxErvWcz9ivlwy' + 
	'V21cuxugwktzGIzmvwtl0+53U5y0a0Wazmmyu/3dCyOMyXHx/J5nIr9q3uyqnBxFN3G46ma4vb7mD2Ng4nZze00fDkHC7t7us2rOX5tguetpHRlmz4HVqnXk1PjHO+CM' + 
	'Po9MBMC+j2vC8j7wS8cFNI4kBo05UIvfCT/NsnsApU+0Fqg/T+oy/kPxC0sEQfErKQK96+w28UWRI8UGvO8sTLS9r2PWmsMJTDTask3CsIbIEQRA3shOXEEAO/GclJ9F' + 
	'EKrrA8FRbKMXRIlb0JxCkjS1LMswhCcvuel0cv26cSMa8Ufx+2sQwhEUoSXOCjSbLcnxjKc7sdKUVyq28NtVI71P9P7JxtQEapjQ6fzfM8zPfNE2PhIsLL63E40slk5y' + 
	'7N89LcyU9SvMb3SdUc6VJLj5VLVLfO/PS9KzNFHUa/0XyBD0dxlS9cxhMlTRSoNXypPErWDPyfNS+MwprRNO0FD8wVVZ1AI08URwVRjtJ1WCn21QkkUrXVLVPQS/XIkF' + 
	'gTxT9iONZ9xVTdq+L1eKg3kkF6Upe68XtfV51/MtrVjBlwYFL1ev8y1/P6/lyzzYl02wntj0RVFmS1Qa+M5as93QxEUW9e993rfmQ2+vy65M/mL1lhl/2bj2ByVduMtN' + 
	'hCJT9hdz41nN14Ld12Z9UjfI/oUAaGseiw6+uFLLhcVabJOS5RqOE0BHlZ5VnEr5fOMs3st+aa/bbRzrJGV51Y0b0DbqaWXZD90hIsPbjWu52+6Wyadpe66hhO+P/Xio' + 
	'W5rD8ZbrUZuVg6n1dsE/cXmewu1m9PVwnd35/nueXho/NaJzmjc61W76esuT77eG8pTquy9TwWH8LEzG8RDfFalx3Gcfvna9rvG/cptGLd9tuI6TZOP5Fiqi99vea+X4' + 
	'VRcBq/JZZtVQ9cwSs5lsXE372+a9z7PbfB3VVqHyvMctLto8uob6eV0m/cD6MN2v+T33t6sBut42vdv2bJ8a997x2maFJfK+qArbGJPEKE+1qTflMsIdW/GCJX17KcT6' + 
	'/czr/X+u1g29B7j/4BQfWkkx4zIHisjhPCmE0K4SwtXM+d4BvHRwNZOoBph9IJvPek9d40FoMJxf691jj2ywQQcHEWET4XJwkTszlVqm2GokewxtBT1DpQjRxDN0rUVD' + 
	'NKdC3lb6tzNOwh6upMSSYfv4YBCl/bsn9PxiFCEo7SI6Obc9HeOrnY8x4jtHtdpN4GRbaorhsbu18Pph5CiHymI0RpSXGJ/z2oUOxYxG858AyiI+bfJtuTcG5yelBJyT' + 
	'8okhqFd4a5yxL0rvulYtKCsZiWxWkc1s1cRoxxwhA31DLE0mR9l9HqX8fJgTDmFMVH0MIsRzVYnwnMi1dyzmhLt2kS2pxIiU62Wj5ptQGlSYFakLonTUJNLKaM5Wzlff' + 
	'EkuFkk5wTrhVO2eE7G6lJhxFFYUZ55zmn0WuBCD4pzhirFCKkbomsOoIYmZx5p90LoYWGPdD5g0QmJRKYxbZ6zYoVQ2jVGylSak7KSkFH6RSjpHKFuU+YMyNo5SulkC6' + 
	'I0vonTCitMXPoEpVS2H5FQfEqp2R1opIgAEkJISYARTCukOhmPNI5Ex/wzGHUsicMwA1LHgQ90Y/KpoQHAD+pB/R4NzIaMAB9Xaw1gqaAOsh/A/ptIkWUfhGK1kZH8Rg' + 
	'H5GqvgArqRmt4AAPrTroRofBGADkqr6Rmu4D7CEaHARiwpJrEEZsXXwlVjyMWRsaRqwdkLGNBABZmytmyMnaINZqyVpLR2ftKAAAdd6h2osbaskdiq4EZtgSmyNcbVWR' + 
	'JNXe3AA7REar3b0stlAAXBtoRmvJGLjEYAHUWsFcwCD/rnaop9aEICMAPdK5hT6xpeuzdOtAgKuJeGfdq6ggEbkTvAP+p9UCHXrvKkcgIA==');
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABfICg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' + 
	'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' + 
	'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsOatVqjG5sYjcGC3La9cz3Pq/bpuDCbMxuaK1TrYXr1TTrcofBDldAxXRKDxR' + 
	'DWVhLnYOw9i6XxzjuXprCaOoKB6EwbiCZZCGOdZYlcT4xHmbhMnwNxtn+G5bmqdZ7n4Pw/i+X5zm+dQ9g4CAFjsfAJheOI8HsDoWDWTB/lwSAQkmA5PEgRYoDyDwYFYF' + 
	'oFmGCBmBqBphDgRJ0gOTIYBGRB/lyRh0iSCZbjYWJzgWDwIjYLoLmMCJGDKDJjBgWgqG6YhyhGHRzA2aJ1mCABOAiOJvhCZBJBYRoRmSCQmEqEQimkAZgg8TZnDCV4Uk' + 
	'mCUmBKZYJGYWoWCUUhiFMNZckNUh2GENoaGaGZmgmJhqhqZpGGIEx2GYIxSGGGJdggWJth2Z4JmYeoemeSZ2H6H4hGmQhihyTRHGYLg7CiCgmgqIpokoNoOiOaJ4jqAo' + 
	'chqaZGgaCxpAoZoaiaaJqEmWIcGgShcnCJwqEqFoR3YOoFlgchflqNouiuawHmWSYqGkWZQhcatzmaOoumuSp2j6L5bBaKo0GQKRnGGCxqiyCwmkqMpsksNpOGUGI7A0' + 
	'ew1G0Rxlg0PptgsZuDG2Sx2l6N5tnYNZZjUDRXDCVo5l2FoymqOpukuNpujubwLjmWY5k0ZwxkaFxYlWdp6j6b5Lnafo/nABQdg2FxcUsY5BkmXAkmeQpckwNRrkKTh8' + 
	'CSHZBk4NwyC4KxxgMDwakOMZDn8GgwnGAo2C4cwthMcwmCcMoHBMHRehwTIghySYNksZwcH4HBMEsHx5hyPItiweYxnwSZEH4Mozn0fR+DMAo7EYJ50gkdZelKdNql2U' + 
	'gJn0GIukwH4HicQRai2GI4mSVpNl0dZGledgNgcYpYDWUx3FsOQi5YV5anaTY3G6W53A2RxylydxFjiaxEFCCgBBAQ==');
		Add(2,'gBFLBCJwBAEHhEJAAEhABcoFg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' + 
	'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' + 
	'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4n' + 
	'GKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEokiEN5NCKfJ9DyTRjnSc' + 
	'g1CEYxOBmBpPCgagdgcIZoHoGIFA4AxQkCAxKAgKBwgGSpIBCZhjF2E5UnQPQMiMCJBCIBwxkSQgsgo+JtDKT4ziiQw+k6EwAnsOgLnkHI+yCQ4iEuE4klkPhShEJBpA' + 
	'oPgymOMoaDgHBjFMBgyD0HYTiCZSZhIIIGC4ChiHSew5kwM5omILZPiOBI0hwZw5kodIdA+M4Uj4PxOmMSJ9DuTQzmyZgviceZagaHVfj4awwmaAh2GUIYmCOEZZDaDR' + 
	'DFGdwcg4EwyHMN4LBOaJbCoaZqgKH8qkMfIyD8DozDyfA7A0Coui0OpMmOZJdCsahKg6NooioChwmEMxLEoXJbDUTRXGSUgykyMgQG0GpPHMdI3D4TRCgSeQ0kmaw+lG' + 
	'NAtCOZJVCiT5DhyRQwAqMg0EoDBBGEGAsASC5yiSCw+k4Mp6lWNQuksTpRjMTxDGzJwGmGMpDDKXYTECSAxl6Q5olkK4PgMMIVkASRMBMBgzEkaZEjsNALhIZA6AeQBg' + 
	'k0ZJEgAAJ0CIAgODMNIsD6DRih9uYwFyAwfCUb5ijmbI+gwdxkk8MZMGeMpPCkDxzBiC5MHMPJLDSSROFMLIoBEQogEMFJPnENYQGgE4DCOaJfC7tYkhGTQ0kyWwykuX' + 
	'pMiyRpKjKR4wngM4JmOWJACCdYtHMWw+Eych4nINYLAEYA8AgdAEEsQZajaQoog4GxPiMVIolcdxNG8XZVkmNoRwWRVBlFeFEeAZQJgnFiHgHwcAhjhHgGMSI5xki2Cy' + 
	'A4EQsA3i0HkBsLwKRFgAHcPkHopBJBcBeDUYI7xyDOHqKkWo2hLCsDIBIY4qQ5A8DoMMYwOAqCSBGKgU4yB2iDBwIgB4hxQgAAWNgBoAgsBdEcBUQ4sQ9A/HqD0JI8Rp' + 
	'BzH2OYVgahLBHFiJQJweQiDhDUE4SAARQAzFsG0EQwA6AOWSBkFgVAIBCHeGERQFQiCQHeFkC4vkiB8DyB4F4QxVDvGMNEOQexMjlBeOAKQiQLgfDA7QEAaRiBdEkH8T' + 
	'I7AZiFBAGYBIABWjYBiGACioQ4C1A+AMMgWhfgxHgPsT4URIB0COKgPgjRwiAB8AYUArxBgCF6J4GY5hrAOCAPAAoGRRCsCIMEXATXfgAF8BMJwURuEQDgD4Q4OBoAeH' + 
	'GFgLIwQrC2D0JoSQ+QvhrHoSgQI8AbDFGID8C4Ah6BQAQAASACwgCYCMAUMARAvCKAiAMCAokeCKBEOAKgCBoDaHuMsEAqwJDiACDURg8R6gPCyDofYWAhgoDIJ4ZAuh' + 
	'oiGAYGgRoQw/A0GMMga4GwxiEDeIYYInATCDBQAoBAwAoDlA0KMBoVRGiDGwDQUYIRsgaGGDgM4LAwDWB8EcIA1APhjEgGQVwgRIgjFIIQHokgZA+CSEkLIKQSjHAwMs' + 
	'CwDAsAEB2ABTIwRwD6A8CMToSxkAxE4HYIw+BsgbBEDAHYBwojCBoIYFgXSjABE4MsHIbQWhlGILQS4UhvBdAUKEEwHgxDAAABQQQUAhgKHiDwE4JS4A7BGLQZwCR4ga' + 
	'BEMUYAqgKApHgGwVAIRNgvBMMQXImwZDtE4I8UIyAZCDCAE8AwrhgAdEEBACQLRCg4FEB4AYtA7CdEiPQMoJAMDNCkOMCAXAFDhH0D0Q4EgfAaGSK4NYzRUj9BuCgAgs' + 
	'wOBjB4Fqpw8B2ADAwE4A4Qx2DAE6JIaQPQGhAGKBcIQ5B5gHByKIFARwADbAyKUfgdBKBBGyEcVIAB/ijHoIoSA0gdBNl+OATYERZgBGSDYWIWAUCEGKA4FAhR7CIBtY' + 
	'QGYZg4CMAiKEcAOwkBjHWE8Z4lQgA+DkBoTohwwCeAaMEEgBQCCABgHMRwQRhhMEWFQd4HwZgwDqFESItAbAGEANCpINAzANCCJkK4ah+heFYBURwsQrS2CsMYMoWGBh' + 
	'YDWI0EInQgiApXaOVI1QFDsC8MUNoMBMA1HMJga4eh+BeAWOgNNowGjYzCGAAwax+iJBeBVT4gxoBIAGFsJFBxgBiGKFkKQ7g5DFFQEcAo4AzDDACKEQQLgCiJDYB0Mg' + 
	'RBCCQAgQEA==');
		Add(3,'gBFLBCJwBAEHhEJAAEhABQ4Fg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziaQAGgkNQwCSLIwjNIsBxPFKVQChEYxSjKA40SJNUgyj6' + 
	'CCY+QLIE5PfQgAL9I6eJABCCSQKkYx0HScRiwPBIbAZAYhCZqaKhWgkKI/WBQIABRDVLx5ESiLRtKy7Mq2bpvXBcNxXHalaztO68LxvKyqHb5fJ/PpgL4YHgmC4NQ7EM' + 
	'RwF6rfbyfZ7Xg/ORPTijZ4sdzMHTzJyscx3HqfaBoOaZU5eMLceTUMofHIndxCcasPbsLpOS5LNKsaxmWLYdhFdTxQi6LpvfA8BwXC6JY7heRYRbFbYxRjGNi1TS7G4n' + 
	'GKd5WGuL4UHwI4VkaYxii8V4pgQMgVBQdQ5iCTYGi8T4vlWbJ3nuPg+l+H5AlSCg6ByPBoE8Ap3jqYxhBido5g0OgOGOGI4CsSpCCAcgcAuEosiYN5NHMOJ+D4TpTnSe' + 
	'Q7CEY4uBmBpPhgagdgcIZoHibIEyUBJZDQIJShoCgcCAcoyAQOYYlcZJ1D0DxDCiQgwEiAZMHEMJLFKPJ9D2DoDnidQ4k+Y5QmKEROBkIhKD0JIZDIS4TGUCQuEeEJjn' + 
	'OIg8CuY4RkYNgwGMM5RllGpThDRYIGKZIpCkJFUH0PINyWcQ3CaaZCG+HBnEOTJhD8Tx4GoeQ/GcaZSHOH5nCmQhshoZhihYYwhiYA4RlkNoNEMUZ3ByDjwEsPxOnMaJ' + 
	'9DuDR6F6GYmCmKh0nANtMioP4Gg8aoSiIO5NhodociqaY6GaFYkEyOg8lsNRNTaUgykyMgQG0GpPiONJbD8DpDEyfA6k0KwOkWMQsGsAJU0SagwkoJQJDIPISCQCJTGS' + 
	'UwyGaM4KkmMgtksHpFjAZ4TGCBAbgaSpcksdhNAMIJHHsD5TjSWWMAMOpwjyLwbk6cAz0KRJiDkDYzESCwiggcgcgYIQwCIEINCMCITj6TVxkMXp2j0cQLlCTo7E2F4y' + 
	'mkMZdhMPJHDGHpLAyVg+k4UwrCCSIyByDJ8DuDY8CiWY0kiXAXC6QJwFKGIjCeJpjgyezjlyDw6klHx5myRoMGwZwbkcToTEiew4kwbQfEmUgPkOKJUD4DpTHSHQmgkX' + 
	'I/ASTA1g0XIEDMTBimyfI7jSLYHEiUoPk0Fw/kadAsHGao8A0A5smEMJ2mNyg5gzJZwDgCpChyIZVyIZwFCMJEPASRkBqE+IcHInRcDxA2H4bIsx0AtDsIBpwZwYicD6' + 
	'BscwDwUBgHCIYaIfgtiVH2O4WgUwJjEFeAEQA7y4hMCiBMS4aRdB9A4CYE4LxljyBMHcDItBxinDCLcTYmgejBFQ9UTg9gFBOEmAQTI7A4iZGMGkQAWQ7jYA2HIL8BRA' + 
	'jDG4HcCwARbjZHiNoDw1nLDnGyNINQ+wjCpBMEgcovQUgICQJEcgWRuBvAyJ4d4ugpCUAINcHogxIgnDiM4N4axzD3F2JMTY/hRqYF6FsWIxhYAGGoAALQYgYirBwBEB' + 
	'wpAjBEAAIEIYsA2gOHCMAGgXAACIDmMITAUgFABH0D0I4WwvhNFGMAOIvxRD2GKNcMA8gjAPDCPwBogRPAxA8PgRwZRICYDED8RAXQEghEAN8DIgwIBdB4JYWwMgtiQH' + 
	'oFQKAiRFguFKGwGQhglDsEOVwEQQRkCKBwOIHgSREDRBYHEXQcQdD7GIGARQHRxipBrMobgewDCUCADsEYWAzgMHKHQDQxxsDzA6EMfAeQHB4GQDkUYPA0iECiKoGgRh' + 
	'cDdA2GMQA8AOCjDSPgHI4QnApAKBICwHg1A+BcAwcYsgbjGGQNkCIgRsA6EcBEWANADjsB0B8YYzQQDIGSBcEYZBCCPEkFIHQSgkgZAwG4IwBAbAYGGAgL4Ch4g8BOCQ' + 
	'AA2KKC0GcAke4AAXAFCoHkDw4xbBFEcJkE4JRSiEFeJYKQVRMgJHODwX4xAgC/AsIIZAeAHDRG0HYI40RKCLEGDUI4jAghwBWIceA+whCpHMFYZYOQxglDMHMBQGxYjV' + 
	'HiAoBIPgfgHGwPsHYJRSB6A0IERQLhCjJHMA4OQoAoCOACLYGYSx8DpBQIMWQdRnDRH+DsE4fB3CeAmM67kAAXBFEIDYDI7wLBtEoEIfYNwjiUGGJQYQMAjCHEAO0C4z' + 
	'xW29CoCgfIxR9AKA6J8BgUAIhDGMIoJ40hqgwCgKETgnBhhqCGI0AIqgZhGDANQDIlBDCRGkCoJISR0g1BSKQOgfAzBRG0DYHARh4DeDAOwANuw8ApCKKkYg/RPhjBsH' + 
	'0J4yg5hPGWN0GwFBHQBFaDoQIURljFAoB4GgzRVzbBECQFQRQoguHGHANwDRdCKy8CgSIGwhhoDYJYYI1giBICSAEgI=');
		Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' + 
	'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' + 
	'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' + 
	'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' + 
	'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' + 
	'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' + 
	'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' + 
	'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' + 
	'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
	end;
	(GetOcx() as EXPIVOTLib.Pivot).BackColorHeader := $4c6c6c6;
	(GetOcx() as EXPIVOTLib.Pivot).SelBackColor := $4000000;
	SelForeColor := Color.FromArgb(0,0,1);
	set_CheckImage(EXPIVOTLib.CheckStateEnum.Unchecked,16777216);
	set_CheckImage(EXPIVOTLib.CheckStateEnum.Checked,33554432);
	set_CheckImage(EXPIVOTLib.CheckStateEnum.PartialChecked,50331648);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exSelBackColorFilter,SelBackColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exSelForeColorFilter,SelForeColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exBackColorFilter,BackColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exForeColorFilter,ForeColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$4000000);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarActive,$4010101);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$40000ff);
	HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
	GridLineStyle := EXPIVOTLib.GridLinesStyleEnum.exGridLinesGeometric;
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '12,0';
	PivotColumns := 'sum(5)';
	PivotTotals := '/sum';
	DataColumns.Item[TObject(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
	EndUpdate();
end
145
ImageSize property on 16 (default) (specifies the size of control' icons/images/check-boxes/radio-buttons)

with AxPivot1 do
begin
	BeginUpdate();
	ImageSize := 16;
	Images('gBJJgBAIDAAEg4ACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjMLjABAAgjUYkUnlUrlktl0vmExmUzmk1m03nE5nU7nkrQCAntBoVDolFo1HoM/ADAplLptImdMYFOqd' + 
	'SqlXq1QrVbrlGpVWsFNrNdnNjsk7pQAtNroFnt0sh8Yr9iulTuNxs1Eu8OiT/vsnsNVutXlk/oGGtVKxGLxWNtsZtN8iUYuNvy0Zvd+xNYwdwvl4p870GCqc8vOeuVtt' + 
	'mp1knyOayWVy+WzN/ze1wOElenm+12WUz/Bv2/3UyyWrzeutux2GSyGP2dQ33C1ur3GD3M4zUNzHdlWjq/E3nGzVpjWv4HA7fRy/Tv2IrN8rPW6nZ3ve7mUlfu20Z8ac' + 
	'vQyb+vY9jasYoDwMm+LytVBDqKG3z8O3Cb8P+mkAuY9cCQ2uL4KaxDKvkp8RNLEjqugnrwQo/UWPzFyeQw5sNLZFENrI4kOqU66pw8uzmOKvTqNqjULJvGL1JO48GtTG' + 
	'sbLdEL3scxLlyiw8dQeoUVxdLTtyKmUjwGlslRPJsnK1HbAKbKCrsQo8uQk/CeP44iaR/ATnTNPLvyxPU+z9P9AUDQVBowiofJXQ6Oo+kKMpIkjztE4TKn4P6JowfgPn' + 
	'wD5/nAjB8AOeAPo0eAA1IAFH07UhAIMpYAVIYFHqBUhwVjV1S1EtQAHxW65V0AZwAeuQAnwB5gAPYViEDVhwAHTQBkCjB4gOhwDmCyhH0sACAg==');
	with VisualAppearance do
	begin
		Add(4,'gBFLBCJwBAEHhEJAAEhABUYCg6AADACAxRDgMQBQKAAzQFAYbhkGCGAAGMZxRgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjHL' + 
	'UXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQShsFYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU5EUiXJJ8ZxnECfYyrGjaMpCeKBU' + 
	'rGYTVRBIMxLLSia5oeJqMrnBpNVrIUgXCAGFwHK6BcauXIIDp6XoWWRbAAWDpVVzNNC3YzkCIceADHKiXxmVz4JLdGZ1QTGID2XaYaxWK4oZjsVSc4KDHbETbHFi9Fo3' + 
	'NaaxGisew+GYc4HlCR5NAAAIIEkQJSGMOgdE4RhYDwJJsAaAYQgmPpolCWgSCiBJzjcEIAkQXIBm8d5UhOQgCDUIBDDJDhgggJgKgKYJIDSVoDk8KBFF4OohEMZgWDsY' + 
	'YDj4GoGmGSB2B6B5iAiBgYDsYRjGSbIJo4RgqDuIpIAoLoLmMCJGDKDJjJiLA7xqUAAgGTwYnYPoPmQCQGEKEJkEkFg9gGY44BoRoSmSSQ2EKEggHgRhShSZRJFYVoVm' + 
	'WCRmFKFAgGOTheheZgJgYYoYmYSYWGaF4lkMMJ0hqZpJjYbobmcCZGHKHJmjmJh0h2Z4JmYcIaE8WZ2H6H5oAoBoCiCaBKBYfdjGoJoKiKaJKDaDojmkChGgmIgpCoVo' + 
	'WiWaJZiSd4mmmSh2h6J5qAqBoiiiaY5iSeIpmqComiqKpqkqNouiuah6hqMIsmsSpWiuGhP1kOoumuSp2j6L5sAsBo54gKwWkaMZsgsJpKjKbJLDaRYxYWRpSjSbIZiS' + 
	'e41m2CxmlqNptksdpejebR5iSfI4m4S4W16boLiaao6m5fJ9jubwLkaco8m8S5WnaPZunuOp4j6b5Lnac4SA0PAGlgP4wEwFwGkGcIMCcCpCnCCxiA8NYAAmMJfkSbhF' + 
	'CcFpFnGDBnBqRpUhuEwTDeZ5lHCfw6HIQxLCaAxygyJwqgGcATE4FA6hWY4tjEAAQBAgIA==');
	end;
	(GetOcx() as EXPIVOTLib.Pivot).BackColorHeader := $4c6c6c6;
	(GetOcx() as EXPIVOTLib.Pivot).SelBackColor := $4000000;
	SelForeColor := Color.FromArgb(0,0,1);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exSelBackColorFilter,SelBackColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exSelForeColorFilter,SelForeColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exBackColorFilter,BackColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exForeColorFilter,ForeColor);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$4000000);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarActive,$4010101);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$40000ff);
	HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
	GridLineStyle := EXPIVOTLib.GridLinesStyleEnum.exGridLinesGeometric;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '12,0';
	PivotColumns := 'sum(5)';
	PivotTotals := '/sum';
	DataColumns.Item[TObject(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
	EndUpdate();
end
144
Is it possible to view all events the control fires
// Event event - Notifies the application once the control fires an event.
procedure TWinForm1.AxPivot1_Event(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_EventEvent);
begin
	with AxPivot1 do
	begin
		OutputDebugString( get_EventParam(-2) );
	end
end;

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatConditionalAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
	EndUpdate();
end
143
Does your control support images

with AxPivot1 do
begin
	BeginUpdate();
	Images('gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql' + 
	'Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0' + 
	'ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN' + 
	'AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DataColumns.Item[TObject(0)].FormatImage := 'value case (default: -1;''Germany'': 1;''USA'': 2;''Mexico'': 3)';
	EndUpdate();
end
142
Is it possible to rename the generated-columns

with AxPivot1 do
begin
	BeginUpdate();
	HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
	HeaderHeight := 24;
	Import('Item;1;2;3#A;10;20;30#A;20;40;50#A;20;30;20#B;10;10;10#B;20;50;30','str=`''` eor=''#'' eof='';'' hdr=1');
	PivotRows := 0;
	PivotColumns := 'sum(1),sum(2),sum(3)';
	FormatPivotHeader := '(iaggregate ? (proper(aggregate) + ` <off -4>` + (caption case (default:`None`; 1:`Sunday`; 2:`Monday`; 3:`Tuesday`; 4:`Wednesda' + 
	'y`; 5:`Thursday`; 6:`Friday`; 7:`Saturday`))  + `</b>`) : caption)';
	EndUpdate();
end
141
Is it possible to rename the columns

with AxPivot1 do
begin
	BeginUpdate();
	AppendData('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DataColumns.Item[TObject(0)].Caption := '<b>Nation';
	Refresh();
	EndUpdate();
end
140
The pivot's rows and columns arer lost once I call the AppendData. Can I add/append data in the background so the layout of the pivot is not lost

with AxPivot1 do
begin
	BeginUpdate();
	AppendData('Def',Nil);
	AppendData('A',Nil);
	AppendData('A',Nil);
	AppendData('A',Nil);
	PivotRows := 0;
	PivotColumns := 'count(0)';
	s := Layout;
	AppendData('B',Nil);
	AppendData('B',Nil);
	Layout := s;
	EndUpdate();
end
139
Is it possible to add data without clearing the previously data

with AxPivot1 do
begin
	BeginUpdate();
	AppendData('Column',Nil);
	AppendData('1',Nil);
	AppendData('2',Nil);
	AppendData('3',Nil);
	EndUpdate();
end
138
How can I change the visual appearance of the Total button

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(2,'gBFLBCJwBAEHhEJAAEhABAoCg6AADACAxRDgMQBQKAAzQFAcDBvBgABoGEZIJhUAIIRZGMIjFDcEwxC6NIpjeIBSDUJYkSZEAyjBI8ExXFqMQCkGKocgONYgQLHcgxeA' + 
	'0XRYFoYRinWA5PoAMoyTYMdIAnTOM4eU6AATwTSccw0fisAAfeq4Wh+HwIQiUBomGahajkMqDYRVagyCI2a4ZDZCIoVJalLAxCw8KDqGJnMr1R5/MDgOBYogXBqHYhiO' + 
	'AsdhjSYdBK/WLeHI6Y1GS7MMxzLK8cxVaqfMpoMI4FjuS5NU7TMC0PAXdy3LqvbBsOxbHqma5nVSBcC2ba9cz3PK4ABuW7bM6TRKNYbkOA4LiNQaxVSrNKmIwPI5DJ5M' + 
	'l2co1h0d5vBWDJQEkCI7mIJpykyTZblqdhYDyR5TlmX5RBgeI+D4BxLDkO5nlieh5g2FQ5DOZAiDkDASAmYh7l0RxZncPxfhadZkBmH5jvKLhamMcItBYXgoC4B4CBgF' + 
	'oskEP4hkgdgegcD4zlycA1goAJ5mIc4KjgfJ+D0ToTFGbx4h8Qh2CqDJjEeJg0gyT4DkCYg5kyAhCDeBxjkIQgDHSIgTkIP4NGGFplgGEZkkifhFgSIRHgCXwtAYeQ2B' + 
	'+DYlGkZgqgsIpnEoJxzmWGRiFqGJhmkBhDAwJBZDIYoZCYSQ+BOFAmBkJZBhKZpJlYHIXCYR4lFuHpnkmdh+h+aAKAaAogF6FhWgOIZogoJh/GuHoTl6DojmkChGhKJJ' + 
	'pEoVoWiUHAGDCTg6CmSheh6J5qAoTJriiWQUCSb4ploEwpgq4BKjWBomhmc4pAkOpRAQJQBICA==');
		Add(1,'CP:2 -10 -6 8 8');
	end;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarTotal,$1000000);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	EndUpdate();
end
137
Is it possible to highlight the column's header once a filter is applied

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(2,'gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ' + 
	'0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YN' + 
	'YuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4h' + 
	'hKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgb' + 
	'hOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWB' + 
	'MJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=');
		Add(1,'CP:2 -8 -4 2 4');
	end;
	HeaderHeight := 28;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$1fefefe);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarActive,$1010101);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
136
How can I change the format the column displays (for instance, displaying no 0:00:00)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatContents.Add('notime','value replace `0:00:00` with ``',Nil);
	PivotRows := '9[content=notime]';
	EndUpdate();
end
135
Is it possible to show the filterbar on top of the rows

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarTop) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
134
How can I uses the control in window-less mode (with no user interface, option 3)

with AxPivot1 do
begin
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot')) as EXPIVOTLib.Pivot) do
	begin
		Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
		PivotRows := '0';
		PivotColumns := 'avg(5)';
		OutputDebugString( Export(Nil,Nil) );
	end;
end
133
How can I uses the control in window-less mode (with no user interface, option 2)

with AxPivot1 do
begin
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot')) as EXPIVOTLib.Pivot) do
	begin
		rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
		with rs do
		begin
			Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Nil);
		end;
		DataSource := (rs as ADODB.Recordset);
		PivotRows := '0';
		PivotColumns := 'max(5)';
		OutputDebugString( Export(Nil,Nil) );
	end;
end
132
How can I uses the control in window-less mode (with no user interface, option 1)

with AxPivot1 do
begin
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Pivot')) as EXPIVOTLib.Pivot) do
	begin
		LoadXML('http://www.exontrol.net/testing.xml');
		PivotRows := '1';
		PivotColumns := 'max(6)';
		OutputDebugString( Export(Nil,Nil) );
	end;
end
131
How can I connect to a DBF file

with AxPivot1 do
begin
	BeginUpdate();
	rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADODB.Recordset')) as ADODB.Recordset);
	with rs do
	begin
		Open('Select * From foxcode.DBF','Provider=vfpoledb;Data Source=C:\Program Files\Microsoft Visual FoxPro 9\',3,3,Nil);
	end;
	DataSource := (rs as ADODB.Recordset);
	PivotRows := '0';
	PivotColumns := 'count(0)[content=numeric],avg(7)[negative,content=numeric]';
	EndUpdate();
end
130
Export Data in HTML format

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	with FormatConditionalAppearances do
	begin
		Add('G1000','> 1000','value > 1000').ForeColor := $ff0000;
		Add('L1000','< 1000','value < 1000').ForeColor := $ff;
		Add('Zero','zero','value = 0').BackColor := $e0e0e0;
	end;
	with FormatAppearances do
	begin
		Add('grayed',Nil).ForeColor := $808080;
		Add('red',Nil).ForeColor := $ff;
		Add('green',Nil).ForeColor := $ff00;
		Add('blue',Nil).ForeColor := $ff0000;
		Add('bgrayed',Nil).BackColor := $808080;
		Add('bred',Nil).BackColor := $ff;
		Add('bgreen',Nil).BackColor := $ff00;
		Add('bblue',Nil).BackColor := $ff0000;
	end;
	PivotRows := '0[bold],2[grayed]';
	PivotColumns := 'sum(5)[L1000],sum(5)[G1000]/12:A';
	PivotTotals := 'sum[bold,content=currency,bgrayed]';
	AutoDrag := EXPIVOTLib.AutoDragEnum.exAutoDragScroll;
	BackColorAlternate := Color.FromArgb(240,240,240);
	FilterBarPromptType := EXPIVOTLib.FilterPromptEnum.exFilterPromptContainsAny;
	FilterBarPromptPattern := 'France Germany';
	EndUpdate();
	OutputDebugString( Export('htm',Nil) );
end
129
Export Data in HTML format (IE)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	with FormatConditionalAppearances do
	begin
		Add('G1000','> 1000','value > 1000').ForeColor := $ff0000;
		Add('L1000','< 1000','value < 1000').ForeColor := $ff;
		Add('Zero','zero','value = 0').BackColor := $e0e0e0;
	end;
	with FormatAppearances do
	begin
		Add('grayed',Nil).ForeColor := $808080;
		Add('red',Nil).ForeColor := $ff;
		Add('green',Nil).ForeColor := $ff00;
		Add('blue',Nil).ForeColor := $ff0000;
		Add('bgrayed',Nil).BackColor := $808080;
		Add('bred',Nil).BackColor := $ff;
		Add('bgreen',Nil).BackColor := $ff00;
		Add('bblue',Nil).BackColor := $ff0000;
	end;
	ShowBranchRows := Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchIncludeAggregate) Or Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchTree);
	PivotRows := '0[bold],2[grayed]';
	PivotColumns := 'sum(5)[L1000],sum(5)[G1000]/12:A';
	PivotTotals := '/sum[bold,content=currency,bgrayed]';
	AutoDrag := EXPIVOTLib.AutoDragEnum.exAutoDragScroll;
	BackColorAlternate := Color.FromArgb(240,240,240);
	FilterBarPromptType := EXPIVOTLib.FilterPromptEnum.exFilterPromptContainsAny;
	FilterBarPromptPattern := 'France Germany';
	EndUpdate();
	sFile := 'c:/temp/export.htm';
	Export(TObject(sFile),'vis');
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('InternetExplorer.Application')) as SHDocVw.ShellBrowserWindow) do
	begin
	end;
end
128
Export Data in CSV format

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5),sum(5)/12:A';
	PivotTotals := 'sum[bold,content=currency]';
	AutoDrag := EXPIVOTLib.AutoDragEnum.exAutoDragScroll;
	BackColorAlternate := Color.FromArgb(240,240,240);
	EndUpdate();
	OutputDebugString( Export(Nil,Nil) );
end
127
Is it possible to change the visual appearance of the update / reload button being displayed in the control's pivot bar

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABMsGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwCgkBYJDSMAiiaLETwHFKVRwkWBBWjMAAxDZFcggA7' + 
	'7fwxHaOAghGgobjaPY+UbGERAAKQahLJamablCSqLjCS4kSLHEbQHTcRSzLKQZBBCCSQKkYx0HScRiwPBIbQkIQmbajOaYDCiQ53QLCAYRXS9PwvI7AMBwLA8EwXBo9D' + 
	'ZiIy4WyuGj3R4WchAbIwIxUK6XHhmLjZXg+Bz9T6LQZ0JStEx2SYjAJqOiKU62W9xbAUOxQTpIBJXW7Oc7GTa8dQfPoJaIDLicHgoZ6NLIcOR0abSO42CRrdByfRYMwv' + 
	'isCQKnYOh9i4LwbBINpBHeBxeC6X4TAIEpzkIWgei8L4Qk2boEhWPg9C4SJijIOZ7mEXA/iAX5yBKDx/lmVhEC0Z5ZlKHgGAAYIHkGcQxiCQ5eA4PghAKNgSG0VYXEiJ' + 
	'YFl+QAtiCBpdjcDJkB0IgAiYIgBmIQAWCYCoigYZB4DQYpAjoLh3h6SJFgcOpXlAAQBICA==');
	end;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarReload,$1000000);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatConditionalAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
	EndUpdate();
end
126
Is it possible to change the visual appearance of the plus/add new button being displayed in the control's pivot bar

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQSB' + 
	'cQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+OpfD' + 
	'xXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4l' + 
	'lWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5JlgX' + 
	'IcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIRg' + 
	'wZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOMI' + 
	'NCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=');
	end;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exPivotBarAddNew,$1000000);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	EndUpdate();
end
125
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop

with AxPivot1 do
begin
	BeginUpdate();
	HeaderAppearance := EXPIVOTLib.AppearanceEnum.Etched;
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzVI' + 
	'UcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4a' + 
	'DhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DBe' + 
	'EMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDIB' + 
	'ICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAokG' + 
	'KHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=');
		Add(2,'CP:1 0 -36 0 0');
	end;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exColumnsPositionSign,$2000000);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	EndUpdate();
end
124
FilterBarCaption ALL Keyword ( sample 2, result ) 

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
123
FilterBarCaption ALL Keyword ( sample 1 ) 

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := 'all';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
122
FilterBarCaption ALLUI Keyword ( sample 2, result ) 

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `' + 
	'[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( match' + 
	'itemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcoun' + 
	't + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
121
FilterBarCaption ALLUI Keyword ( sample 1 ) 

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := 'allui';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
120
FilterBarCaption AVAILABLE Keyword ( sample 2, result ) 

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( avai' + 
	'lable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with ``' + 
	' replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount ' + 
	'+ 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
119
FilterBarCaption AVAILABLE Keyword ( sample 1 ) 

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080> ` + value + ` </fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := 'value + ` ` + available';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
118
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results )

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := '(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ' + 
	'` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace' + 
	' `]` with ` </b></bgcolor></fgcolor>`';
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle;
	EndUpdate();
end
117
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 )

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := 'value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`';
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle;
	EndUpdate();
end
116
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 )

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,FormatABC('`<fgcolor=808080>` + value + `</fgcolor>`',TObject(get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd)),Nil,Nil));
	FilterBarCaption := 'value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`';
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle;
	EndUpdate();
end
115
Is it possible to automatically displays the control's filter label to the right

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarCaption := '`<r>` + value';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle);
	EndUpdate();
end
114
How can I get the number of results/items being shown in the control's filter bar (sample 4)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	FilterBarPrompt := FormatABC('`<b>` + value',TObject(FilterBarPrompt),Nil,Nil);
	FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount +' + 
	' 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
113
How can I get the number of results being shown in the control's filter bar (sample 3)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount +' + 
	' 1) + ` result(s)` ) : ``)';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
112
How can I get the number of results being shown in the control's filter bar (sample 2, compact)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	FilterBarCaption := '`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
111
How can I get the number of results being shown in the control's filter bar (sample 1)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	FilterBarCaption := '`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
110
FilterBarCaption Predefined Keywords

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	LinesAtRoot := EXPIVOTLib.LinesAtRootEnum.exLinesAtRoot;
	FilterInclude := EXPIVOTLib.FilterIncludeEnum.exItemsWithChilds;
	FilterBarFont := (Font as stdole.StdFont);
	FilterBarCaption := '`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</i' + 
	'></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>:' + 
	' ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><' + 
	'i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</i' + 
	'></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=80' + 
	'8080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount + ' + 
	'`</fgcolor>`';
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCaptionVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
109
I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarFont := (Font as stdole.StdFont);
	FilterBarCaption := '`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value';
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
108
Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 )

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	FilterBarPrompt := FormatABC('`<r>` + value',TObject(FilterBarPrompt),Nil,Nil);
	EndUpdate();
end
107
How can I change the visual appearance of the filter bar's close button (EBN)

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJj' + 
	'yI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKmS' + 
	'ZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8ORO' + 
	'icbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2D' + 
	'YxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJXA' + 
	'iAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaKJ' + 
	'DCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G0' + 
	'TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEAk' + 
	'jIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRSM' + 
	'RsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhAQ' + 
	'HkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ');
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$1000000);
	EndUpdate();
end
106
How can I change the visual appearance of the filter bar's close button (solid)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$ff);
	EndUpdate();
end
105
Is it possible to prevent definitely showing the filter bar's close button

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exFooterFilterBarButton,$ffffffff);
	EndUpdate();
end
104
Is it possible to show the close button only if there is a filter applied

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
103
The control's filter bar is not closed once I click the close button (toggle)
with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarCaption := '`<r><fgcolor=808080>` + value';
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarToggle) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
102
How can I display the control's filter on a single line

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarCaption := 'len(value) ? `filter for: <fgcolor 808080>` + value  : `<fgcolor 808080>no filter`';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible);
	EndUpdate();
end
101
How can I display the control's filter on a single line (prompt-combined)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarCaption := '`<r>` + value';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarCompact) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarSingleLine) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
100
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the control.
procedure TWinForm1.AxPivot1_ClickEvent(sender: System.Object; e: System.EventArgs);
begin
	with AxPivot1 do
	begin
		ClearFilter();
	end
end;

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
	FilterBarPromptPattern := 'USA';
	EndUpdate();
end
99
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptPattern := 'USA';
	FilterBarPromptVisible := Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible) Or Integer(EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible);
	EndUpdate();
end
98
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
	FilterBarPromptPattern := 'USA';
	EndUpdate();
end
97
Is it possible to prevent closing the control's filter bar, so it is always shown

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FilterBarCaption := 'len(value) = 0 ? `<fgcolor=808080>no filter` : value';
	FilterBarPromptVisible := EXPIVOTLib.FilterBarVisibleEnum.exFilterBarVisible;
	EndUpdate();
end
96
How can I find if the control is running in DPI mode
with AxPivot1 do
begin
	OutputDebugString( FormatABC('dpi = 1 ? `normal/stretch mode` : `dpi mode`',Nil,Nil,Nil) );
end
95
If I connect it to a datasource, all works perfectly but the records that I see in the control is a little number of total of the recordset. I need to show all 60.000 rows of the recordset without click on the [...] button. It’s possible to setting up this parameters
with AxPivot1 do
begin
	DisplayPivotData := -1;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
end
94
How do I change the drop down filter icon/button (white)

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(2,'gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ' + 
	'0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YN' + 
	'YuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4h' + 
	'hKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgb' + 
	'hOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWB' + 
	'MJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=');
		Add(1,'CP:2 -6 -4 2 4');
	end;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$1000000);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,BackColor);
	HeaderVisible := True;
	HeaderHeight := 24;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exShowCheckBox) Or Integer(EXPIVOTLib.FilterListEnum.exSortItemsAsc);
	PivotBarVisible := EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible;
	EndUpdate();
end
93
How do I change the drop down filter icon/button (black)

with AxPivot1 do
begin
	BeginUpdate();
	with VisualAppearance do
	begin
		Add(1,'gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQg' + 
	'mPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThd' + 
	'r4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA');
	end;
	set_Background(EXPIVOTLib.BackgroundPartEnum.exHeaderFilterBarButton,$1000000);
	set_Background(EXPIVOTLib.BackgroundPartEnum.exCursorHoverColumn,$ffffffff);
	BackColorHeader := Color.FromArgb(0,0,0);
	ForeColorHeader := Color.FromArgb(255,255,255);
	HeaderVisible := True;
	HeaderHeight := 22;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DisplayFilterList := Integer(EXPIVOTLib.FilterListEnum.exShowCheckBox) Or Integer(EXPIVOTLib.FilterListEnum.exSortItemsAsc);
	EndUpdate();
end
92
How do I prevent showing the control's BackColorAlternate property on empty / non-items part of the control

with AxPivot1 do
begin
	BeginUpdate();
	(GetOcx() as EXPIVOTLib.Pivot).BackColorAlternate := $7ff0f0f0;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '12';
	PivotColumns := 'sum(5)';
	EndUpdate();
end
91
How can I find out if the user clicks the grid's header
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
	with AxPivot1 do
	begin
		OutputDebugString( 'Type of ColumnFromPoint: ' );
		OutputDebugString( get_ColumnFromPoint(-1,-1) );
		OutputDebugString( ' should not be VT_NULL' );
		OutputDebugString( 'Type of ValueFromPoint: ' );
		OutputDebugString( get_ValueFromPoint(-1,-1) );
		OutputDebugString( ' should be VT_NULL' );
	end
end;

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)';
end
90
What should I set FormatPivotHeader to, to show it on the columns header only

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	FormatPivotHeader := '(iaggregate ? ( caption + ` <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + ( ( display=1 ? `<c>Date: <' + 
	'b><upline><dotline>` + date(`now`) : `` ) + `</dotline> </b>` )';
	EndUpdate();
end
89
What should I set FormatPivotHeader to, to show "Report Generated on 7/9/2016 14:20" etc when the report is executed (ie the date and time will change)

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '')</off></font>'') : caption) + `<r>ReportDate: ' + 
	'` + date(`now`)';
	EndUpdate();
end
88
Is it possible to display aggregate result on parent rows as well

with AxPivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '12[bold],0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/6';
	IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
	DrawGridLines := EXPIVOTLib.GridLinesEnum.exNoLines;
	ShowBranchRows := Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchIncludeAggregate) Or Integer(EXPIVOTLib.ShowBranchRowsEnum.exBranchTree);
	EndUpdate();
end
87
How do I show expanded/collapsed rows

with AxPivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '12[bold],0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/6';
	IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
	DrawGridLines := EXPIVOTLib.GridLinesEnum.exNoLines;
	EndUpdate();
end
86
How do I show expanded/collapsed columns

with AxPivot1 do
begin
	BeginUpdate();
	HeaderHeight := 22;
	DefaultItemHeight := 20;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	FormatPivotHeader := '(iaggregate ? ( caption + ` <r>[` + lower(caggregate) + `]` ) : caption)';
	IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
	EndUpdate();
end
85
Where you have say "Sum of ...." as the first row heading of the pivot are there and options to be able to change this text as a whole

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	FormatPivotHeader := '(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + '' )'') : caption)';
	EndUpdate();
end
84
How can I get the data column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
	with AxPivot1 do
	begin
		OutputDebugString( 'DataColumn' );
		OutputDebugString( get_DataColumnFromPoint(-1,-1) );
	end
end;

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
83
Is there any way for the user to change the alignment at runtime (using excontextmenu)

// RClick event - Occurs once the user right clicks the control.
procedure TWinForm1.AxPivot1_RClick(sender: System.Object; e: System.EventArgs);
begin
	// FlatImageWidth = 0
	// ToString = "Alignment[align=1][dis],[group=0x71](Left[typ=2][grp=100][close=0][id=0],Center[typ=2][grp=100][close=0][id=1],Right[typ=2][grp=100][close=0][id=2])"
	// item(h).Checked = True
	// h = Select()
	with AxPivot1 do
	begin
		h := DataColumns.Item[TObject(5)].Alignment;
		with c do
		begin
		end;
		with DataColumns.Item[TObject(5)] do
		begin
			Alignment := h;
			HeaderAlignment := h;
		end;
		Refresh();
	end
end;

with AxPivot1 do
begin
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with DataColumns.Item[TObject(5)] do
	begin
		Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
		HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
82
Is there any way for the user to change the alignment at runtime

// RClick event - Occurs once the user right clicks the control.
procedure TWinForm1.AxPivot1_RClick(sender: System.Object; e: System.EventArgs);
begin
	with AxPivot1 do
	begin
		OutputDebugString( 'The column gets aligned to the center' );
		with DataColumns.Item[TObject(5)] do
		begin
			Alignment := EXPIVOTLib.AlignmentEnum.CenterAlignment;
			HeaderAlignment := EXPIVOTLib.AlignmentEnum.CenterAlignment;
		end;
		Refresh();
	end
end;

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with DataColumns.Item[TObject(5)] do
	begin
		Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
		HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
81
How can I align a column to the right

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with DataColumns.Item[TObject(5)] do
	begin
		Alignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
		HeaderAlignment := EXPIVOTLib.AlignmentEnum.RightAlignment;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	Refresh();
end
80
How can I display the control's content on an single A3 paper size, when using PDF format
with AxPivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := get_CopyTo('C:\Temp\Preview.pdf|11.69 in x 16.53 in||single');
	OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
	EndUpdate();
end
79
How can I display the control's content on an A3 paper size, when using PDF format
with AxPivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := get_CopyTo('C:\Temp\Preview.pdf|11.69 in x 16.53 in');
	OutputDebugString( 'Look for C:\Temp\Preview.pd file.' );
	EndUpdate();
end
78
How can I export the control's content to a PDF document (method 1)
with AxPivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	EndUpdate();
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
	begin
		PrintExt := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot).DefaultDispatch;
		CopyTo('c:/temp/xtest.pdf');
	end;
	OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
	EndUpdate();
end
77
How can I export the control's content to a PDF document (method 2)
with AxPivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	ExpandAll();
	var_CopyTo := get_CopyTo('c:/temp/xtest.pdf');
	OutputDebugString( 'Look for C:\Temp\xtest.pdf file.' );
	EndUpdate();
end
76
Does / could the control have a read-only mode by where I could load the data and layout and just use the control to display it and allow the user to scroll around it / print it but not change it 
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	DisplayFilterList := EXPIVOTLib.FilterListEnum.exNoItems;
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarReadOnly) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
	Refresh();
end
75
Is it possible to edit the conditional-expression at runtime

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with FormatConditionalAppearances.Add('custom','custom','') do
	begin
		Bold := True;
		FontSize := 12;
		Expression := 'value > 2000';
		ContextEditExpression := True;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[custom]/12';
	EndUpdate();
end
74
How can I highlight values using EBN colors

with AxPivot1 do
begin
	BeginUpdate();
	VisualAppearance.Add(1,'c:\exontrol\images\normal.ebn');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	FormatConditionalAppearances.Item['positive'].BackColor := $100ff00;
	FormatConditionalAppearances.Item['negative'].BackColor := $10000ff;
	PivotRows := '0';
	PivotColumns := 'sum(5)[positive,negative]/12';
	EndUpdate();
end
73
How do I mark not-empty values in the chart

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	with FormatConditionalAppearances.Add('nempty','not empty','') do
	begin
		Expression := 'len(value) != 0';
		BackColor := $f0f0f0;
	end;
	PivotColumns := 'sum(5)[nempty]/12';
	EndUpdate();
end
72
How can I highlight negative and positive values in the same chart

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,positive]/12';
	EndUpdate();
end
71
How can I highlight values that starts with a letter

with AxPivot1 do
begin
	BeginUpdate();
	with FormatConditionalAppearances.Add('f','starts with f','lower(value) startwith `f`') do
	begin
		Expression := 'lower(value) startwith `f`';
		Shadow := $1;
		ShadowOffset := 0;
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0[f]';
	EndUpdate();
end
70
How can I mark values greater than a value, 100 for instance

with AxPivot1 do
begin
	BeginUpdate();
	with FormatConditionalAppearances.Add('greater100','>100','value > 100') do
	begin
		Expression := '( dbl(value) != 0 ) ? (value > 100) : 0';
		ForeColor := $ff;
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[greater100,content=numeric]';
	EndUpdate();
end
69
How can I remove the Conditional context-menu

with AxPivot1 do
begin
	BeginUpdate();
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatContent) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowFormatAppearance) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric]';
	EndUpdate();
end
68
How do change the way the negative/positive numbers show when using conditional-format

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with FormatConditionalAppearances.Item['negative'] do
	begin
		BackColor := $0;
		ForeColor := $808080;
		FontSize := 8;
	end;
	with FormatConditionalAppearances.Item['positive'] do
	begin
		BackColor := $0;
		ForeColor := $1;
		FontSize := 11;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,positive,content=numeric]';
	EndUpdate();
end
67
How do I highlight the negative values with white color or black

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with FormatConditionalAppearances.Item['negative'] do
	begin
		BackColor := $1;
		ForeColor := $ffffff;
	end;
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,content=numeric]';
	EndUpdate();
end
66
Does your control support conditional-format, so I can highlight certain values

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[negative,content=numeric]';
	EndUpdate();
end
65
How do I add a computed column/field, like VAT for instance (method 2)

with AxPivot1 do
begin
	BeginUpdate();
	with Aggregates do
	begin
		Add('vat19','sum','VAT 19%','VAT 19%').FormatValue := 'value * 0.19';
		Add('vat24','sum','VAT 24%','VAT 24%').FormatValue := 'value * 0.24';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric],vat19(5)[bold,content=numeric],vat24(5)[bold,content=numeric]';
	EndUpdate();
end
64
How do I add a computed column/field, like VAT for instance (method 1)

with AxPivot1 do
begin
	BeginUpdate();
	with FormatContents.Add('vat19','VAT 19%',Nil) do
	begin
		Expression := 'len(value) ? ((value * 1.19) format '''') : ''''';
	end;
	with FormatContents.Add('vat24','VAT 24%',Nil) do
	begin
		Expression := 'len(value) ? ((value * 1.24) format '''') : ''''';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[content=numeric],sum(5)[bold,content=vat19],sum(5)[bold,content=vat24]';
	EndUpdate();
end
63
How can I hide some values for instance negative values

with AxPivot1 do
begin
	BeginUpdate();
	with FormatContents.Add('hiden','hide negative',Nil) do
	begin
		Expression := 'value < 0 ? `` : value';
	end;
	with FormatContents.Add('hidep','hide positive',Nil) do
	begin
		Expression := 'value > 0 ? `` : value';
	end;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)[bold],sum(5)[content=hiden],sum(5)[content=hidep]';
	EndUpdate();
end
62
How can I decode the Layout property

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	Layout := 'Columns =1;C0.Width = 64';
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
	begin
		OutputDebugString( Decode64TextW[AxPivot1.Layout] );
	end;
	EndUpdate();
end
61
How can I specify the sorting type, so the column gets sorted as numeric for instance

with AxPivot1 do
begin
	Import('1,1#11,11#101,101','eor=''#'' eof='','' hdr=0');
	with DataColumns.Item[TObject(0)] do
	begin
		Caption := 'Numeric';
		SortType := EXPIVOTLib.SortTypeEnum.SortNumeric;
	end;
	DataColumns.Item[TObject(1)].Caption := 'String (default)';
	PivotRows := '0';
	Refresh();
end
60
How can I disable the control's context menu
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotBarVisible := Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowResizeColumns) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowUndoRedo) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoUpdate) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAllowValues) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarShowTotals) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarAutoFit) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarSizable) Or Integer(EXPIVOTLib.PivotBarVisibleEnum.exPivotBarVisible);
end
59
How do I get the captions of the columns
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	OutputDebugString( DataColumns.Count );
	OutputDebugString( DataColumns.Item[TObject(0)].PivotCaption );
	OutputDebugString( DataColumns.Item[TObject(0)].Caption );
	OutputDebugString( DataColumns.Item[TObject(1)].PivotCaption );
	OutputDebugString( DataColumns.Item[TObject(1)].Caption );
end
58
How can I specify the default-format for a specified column, so it always shows as numeric for instance
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	with DataColumns.Item['Freight'] do
	begin
		DefaultFormatContent := 'numeric';
		DefaultFormatAppearances := 'bold';
		SortOrder := EXPIVOTLib.SortOrderEnum.SortAscending;
		SortType := EXPIVOTLib.SortTypeEnum.SortNumeric;
	end;
	PivotTotalDefaultFormatContent := 'currency';
	PivotTotalDefaultFormatAppearances := 'strikeout,bold';
	PivotRows := '0';
	PivotColumns := 'sum(5)[bold,content=numeric]';
	PivotTotals := 'sum[strikeout,bold,content=currency]';
	PivotColumnsFloatBarVisible := True;
	Refresh();
end
57
How can I display the percentage column

with AxPivot1 do
begin
	FormatContents.Add('percent','value + `%`',Nil);
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '5[content=percent]';
	Refresh();
end
56
How do I change the name for months in the drop-down filter window (localization)

with AxPivot1 do
begin
	OutputDebugString( get_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateMonths) );
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateMonths,'Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAll,'(Toate)');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarBlanks,'(Gol)');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarNonBlanks,'(Plin)');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarFilterForCaption,'Filtreaza:');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateTodayCaption,'Azi');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateWeekDays,'D L Ma Mi J V S');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarExclude,'Exclud');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exColumnsFloatBar,'Coloane');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarAnd,'si');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDate,'Data:');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateTitle,'Data');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarDateTo,'la');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarNot,'nu');
	set_Description(EXPIVOTLib.DescriptionTypeEnum.exFilterBarOr,'sau');
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	DataColumns.Item['OrderDate'].SortType := EXPIVOTLib.SortTypeEnum.SortDate;
	PivotRows := '9';
	Refresh();
end
55
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageHeight but infinite width etc
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '6';
	PivotColumns := 'sum(5)/3';
	Refresh();
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
	begin
		Options := 'FitToPage = x 5';
		PrintExts := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot);
		Preview();
	end;
end
54
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageWidth but infinite height etc
with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '6';
	PivotColumns := 'sum(5)/3';
	Refresh();
	with (ComObj.CreateComObject(ComObj.ProgIDToClassID('Exontrol.Print')) as EXPRINTLib.Print) do
	begin
		Options := 'FitToPage = 5 x';
		PrintExts := (AxPivot1.GetOcx() as EXPIVOTLib.Pivot);
		Preview();
	end;
end
53
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
	with AxPivot1 do
	begin
		OutputDebugString( get_ColumnFromPoint(-1,-1) );
	end
end;

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	Refresh();
end
52
How can I get the value from the cursor
// MouseMove event - Occurs when the user moves the mouse.
procedure TWinForm1.AxPivot1_MouseMoveEvent(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_MouseMoveEvent);
begin
	with AxPivot1 do
	begin
		OutputDebugString( get_ValueFromPoint(-1,-1) );
	end
end;

with AxPivot1 do
begin
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	Refresh();
end
51
How can I specify a column to display HTML format

with AxPivot1 do
begin
	Import('Bold <b>1,Bold <b>2#Bold <b>3,Bold <b>4#Bold <b>5,Bold <b>6','eor=''#'' eof='','' hdr=0');
	DataColumns.Item[TObject(0)].HTML := True;
	DataColumns.Item[TObject(1)].HTML := True;
	PivotRows := '0';
	Refresh();
end
50
Does your control supports scrolling by touching the screen

with AxPivot1 do
begin
	rs := (ComObj.CreateComObject(ComObj.ProgIDToClassID('ADOR.Recordset')) as ADODB.Recordset);
	with rs do
	begin
		Open('Data','Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExPivot\Sample\Access\sample.accdb',3,3,Nil);
	end;
	DataSource := (rs as ADODB.Recordset);
	AutoDrag := Integer(EXPIVOTLib.AutoDragEnum.exAutoDragScrollOnShortTouch) Or Integer(EXPIVOTLib.AutoDragEnum.exAutoDragScroll);
end
49
How can I specify programatically the width of the pivot column ( first column )

with AxPivot1 do
begin
	BeginUpdate();
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	Layout := 'Columns =1;C0.Width = 64';
	EndUpdate();
end
48
How can I show the total of each row, when columns are shown as expanded

with AxPivot1 do
begin
	BeginUpdate();
	IncludeExpandColumn := EXPIVOTLib.IncludeExpandColumnEnum.exIncludeExpandColumn;
	Import('C:\Program Files\Exontrol\ExPivot\Sample\data.txt',Nil);
	PivotRows := '0';
	PivotColumns := 'sum(5)/12';
	EndUpdate();
end