[]
デモ ヘルプ APIリファレンス
トライアル版
(Showing Draft Content)

OverflowPlaceHolder

OverflowPlaceHolderコントロールは、List、BandedList、TablixやTableデータ領域といった、定義したサイズに収まりきらない（オーバーフローする）データを表示するためのプレースホルダーで、ページレポートでのみ利用可能です。OverflowPlaceHolderコントロール自体のSizeプロパティはリンク先のデータ領域のFixedSizeプロパティから取得されます。

また、データ領域をOverflowPlaceHolderコントロールにリンクし、そのOverflowPlaceHolderコントロールを他のOverflowPlaceHolderコントロールにリンクすることもできます。次のようなレイアウトを作成することができます。

  • 複数ページのレイアウト： レポートの最初のページでデータ領域、次のページにオーバーフローデータを表示するOverflowPlaceHolderを配置し、複数ページのレイアウトを作成します。

  • 単一ページのレイアウト： データ領域とOverflowPlaceHolderをレポートの同じページに配置し、単一ページのレイアウトを作成します。


OverflowPlaceHolderで使用することができる主なプロパティを説明します。

共通

  • 名前： まだレポートに使用されていない一意の名前を入力します。

  • オーバーフローデータ連結先: データがオーバーフローした際、続きのデータを表示する別のOverflowPlaceHolderコントロールをドロップダウンリストから選択します。

使用例

次の例では、カラム形式のレポートレイアウトで店舗別の売上金額を一覧表示するレポートを作成する方法を示します。Tableデータ領域およびOverflowPlaceHolderコントロールを同じページに配置して、レポートデータを2つの列に表示します。

**メモ：**この例ではレポートファイルに、以下のようなデータを埋め込み、使用します。

データソース ```javascript [{"SalesID":"1000","Customer":"1199","Store":"1002","Employee":"1060","SaleDate":"2004/1/1","TaxPercent":"6.5","SalesAmount":"172.1703","TotalAmount":"183.3614"},{"SalesID":"1001","Customer":"1198","Store":"1005","Employee":"1113","SaleDate":"2004/1/2","TaxPercent":"14","SalesAmount":"127.35","TotalAmount":"145.179"},{"SalesID":"1002","Customer":"1908","Store":"1006","Employee":"1128","SaleDate":"2004/1/3","TaxPercent":"0","SalesAmount":"133.23","TotalAmount":"133.23"},{"SalesID":"1003","Customer":"1669","Store":"1005","Employee":"1113","SaleDate":"2004/1/4","TaxPercent":"14","SalesAmount":"14.49","TotalAmount":"16.5186"},{"SalesID":"1004","Customer":"1507","Store":"1006","Employee":"1128","SaleDate":"2004/1/6","TaxPercent":"0","SalesAmount":"114.5004","TotalAmount":"114.5004"},{"SalesID":"1005","Customer":"1404","Store":"1003","Employee":"1083","SaleDate":"2004/1/7","TaxPercent":"14","SalesAmount":"228.52","TotalAmount":"260.5128"},{"SalesID":"1006","Customer":"1874","Store":"1005","Employee":"1113","SaleDate":"2004/1/8","TaxPercent":"14","SalesAmount":"211.7495","TotalAmount":"241.3944"},{"SalesID":"1007","Customer":"1460","Store":"1002","Employee":"1068","SaleDate":"2004/1/9","TaxPercent":"6.5","SalesAmount":"113.8275","TotalAmount":"121.2263"},{"SalesID":"1008","Customer":"1487","Store":"1003","Employee":"1083","SaleDate":"2004/1/10","TaxPercent":"14","SalesAmount":"44.9","TotalAmount":"51.186"},{"SalesID":"1009","Customer":"1549","Store":"1006","Employee":"1128","SaleDate":"2004/1/11","TaxPercent":"0","SalesAmount":"82.84","TotalAmount":"82.84"},{"SalesID":"1010","Customer":"1060","Store":"1003","Employee":"1083","SaleDate":"2004/1/12","TaxPercent":"14","SalesAmount":"39.48","TotalAmount":"45.0072"},{"SalesID":"1011","Customer":"1157","Store":"1003","Employee":"1083","SaleDate":"2004/1/13","TaxPercent":"14","SalesAmount":"142.88","TotalAmount":"162.8832"},{"SalesID":"1012","Customer":"1218","Store":"1003","Employee":"1083","SaleDate":"2004/1/14","TaxPercent":"14","SalesAmount":"54.35","TotalAmount":"61.959"},{"SalesID":"1013","Customer":"1839","Store":"1000","Employee":"1038","SaleDate":"2004/1/15","TaxPercent":"0","SalesAmount":"157.27","TotalAmount":"157.27"},{"SalesID":"1014","Customer":"1407","Store":"1006","Employee":"1128","SaleDate":"2004/1/16","TaxPercent":"0","SalesAmount":"100.9402","TotalAmount":"100.9402"},{"SalesID":"1015","Customer":"1838","Store":"1003","Employee":"1083","SaleDate":"2004/1/17","TaxPercent":"14","SalesAmount":"199.3055","TotalAmount":"227.2083"},{"SalesID":"1016","Customer":"1615","Store":"1004","Employee":"1098","SaleDate":"2004/1/18","TaxPercent":"14","SalesAmount":"32.94","TotalAmount":"37.5516"},{"SalesID":"1017","Customer":"1389","Store":"1004","Employee":"1098","SaleDate":"2004/1/19","TaxPercent":"14","SalesAmount":"234.72","TotalAmount":"267.5808"},{"SalesID":"1018","Customer":"1450","Store":"1003","Employee":"1083","SaleDate":"2004/1/20","TaxPercent":"14","SalesAmount":"184.71","TotalAmount":"210.5694"},{"SalesID":"1019","Customer":"1982","Store":"1003","Employee":"1083","SaleDate":"2004/1/20","TaxPercent":"14","SalesAmount":"54.47","TotalAmount":"62.0958"},{"SalesID":"1020","Customer":"1436","Store":"1006","Employee":"1128","SaleDate":"2004/1/21","TaxPercent":"0","SalesAmount":"61.35","TotalAmount":"61.35"},{"SalesID":"1021","Customer":"1388","Store":"1004","Employee":"1098","SaleDate":"2004/1/22","TaxPercent":"14","SalesAmount":"193.24","TotalAmount":"220.2936"},{"SalesID":"1022","Customer":"1724","Store":"1002","Employee":"1068","SaleDate":"2004/1/23","TaxPercent":"6.5","SalesAmount":"95.84","TotalAmount":"102.0696"},{"SalesID":"1023","Customer":"1767","Store":"1001","Employee":"1053","SaleDate":"2004/1/23","TaxPercent":"14","SalesAmount":"121.2311","TotalAmount":"138.2035"},{"SalesID":"1024","Customer":"1279","Store":"1001","Employee":"1053","SaleDate":"2004/1/23","TaxPercent":"14","SalesAmount":"34.9","TotalAmount":"39.786"},{"SalesID":"1025","Customer":"1494","Store":"1006","Employee":"1128","SaleDate":"2004/1/24","TaxPercent":"0","SalesAmount":"20.49","TotalAmount":"20.49"},{"SalesID":"1026","Customer":"1301","Store":"1005","Employee":"1113","SaleDate":"2004/1/28","TaxPercent":"14","SalesAmount":"186.185","TotalAmount":"212.2509"},{"SalesID":"1027","Customer":"1281","Store":"1000","Employee":"1038","SaleDate":"2004/1/28","TaxPercent":"0","SalesAmount":"171.7295","TotalAmount":"171.7295"},{"SalesID":"1028","Customer":"1705","Store":"1002","Employee":"1068","SaleDate":"2004/1/31","TaxPercent":"6.5","SalesAmount":"53.89","TotalAmount":"57.3928"},{"SalesID":"1029","Customer":"1228","Store":"1005","Employee":"1113","SaleDate":"2004/2/1","TaxPercent":"14","SalesAmount":"325.48","TotalAmount":"371.0472"},{"SalesID":"1030","Customer":"1820","Store":"1006","Employee":"1128","SaleDate":"2004/2/2","TaxPercent":"0","SalesAmount":"260.04","TotalAmount":"260.04"},{"SalesID":"1031","Customer":"1363","Store":"1005","Employee":"1113","SaleDate":"2004/2/1","TaxPercent":"14","SalesAmount":"63.97","TotalAmount":"72.9258"},{"SalesID":"1032","Customer":"1006","Store":"1003","Employee":"1083","SaleDate":"2004/2/2","TaxPercent":"14","SalesAmount":"78.75","TotalAmount":"89.775"},{"SalesID":"1033","Customer":"1743","Store":"1000","Employee":"1038","SaleDate":"2004/2/2","TaxPercent":"0","SalesAmount":"41.642","TotalAmount":"41.642"},{"SalesID":"1034","Customer":"1328","Store":"1003","Employee":"1083","SaleDate":"2004/2/3","TaxPercent":"14","SalesAmount":"103.84","TotalAmount":"118.3776"},{"SalesID":"1035","Customer":"1597","Store":"1002","Employee":"1068","SaleDate":"2004/2/5","TaxPercent":"6.5","SalesAmount":"21.45","TotalAmount":"22.8442"},{"SalesID":"1036","Customer":"1135","Store":"1006","Employee":"1128","SaleDate":"2004/2/6","TaxPercent":"0","SalesAmount":"118.39","TotalAmount":"118.39"},{"SalesID":"1037","Customer":"1725","Store":"1006","Employee":"1128","SaleDate":"2004/2/6","TaxPercent":"0","SalesAmount":"166.961","TotalAmount":"166.961"},{"SalesID":"1038","Customer":"1511","Store":"1005","Employee":"1113","SaleDate":"2004/2/6","TaxPercent":"14","SalesAmount":"101.24","TotalAmount":"115.4136"},{"SalesID":"1039","Customer":"1602","Store":"1004","Employee":"1098","SaleDate":"2004/2/8","TaxPercent":"14","SalesAmount":"159.79","TotalAmount":"182.1606"},{"SalesID":"1040","Customer":"1398","Store":"1002","Employee":"1068","SaleDate":"2004/2/8","TaxPercent":"6.5","SalesAmount":"186.63","TotalAmount":"198.761"},{"SalesID":"1041","Customer":"1517","Store":"1005","Employee":"1113","SaleDate":"2004/2/10","TaxPercent":"14","SalesAmount":"63.3312","TotalAmount":"72.1976"},{"SalesID":"1042","Customer":"1392","Store":"1005","Employee":"1113","SaleDate":"2004/2/11","TaxPercent":"14","SalesAmount":"35.44","TotalAmount":"40.4016"},{"SalesID":"1043","Customer":"1832","Store":"1003","Employee":"1083","SaleDate":"2004/2/14","TaxPercent":"14","SalesAmount":"282.7404","TotalAmount":"322.3241"},{"SalesID":"1044","Customer":"1670","Store":"1000","Employee":"1038","SaleDate":"2004/2/15","TaxPercent":"0","SalesAmount":"139.25","TotalAmount":"139.25"},{"SalesID":"1045","Customer":"1251","Store":"1001","Employee":"1053","SaleDate":"2004/2/15","TaxPercent":"14","SalesAmount":"79.41","TotalAmount":"90.5274"},{"SalesID":"1046","Customer":"1934","Store":"1002","Employee":"1068","SaleDate":"2004/2/21","TaxPercent":"6.5","SalesAmount":"100.42","TotalAmount":"106.9473"},{"SalesID":"1047","Customer":"1646","Store":"1004","Employee":"1098","SaleDate":"2004/2/22","TaxPercent":"14","SalesAmount":"182.65","TotalAmount":"208.221"},{"SalesID":"1048","Customer":"1430","Store":"1005","Employee":"1113","SaleDate":"2004/2/22","TaxPercent":"14","SalesAmount":"127.8","TotalAmount":"145.692"},{"SalesID":"1049","Customer":"1133","Store":"1004","Employee":"1098","SaleDate":"2004/2/22","TaxPercent":"14","SalesAmount":"165.83","TotalAmount":"189.0462"},{"SalesID":"1050","Customer":"1008","Store":"1006","Employee":"1128","SaleDate":"2004/2/23","TaxPercent":"0","SalesAmount":"281.59","TotalAmount":"281.59"},{"SalesID":"1051","Customer":"1929","Store":"1006","Employee":"1128","SaleDate":"2004/2/23","TaxPercent":"0","SalesAmount":"62.43","TotalAmount":"62.43"},{"SalesID":"1052","Customer":"1847","Store":"1000","Employee":"1038","SaleDate":"2004/2/25","TaxPercent":"0","SalesAmount":"61.93","TotalAmount":"61.93"},{"SalesID":"1053","Customer":"1505","Store":"1001","Employee":"1053","SaleDate":"2004/2/25","TaxPercent":"14","SalesAmount":"58.43","TotalAmount":"66.6102"},{"SalesID":"1054","Customer":"1727","Store":"1005","Employee":"1113","SaleDate":"2004/2/25","TaxPercent":"14","SalesAmount":"35.2705","TotalAmount":"40.2084"},{"SalesID":"1055","Customer":"1807","Store":"1006","Employee":"1128","SaleDate":"2004/2/25","TaxPercent":"0","SalesAmount":"144.1001","TotalAmount":"144.1001"},{"SalesID":"1056","Customer":"1293","Store":"1001","Employee":"1053","SaleDate":"2004/2/25","TaxPercent":"14","SalesAmount":"238.629","TotalAmount":"272.0371"},{"SalesID":"1057","Customer":"1588","Store":"1000","Employee":"1038","SaleDate":"2004/2/26","TaxPercent":"0","SalesAmount":"217.49","TotalAmount":"217.49"},{"SalesID":"1058","Customer":"1185","Store":"1004","Employee":"1098","SaleDate":"2004/2/28","TaxPercent":"14","SalesAmount":"107.91","TotalAmount":"123.0174"},{"SalesID":"1059","Customer":"1339","Store":"1001","Employee":"1053","SaleDate":"2004/2/28","TaxPercent":"14","SalesAmount":"86.92","TotalAmount":"99.0888"},{"SalesID":"1060","Customer":"1306","Store":"1000","Employee":"1038","SaleDate":"2004/3/1","TaxPercent":"0","SalesAmount":"29.9","TotalAmount":"29.9"},{"SalesID":"1061","Customer":"1920","Store":"1000","Employee":"1038","SaleDate":"2004/3/1","TaxPercent":"0","SalesAmount":"274.09","TotalAmount":"274.09"},{"SalesID":"1062","Customer":"1233","Store":"1002","Employee":"1068","SaleDate":"2004/3/1","TaxPercent":"6.5","SalesAmount":"187.9702","TotalAmount":"200.1883"},{"SalesID":"1063","Customer":"1793","Store":"1003","Employee":"1083","SaleDate":"2004/3/2","TaxPercent":"14","SalesAmount":"271.52","TotalAmount":"309.5328"},{"SalesID":"1064","Customer":"1900","Store":"1004","Employee":"1098","SaleDate":"2004/3/3","TaxPercent":"14","SalesAmount":"200.69","TotalAmount":"228.7866"},{"SalesID":"1065","Customer":"1888","Store":"1003","Employee":"1083","SaleDate":"2004/3/7","TaxPercent":"14","SalesAmount":"158.25","TotalAmount":"180.405"},{"SalesID":"1066","Customer":"1492","Store":"1003","Employee":"1083","SaleDate":"2004/3/7","TaxPercent":"14","SalesAmount":"337.86","TotalAmount":"385.1604"},{"SalesID":"1067","Customer":"1355","Store":"1005","Employee":"1113","SaleDate":"2004/3/8","TaxPercent":"14","SalesAmount":"65.39","TotalAmount":"74.5446"},{"SalesID":"1068","Customer":"1953","Store":"1005","Employee":"1113","SaleDate":"2004/3/10","TaxPercent":"14","SalesAmount":"18.99","TotalAmount":"21.6486"},{"SalesID":"1069","Customer":"1928","Store":"1006","Employee":"1128","SaleDate":"2004/3/11","TaxPercent":"0","SalesAmount":"40.94","TotalAmount":"40.94"},{"SalesID":"1070","Customer":"1841","Store":"1004","Employee":"1098","SaleDate":"2004/3/12","TaxPercent":"14","SalesAmount":"87.79","TotalAmount":"100.0806"},{"SalesID":"1071","Customer":"1006","Store":"1003","Employee":"1083","SaleDate":"2004/3/15","TaxPercent":"14","SalesAmount":"231.3","TotalAmount":"263.682"},{"SalesID":"1072","Customer":"1700","Store":"1006","Employee":"1128","SaleDate":"2004/3/15","TaxPercent":"0","SalesAmount":"189.11","TotalAmount":"189.11"},{"SalesID":"1073","Customer":"1898","Store":"1003","Employee":"1083","SaleDate":"2004/3/16","TaxPercent":"14","SalesAmount":"91.8","TotalAmount":"104.652"},{"SalesID":"1074","Customer":"1264","Store":"1000","Employee":"1038","SaleDate":"2004/3/16","TaxPercent":"0","SalesAmount":"74.92","TotalAmount":"74.92"},{"SalesID":"1075","Customer":"1786","Store":"1005","Employee":"1113","SaleDate":"2004/3/17","TaxPercent":"14","SalesAmount":"38.98","TotalAmount":"44.4372"},{"SalesID":"1076","Customer":"1197","Store":"1004","Employee":"1098","SaleDate":"2004/3/17","TaxPercent":"14","SalesAmount":"173.13","TotalAmount":"197.3682"},{"SalesID":"1077","Customer":"1972","Store":"1000","Employee":"1038","SaleDate":"2004/3/19","TaxPercent":"0","SalesAmount":"150.8975","TotalAmount":"150.8975"},{"SalesID":"1078","Customer":"1377","Store":"1006","Employee":"1128","SaleDate":"2004/3/20","TaxPercent":"0","SalesAmount":"67.45","TotalAmount":"67.45"},{"SalesID":"1079","Customer":"1295","Store":"1000","Employee":"1038","SaleDate":"2004/3/20","TaxPercent":"0","SalesAmount":"179.21","TotalAmount":"179.21"},{"SalesID":"1080","Customer":"1906","Store":"1005","Employee":"1113","SaleDate":"2004/3/22","TaxPercent":"14","SalesAmount":"100.734","TotalAmount":"114.8368"},{"SalesID":"1081","Customer":"1581","Store":"1005","Employee":"1113","SaleDate":"2004/3/22","TaxPercent":"14","SalesAmount":"134.89","TotalAmount":"153.7746"},{"SalesID":"1082","Customer":"1589","Store":"1004","Employee":"1098","SaleDate":"2004/3/22","TaxPercent":"14","SalesAmount":"173.12","TotalAmount":"197.3568"},{"SalesID":"1083","Customer":"1650","Store":"1005","Employee":"1113","SaleDate":"2004/3/24","TaxPercent":"14","SalesAmount":"77.5006","TotalAmount":"88.3507"},{"SalesID":"1084","Customer":"1586","Store":"1003","Employee":"1083","SaleDate":"2004/3/24","TaxPercent":"14","SalesAmount":"16.95","TotalAmount":"19.323"},{"SalesID":"1085","Customer":"1621","Store":"1005","Employee":"1113","SaleDate":"2004/3/25","TaxPercent":"14","SalesAmount":"305.49","TotalAmount":"348.2586"},{"SalesID":"1086","Customer":"1846","Store":"1006","Employee":"1128","SaleDate":"2004/3/28","TaxPercent":"0","SalesAmount":"53.89","TotalAmount":"53.89"},{"SalesID":"1087","Customer":"1752","Store":"1006","Employee":"1128","SaleDate":"2004/3/29","TaxPercent":"0","SalesAmount":"248.3457","TotalAmount":"248.3457"},{"SalesID":"1088","Customer":"1279","Store":"1001","Employee":"1053","SaleDate":"2004/3/29","TaxPercent":"14","SalesAmount":"266.46","TotalAmount":"303.7644"},{"SalesID":"1089","Customer":"1469","Store":"1005","Employee":"1113","SaleDate":"2004/3/30","TaxPercent":"14","SalesAmount":"80.92","TotalAmount":"92.2488"},{"SalesID":"1090","Customer":"1504","Store":"1000","Employee":"1038","SaleDate":"2004/3/30","TaxPercent":"0","SalesAmount":"244.21","TotalAmount":"244.21"},{"SalesID":"1091","Customer":"1993","Store":"1004","Employee":"1098","SaleDate":"2004/3/31","TaxPercent":"14","SalesAmount":"103.91","TotalAmount":"118.4574"},{"SalesID":"1092","Customer":"1995","Store":"1003","Employee":"1083","SaleDate":"2004/3/31","TaxPercent":"14","SalesAmount":"247.04","TotalAmount":"281.6256"},{"SalesID":"1093","Customer":"1466","Store":"1004","Employee":"1098","SaleDate":"2004/3/31","TaxPercent":"14","SalesAmount":"62.89","TotalAmount":"71.6946"},{"SalesID":"1094","Customer":"1572","Store":"1001","Employee":"1053","SaleDate":"2004/4/1","TaxPercent":"14","SalesAmount":"291.69","TotalAmount":"332.5266"},{"SalesID":"1095","Customer":"1112","Store":"1002","Employee":"1068","SaleDate":"2004/4/2","TaxPercent":"6.5","SalesAmount":"20.49","TotalAmount":"21.8218"},{"SalesID":"1096","Customer":"1944","Store":"1002","Employee":"1068","SaleDate":"2004/4/6","TaxPercent":"6.5","SalesAmount":"72.45","TotalAmount":"77.1592"},{"SalesID":"1097","Customer":"1765","Store":"1000","Employee":"1038","SaleDate":"2004/4/7","TaxPercent":"0","SalesAmount":"217.39","TotalAmount":"217.39"},{"SalesID":"1098","Customer":"1067","Store":"1001","Employee":"1053","SaleDate":"2004/4/7","TaxPercent":"14","SalesAmount":"63.39","TotalAmount":"72.2646"},{"SalesID":"1099","Customer":"1260","Store":"1004","Employee":"1098","SaleDate":"2004/4/8","TaxPercent":"14","SalesAmount":"295.25","TotalAmount":"336.585"},{"SalesID":"1100","Customer":"1042","Store":"1000","Employee":"1038","SaleDate":"2004/4/12","TaxPercent":"0","SalesAmount":"172.3265","TotalAmount":"172.3265"},{"SalesID":"1101","Customer":"1470","Store":"1003","Employee":"1083","SaleDate":"2004/4/14","TaxPercent":"14","SalesAmount":"143.89","TotalAmount":"164.0346"},{"SalesID":"1102","Customer":"1829","Store":"1006","Employee":"1128","SaleDate":"2004/4/16","TaxPercent":"0","SalesAmount":"301.48","TotalAmount":"301.48"},{"SalesID":"1103","Customer":"1931","Store":"1000","Employee":"1038","SaleDate":"2004/4/16","TaxPercent":"0","SalesAmount":"279.12","TotalAmount":"279.12"},{"SalesID":"1104","Customer":"1298","Store":"1006","Employee":"1128","SaleDate":"2004/4/17","TaxPercent":"0","SalesAmount":"230.22","TotalAmount":"230.22"},{"SalesID":"1105","Customer":"1679","Store":"1000","Employee":"1038","SaleDate":"2004/4/19","TaxPercent":"0","SalesAmount":"315.5657","TotalAmount":"315.5657"},{"SalesID":"1106","Customer":"1580","Store":"1002","Employee":"1068","SaleDate":"2004/4/20","TaxPercent":"6.5","SalesAmount":"275.12","TotalAmount":"293.0028"},{"SalesID":"1107","Customer":"1625","Store":"1003","Employee":"1083","SaleDate":"2004/4/20","TaxPercent":"14","SalesAmount":"22.49","TotalAmount":"25.6386"},{"SalesID":"1108","Customer":"1228","Store":"1005","Employee":"1113","SaleDate":"2004/4/21","TaxPercent":"14","SalesAmount":"44.5575","TotalAmount":"50.7956"},{"SalesID":"1109","Customer":"1376","Store":"1003","Employee":"1083","SaleDate":"2004/4/21","TaxPercent":"14","SalesAmount":"116.78","TotalAmount":"133.1292"},{"SalesID":"1110","Customer":"1222","Store":"1002","Employee":"1068","SaleDate":"2004/4/21","TaxPercent":"6.5","SalesAmount":"190.08","TotalAmount":"202.4352"},{"SalesID":"1111","Customer":"1648","Store":"1006","Employee":"1128","SaleDate":"2004/4/23","TaxPercent":"0","SalesAmount":"137.996","TotalAmount":"137.996"},{"SalesID":"1112","Customer":"1367","Store":"1004","Employee":"1098","SaleDate":"2004/4/23","TaxPercent":"14","SalesAmount":"241.69","TotalAmount":"275.5266"},{"SalesID":"1113","Customer":"1117","Store":"1005","Employee":"1113","SaleDate":"2004/4/24","TaxPercent":"14","SalesAmount":"288.582","TotalAmount":"328.9835"},{"SalesID":"1114","Customer":"1607","Store":"1003","Employee":"1083","SaleDate":"2004/4/24","TaxPercent":"14","SalesAmount":"236.19","TotalAmount":"269.2566"},{"SalesID":"1115","Customer":"1023","Store":"1006","Employee":"1128","SaleDate":"2004/4/24","TaxPercent":"0","SalesAmount":"71.6795","TotalAmount":"71.6795"},{"SalesID":"1116","Customer":"1610","Store":"1006","Employee":"1128","SaleDate":"2004/4/25","TaxPercent":"0","SalesAmount":"129.19","TotalAmount":"129.19"},{"SalesID":"1117","Customer":"1077","Store":"1003","Employee":"1083","SaleDate":"2004/4/25","TaxPercent":"14","SalesAmount":"90.8653","TotalAmount":"103.5864"},{"SalesID":"1118","Customer":"1358","Store":"1004","Employee":"1098","SaleDate":"2004/4/27","TaxPercent":"14","SalesAmount":"179.21","TotalAmount":"204.2994"},{"SalesID":"1119","Customer":"1746","Store":"1006","Employee":"1128","SaleDate":"2004/4/27","TaxPercent":"0","SalesAmount":"93.96","TotalAmount":"93.96"},{"SalesID":"1120","Customer":"1855","Store":"1001","Employee":"1053","SaleDate":"2004/4/27","TaxPercent":"14","SalesAmount":"171.25","TotalAmount":"195.225"},{"SalesID":"1121","Customer":"1105","Store":"1001","Employee":"1053","SaleDate":"2004/4/28","TaxPercent":"14","SalesAmount":"84.34","TotalAmount":"96.1476"},{"SalesID":"1122","Customer":"1443","Store":"1002","Employee":"1068","SaleDate":"2004/4/28","TaxPercent":"6.5","SalesAmount":"86.46","TotalAmount":"92.0799"},{"SalesID":"1123","Customer":"1384","Store":"1006","Employee":"1128","SaleDate":"2004/4/29","TaxPercent":"0","SalesAmount":"21.49","TotalAmount":"21.49"},{"SalesID":"1124","Customer":"1964","Store":"1006","Employee":"1128","SaleDate":"2004/4/29","TaxPercent":"0","SalesAmount":"302.5285","TotalAmount":"302.5285"},{"SalesID":"1125","Customer":"1408","Store":"1003","Employee":"1083","SaleDate":"2004/4/30","TaxPercent":"14","SalesAmount":"142.19","TotalAmount":"162.0966"},{"SalesID":"1126","Customer":"1126","Store":"1002","Employee":"1068","SaleDate":"2004/5/2","TaxPercent":"6.5","SalesAmount":"111.78","TotalAmount":"119.0457"},{"SalesID":"1127","Customer":"1939","Store":"1005","Employee":"1113","SaleDate":"2004/5/2","TaxPercent":"14","SalesAmount":"34.98","TotalAmount":"39.8772"},{"SalesID":"1128","Customer":"1486","Store":"1006","Employee":"1128","SaleDate":"2004/5/3","TaxPercent":"0","SalesAmount":"70.89","TotalAmount":"70.89"},{"SalesID":"1129","Customer":"1074","Store":"1001","Employee":"1053","SaleDate":"2004/5/4","TaxPercent":"14","SalesAmount":"231.17","TotalAmount":"263.5338"},{"SalesID":"1130","Customer":"1265","Store":"1006","Employee":"1128","SaleDate":"2004/5/4","TaxPercent":"0","SalesAmount":"143.5751","TotalAmount":"143.5751"},{"SalesID":"1131","Customer":"1984","Store":"1006","Employee":"1128","SaleDate":"2004/5/4","TaxPercent":"0","SalesAmount":"155.38","TotalAmount":"155.38"},{"SalesID":"1132","Customer":"1460","Store":"1002","Employee":"1068","SaleDate":"2004/5/8","TaxPercent":"6.5","SalesAmount":"298.08","TotalAmount":"317.4552"},{"SalesID":"1133","Customer":"1761","Store":"1000","Employee":"1038","SaleDate":"2004/5/9","TaxPercent":"0","SalesAmount":"230.4275","TotalAmount":"230.4275"},{"SalesID":"1134","Customer":"1578","Store":"1005","Employee":"1113","SaleDate":"2004/5/9","TaxPercent":"14","SalesAmount":"346.21","TotalAmount":"394.6794"},{"SalesID":"1135","Customer":"1155","Store":"1004","Employee":"1098","SaleDate":"2004/5/11","TaxPercent":"14","SalesAmount":"34.98","TotalAmount":"39.8772"},{"SalesID":"1136","Customer":"1843","Store":"1003","Employee":"1083","SaleDate":"2004/5/12","TaxPercent":"14","SalesAmount":"38.9","TotalAmount":"44.346"},{"SalesID":"1137","Customer":"1699","Store":"1002","Employee":"1068","SaleDate":"2004/5/13","TaxPercent":"6.5","SalesAmount":"166.34","TotalAmount":"177.1521"},{"SalesID":"1138","Customer":"1883","Store":"1002","Employee":"1068","SaleDate":"2004/5/15","TaxPercent":"6.5","SalesAmount":"100.441","TotalAmount":"106.9697"},{"SalesID":"1139","Customer":"1781","Store":"1001","Employee":"1053","SaleDate":"2004/5/15","TaxPercent":"14","SalesAmount":"119.32","TotalAmount":"136.0248"},{"SalesID":"1140","Customer":"1780","Store":"1006","Employee":"1128","SaleDate":"2004/5/15","TaxPercent":"0","SalesAmount":"103.2953","TotalAmount":"103.2953"},{"SalesID":"1141","Customer":"1738","Store":"1002","Employee":"1068","SaleDate":"2004/5/16","TaxPercent":"6.5","SalesAmount":"203.74","TotalAmount":"216.9831"},{"SalesID":"1142","Customer":"1648","Store":"1006","Employee":"1128","SaleDate":"2004/5/18","TaxPercent":"0","SalesAmount":"47.1795","TotalAmount":"47.1795"},{"SalesID":"1143","Customer":"1179","Store":"1004","Employee":"1098","SaleDate":"2004/5/18","TaxPercent":"14","SalesAmount":"17.45","TotalAmount":"19.893"},{"SalesID":"1144","Customer":"1174","Store":"1006","Employee":"1128","SaleDate":"2004/5/18","TaxPercent":"0","SalesAmount":"30.44","TotalAmount":"30.44"},{"SalesID":"1145","Customer":"1674","Store":"1003","Employee":"1083","SaleDate":"2004/5/19","TaxPercent":"14","SalesAmount":"16.95","TotalAmount":"19.323"},{"SalesID":"1146","Customer":"1332","Store":"1005","Employee":"1113","SaleDate":"2004/5/20","TaxPercent":"14","SalesAmount":"84.87","TotalAmount":"96.7518"},{"SalesID":"1147","Customer":"1325","Store":"1004","Employee":"1098","SaleDate":"2004/5/23","TaxPercent":"14","SalesAmount":"299.48","TotalAmount":"341.4072"},{"SalesID":"1148","Customer":"1087","Store":"1005","Employee":"1113","SaleDate":"2004/5/26","TaxPercent":"14","SalesAmount":"212.7527","TotalAmount":"242.5381"},{"SalesID":"1149","Customer":"1967","Store":"1001","Employee":"1053","SaleDate":"2004/5/27","TaxPercent":"14","SalesAmount":"106.2195","TotalAmount":"121.0902"},{"SalesID":"1150","Customer":"1161","Store":"1002","Employee":"1068","SaleDate":"2004/5/27","TaxPercent":"6.5","SalesAmount":"169.54","TotalAmount":"180.5601"},{"SalesID":"1151","Customer":"1285","Store":"1005","Employee":"1113","SaleDate":"2004/5/28","TaxPercent":"14","SalesAmount":"291.5","TotalAmount":"332.31"},{"SalesID":"1152","Customer":"1627","Store":"1006","Employee":"1128","SaleDate":"2004/5/28","TaxPercent":"0","SalesAmount":"146.5455","TotalAmount":"146.5455"},{"SalesID":"1153","Customer":"1520","Store":"1004","Employee":"1098","SaleDate":"2004/5/28","TaxPercent":"14","SalesAmount":"108.79","TotalAmount":"124.0206"},{"SalesID":"1154","Customer":"1555","Store":"1002","Employee":"1068","SaleDate":"2004/5/28","TaxPercent":"6.5","SalesAmount":"276.24","TotalAmount":"294.1956"},{"SalesID":"1155","Customer":"1872","Store":"1001","Employee":"1053","SaleDate":"2004/5/29","TaxPercent":"14","SalesAmount":"154.8","TotalAmount":"176.472"},{"SalesID":"1156","Customer":"1900","Store":"1004","Employee":"1098","SaleDate":"2004/5/30","TaxPercent":"14","SalesAmount":"233.22","TotalAmount":"265.8708"},{"SalesID":"1157","Customer":"1422","Store":"1004","Employee":"1098","SaleDate":"2004/5/30","TaxPercent":"14","SalesAmount":"127.15","TotalAmount":"144.951"},{"SalesID":"1158","Customer":"1287","Store":"1002","Employee":"1068","SaleDate":"2004/5/31","TaxPercent":"6.5","SalesAmount":"189.58","TotalAmount":"201.9027"},{"SalesID":"1159","Customer":"1513","Store":"1002","Employee":"1068","SaleDate":"2004/5/31","TaxPercent":"6.5","SalesAmount":"192.75","TotalAmount":"205.2788"},{"SalesID":"1160","Customer":"1857","Store":"1005","Employee":"1113","SaleDate":"2004/6/1","TaxPercent":"14","SalesAmount":"60.85","TotalAmount":"69.369"},{"SalesID":"1161","Customer":"1498","Store":"1000","Employee":"1038","SaleDate":"2004/6/2","TaxPercent":"0","SalesAmount":"247.7604","TotalAmount":"247.7604"},{"SalesID":"1162","Customer":"1796","Store":"1005","Employee":"1113","SaleDate":"2004/6/2","TaxPercent":"14","SalesAmount":"208.2695","TotalAmount":"237.4272"},{"SalesID":"1163","Customer":"1605","Store":"1003","Employee":"1083","SaleDate":"2004/6/2","TaxPercent":"14","SalesAmount":"183.6801","TotalAmount":"209.3953"},{"SalesID":"1164","Customer":"1673","Store":"1006","Employee":"1128","SaleDate":"2004/6/3","TaxPercent":"0","SalesAmount":"69.43","TotalAmount":"69.43"},{"SalesID":"1165","Customer":"1418","Store":"1006","Employee":"1128","SaleDate":"2004/6/3","TaxPercent":"0","SalesAmount":"122.4","TotalAmount":"122.4"},{"SalesID":"1166","Customer":"1896","Store":"1000","Employee":"1038","SaleDate":"2004/6/3","TaxPercent":"0","SalesAmount":"18.95","TotalAmount":"18.95"},{"SalesID":"1167","Customer":"1600","Store":"1002","Employee":"1068","SaleDate":"2004/6/3","TaxPercent":"6.5","SalesAmount":"175.83","TotalAmount":"187.259"},{"SalesID":"1168","Customer":"1295","Store":"1000","Employee":"1038","SaleDate":"2004/6/4","TaxPercent":"0","SalesAmount":"122.35","TotalAmount":"122.35"},{"SalesID":"1169","Customer":"1810","Store":"1006","Employee":"1128","SaleDate":"2004/6/7","TaxPercent":"0","SalesAmount":"65.94","TotalAmount":"65.94"},{"SalesID":"1170","Customer":"1327","Store":"1003","Employee":"1083","SaleDate":"2004/6/9","TaxPercent":"14","SalesAmount":"65.93","TotalAmount":"75.1602"},{"SalesID":"1171","Customer":"1393","Store":"1000","Employee":"1038","SaleDate":"2004/6/9","TaxPercent":"0","SalesAmount":"189.25","TotalAmount":"189.25"},{"SalesID":"1172","Customer":"1787","Store":"1004","Employee":"1098","SaleDate":"2004/6/10","TaxPercent":"14","SalesAmount":"15.95","TotalAmount":"18.183"},{"SalesID":"1173","Customer":"1503","Store":"1004","Employee":"1098","SaleDate":"2004/6/11","TaxPercent":"14","SalesAmount":"233.64","TotalAmount":"266.3496"},{"SalesID":"1174","Customer":"1813","Store":"1004","Employee":"1098","SaleDate":"2004/6/11","TaxPercent":"14","SalesAmount":"43.48","TotalAmount":"49.5672"},{"SalesID":"1175","Customer":"1771","Store":"1006","Employee":"1128","SaleDate":"2004/6/13","TaxPercent":"0","SalesAmount":"15.49","TotalAmount":"15.49"},{"SalesID":"1176","Customer":"1790","Store":"1001","Employee":"1053","SaleDate":"2004/6/13","TaxPercent":"14","SalesAmount":"194.3735","TotalAmount":"221.5858"},{"SalesID":"1177","Customer":"1443","Store":"1002","Employee":"1068","SaleDate":"2004/6/15","TaxPercent":"6.5","SalesAmount":"64.89","TotalAmount":"69.1078"},{"SalesID":"1178","Customer":"1264","Store":"1000","Employee":"1038","SaleDate":"2004/6/16","TaxPercent":"0","SalesAmount":"168.75","TotalAmount":"168.75"},{"SalesID":"1179","Customer":"1559","Store":"1005","Employee":"1113","SaleDate":"2004/6/18","TaxPercent":"14","SalesAmount":"106.91","TotalAmount":"121.8774"},{"SalesID":"1180","Customer":"1859","Store":"1006","Employee":"1128","SaleDate":"2004/6/19","TaxPercent":"0","SalesAmount":"254.148","TotalAmount":"254.148"},{"SalesID":"1181","Customer":"1690","Store":"1005","Employee":"1113","SaleDate":"2004/6/19","TaxPercent":"14","SalesAmount":"30.4","TotalAmount":"34.656"},{"SalesID":"1182","Customer":"1132","Store":"1002","Employee":"1068","SaleDate":"2004/6/19","TaxPercent":"6.5","SalesAmount":"98.2055","TotalAmount":"104.5889"},{"SalesID":"1183","Customer":"1318","Store":"1003","Employee":"1083","SaleDate":"2004/6/20","TaxPercent":"14","SalesAmount":"175.534","TotalAmount":"200.1088"},{"SalesID":"1184","Customer":"1420","Store":"1006","Employee":"1128","SaleDate":"2004/6/21","TaxPercent":"0","SalesAmount":"98.88","TotalAmount":"98.88"},{"SalesID":"1185","Customer":"1991","Store":"1000","Employee":"1038","SaleDate":"2004/6/21","TaxPercent":"0","SalesAmount":"316.07","TotalAmount":"316.07"},{"SalesID":"1186","Customer":"1430","Store":"1005","Employee":"1113","SaleDate":"2004/6/21","TaxPercent":"14","SalesAmount":"23.49","TotalAmount":"26.7786"},{"SalesID":"1187","Customer":"1176","Store":"1002","Employee":"1068","SaleDate":"2004/6/22","TaxPercent":"6.5","SalesAmount":"154.18","TotalAmount":"164.2017"},{"SalesID":"1188","Customer":"1547","Store":"1000","Employee":"1038","SaleDate":"2004/6/22","TaxPercent":"0","SalesAmount":"40.48","TotalAmount":"40.48"},{"SalesID":"1189","Customer":"1639","Store":"1002","Employee":"1068","SaleDate":"2004/6/22","TaxPercent":"6.5","SalesAmount":"118.5701","TotalAmount":"126.2772"},{"SalesID":"1190","Customer":"1141","Store":"1002","Employee":"1068","SaleDate":"2004/6/24","TaxPercent":"6.5","SalesAmount":"225.02","TotalAmount":"239.6463"},{"SalesID":"1191","Customer":"1661","Store":"1004","Employee":"1098","SaleDate":"2004/6/24","TaxPercent":"14","SalesAmount":"43.94","TotalAmount":"50.0916"},{"SalesID":"1192","Customer":"1786","Store":"1005","Employee":"1113","SaleDate":"2004/6/26","TaxPercent":"14","SalesAmount":"63.35","TotalAmount":"72.219"},{"SalesID":"1193","Customer":"1818","Store":"1000","Employee":"1038","SaleDate":"2004/6/27","TaxPercent":"0","SalesAmount":"110.74","TotalAmount":"110.74"},{"SalesID":"1194","Customer":"1163","Store":"1000","Employee":"1038","SaleDate":"2004/6/28","TaxPercent":"0","SalesAmount":"43.9902","TotalAmount":"43.9902"},{"SalesID":"1195","Customer":"1787","Store":"1004","Employee":"1098","SaleDate":"2004/6/30","TaxPercent":"14","SalesAmount":"153.668","TotalAmount":"175.1815"},{"SalesID":"1196","Customer":"1084","Store":"1004","Employee":"1098","SaleDate":"2004/7/1","TaxPercent":"14","SalesAmount":"120.15","TotalAmount":"136.971"},{"SalesID":"1197","Customer":"1468","Store":"1000","Employee":"1038","SaleDate":"2004/7/2","TaxPercent":"0","SalesAmount":"176.63","TotalAmount":"176.63"},{"SalesID":"1198","Customer":"1582","Store":"1003","Employee":"1083","SaleDate":"2004/7/2","TaxPercent":"14","SalesAmount":"203.11","TotalAmount":"231.5454"},{"SalesID":"1199","Customer":"1560","Store":"1006","Employee":"1128","SaleDate":"2004/7/3","TaxPercent":"0","SalesAmount":"222.5428","TotalAmount":"222.5428"},{"SalesID":"1200","Customer":"1183","Store":"1000","Employee":"1038","SaleDate":"2004/7/5","TaxPercent":"0","SalesAmount":"197.54","TotalAmount":"197.54"},{"SalesID":"1201","Customer":"1719","Store":"1000","Employee":"1038","SaleDate":"2004/7/6","TaxPercent":"0","SalesAmount":"210.604","TotalAmount":"210.604"},{"SalesID":"1202","Customer":"1255","Store":"1006","Employee":"1128","SaleDate":"2004/7/6","TaxPercent":"0","SalesAmount":"131.74","TotalAmount":"131.74"},{"SalesID":"1203","Customer":"1767","Store":"1001","Employee":"1053","SaleDate":"2004/7/7","TaxPercent":"14","SalesAmount":"22.45","TotalAmount":"25.593"},{"SalesID":"1204","Customer":"1039","Store":"1002","Employee":"1068","SaleDate":"2004/7/8","TaxPercent":"6.5","SalesAmount":"158.76","TotalAmount":"169.0794"},{"SalesID":"1205","Customer":"1548","Store":"1003","Employee":"1083","SaleDate":"2004/7/10","TaxPercent":"14","SalesAmount":"85.4402","TotalAmount":"97.4018"},{"SalesID":"1206","Customer":"1410","Store":"1002","Employee":"1068","SaleDate":"2004/7/10","TaxPercent":"6.5","SalesAmount":"36.9","TotalAmount":"39.2985"},{"SalesID":"1207","Customer":"1202","Store":"1004","Employee":"1098","SaleDate":"2004/7/11","TaxPercent":"14","SalesAmount":"21.99","TotalAmount":"25.0686"},{"SalesID":"1208","Customer":"1777","Store":"1006","Employee":"1128","SaleDate":"2004/7/12","TaxPercent":"0","SalesAmount":"191.862","TotalAmount":"191.862"},{"SalesID":"1209","Customer":"1191","Store":"1005","Employee":"1113","SaleDate":"2004/7/13","TaxPercent":"14","SalesAmount":"115.87","TotalAmount":"132.0918"},{"SalesID":"1210","Customer":"1970","Store":"1003","Employee":"1083","SaleDate":"2004/7/13","TaxPercent":"14","SalesAmount":"48.44","TotalAmount":"55.2216"},{"SalesID":"1211","Customer":"1088","Store":"1000","Employee":"1038","SaleDate":"2004/7/13","TaxPercent":"0","SalesAmount":"105.4","TotalAmount":"105.4"},{"SalesID":"1212","Customer":"1331","Store":"1005","Employee":"1113","SaleDate":"2004/7/15","TaxPercent":"14","SalesAmount":"129.3809","TotalAmount":"147.4942"},{"SalesID":"1213","Customer":"1837","Store":"1005","Employee":"1113","SaleDate":"2004/7/17","TaxPercent":"14","SalesAmount":"215.62","TotalAmount":"245.8068"},{"SalesID":"1214","Customer":"1822","Store":"1005","Employee":"1113","SaleDate":"2004/7/17","TaxPercent":"14","SalesAmount":"283.07","TotalAmount":"322.6998"},{"SalesID":"1215","Customer":"1568","Store":"1002","Employee":"1068","SaleDate":"2004/7/18","TaxPercent":"6.5","SalesAmount":"297.2","TotalAmount":"316.518"},{"SalesID":"1216","Customer":"1974","Store":"1001","Employee":"1053","SaleDate":"2004/7/21","TaxPercent":"14","SalesAmount":"270.58","TotalAmount":"308.4612"},{"SalesID":"1217","Customer":"1327","Store":"1003","Employee":"1083","SaleDate":"2004/7/22","TaxPercent":"14","SalesAmount":"63.39","TotalAmount":"72.2646"},{"SalesID":"1218","Customer":"1338","Store":"1001","Employee":"1053","SaleDate":"2004/7/22","TaxPercent":"14","SalesAmount":"204.0251","TotalAmount":"232.5886"},{"SalesID":"1219","Customer":"1146","Store":"1003","Employee":"1083","SaleDate":"2004/7/22","TaxPercent":"14","SalesAmount":"142.76","TotalAmount":"162.7464"},{"SalesID":"1220","Customer":"1204","Store":"1005","Employee":"1113","SaleDate":"2004/7/23","TaxPercent":"14","SalesAmount":"175.21","TotalAmount":"199.7394"},{"SalesID":"1221","Customer":"1400","Store":"1002","Employee":"1068","SaleDate":"2004/7/25","TaxPercent":"6.5","SalesAmount":"124.32","TotalAmount":"132.4008"},{"SalesID":"1222","Customer":"1129","Store":"1000","Employee":"1038","SaleDate":"2004/7/25","TaxPercent":"0","SalesAmount":"33.8557","TotalAmount":"33.8557"},{"SalesID":"1223","Customer":"1254","Store":"1000","Employee":"1038","SaleDate":"2004/7/26","TaxPercent":"0","SalesAmount":"44.9","TotalAmount":"44.9"},{"SalesID":"1224","Customer":"1657","Store":"1001","Employee":"1053","SaleDate":"2004/7/26","TaxPercent":"14","SalesAmount":"111.361","TotalAmount":"126.9515"},{"SalesID":"1225","Customer":"1271","Store":"1004","Employee":"1098","SaleDate":"2004/7/27","TaxPercent":"14","SalesAmount":"34.98","TotalAmount":"39.8772"},{"SalesID":"1226","Customer":"1046","Store":"1006","Employee":"1128","SaleDate":"2004/7/27","TaxPercent":"0","SalesAmount":"190.58","TotalAmount":"190.58"},{"SalesID":"1227","Customer":"1244","Store":"1000","Employee":"1038","SaleDate":"2004/7/30","TaxPercent":"0","SalesAmount":"300.23","TotalAmount":"300.23"},{"SalesID":"1228","Customer":"1578","Store":"1005","Employee":"1113","SaleDate":"2004/7/30","TaxPercent":"14","SalesAmount":"225.22","TotalAmount":"256.7508"},{"SalesID":"1229","Customer":"1579","Store":"1000","Employee":"1038","SaleDate":"2004/7/31","TaxPercent":"0","SalesAmount":"156.69","TotalAmount":"156.69"},{"SalesID":"1230","Customer":"1171","Store":"1004","Employee":"1098","SaleDate":"2004/8/1","TaxPercent":"14","SalesAmount":"168.7","TotalAmount":"192.318"},{"SalesID":"1231","Customer":"1076","Store":"1002","Employee":"1068","SaleDate":"2004/8/2","TaxPercent":"6.5","SalesAmount":"236.8635","TotalAmount":"252.2596"},{"SalesID":"1232","Customer":"1722","Store":"1004","Employee":"1098","SaleDate":"2004/8/2","TaxPercent":"14","SalesAmount":"181.0506","TotalAmount":"206.3977"},{"SalesID":"1233","Customer":"1749","Store":"1006","Employee":"1128","SaleDate":"2004/8/3","TaxPercent":"0","SalesAmount":"200.28","TotalAmount":"200.28"},{"SalesID":"1234","Customer":"1345","Store":"1000","Employee":"1038","SaleDate":"2004/8/3","TaxPercent":"0","SalesAmount":"23.45","TotalAmount":"23.45"},{"SalesID":"1235","Customer":"1593","Store":"1001","Employee":"1053","SaleDate":"2004/8/5","TaxPercent":"14","SalesAmount":"152.34","TotalAmount":"173.6676"},{"SalesID":"1236","Customer":"1554","Store":"1006","Employee":"1128","SaleDate":"2004/8/5","TaxPercent":"0","SalesAmount":"81.37","TotalAmount":"81.37"},{"SalesID":"1237","Customer":"1844","Store":"1000","Employee":"1038","SaleDate":"2004/8/5","TaxPercent":"0","SalesAmount":"30.94","TotalAmount":"30.94"},{"SalesID":"1238","Customer":"1781","Store":"1001","Employee":"1053","SaleDate":"2004/8/6","TaxPercent":"14","SalesAmount":"16.99","TotalAmount":"19.3686"},{"SalesID":"1239","Customer":"1929","Store":"1006","Employee":"1128","SaleDate":"2004/8/6","TaxPercent":"0","SalesAmount":"217.5536","TotalAmount":"217.5536"},{"SalesID":"1240","Customer":"1916","Store":"1006","Employee":"1128","SaleDate":"2004/8/7","TaxPercent":"0","SalesAmount":"55.35","TotalAmount":"55.35"},{"SalesID":"1241","Customer":"1567","Store":"1004","Employee":"1098","SaleDate":"2004/8/7","TaxPercent":"14","SalesAmount":"134.92","TotalAmount":"153.8088"},{"SalesID":"1242","Customer":"1604","Store":"1006","Employee":"1128","SaleDate":"2004/8/10","TaxPercent":"0","SalesAmount":"23.95","TotalAmount":"23.95"},{"SalesID":"1243","Customer":"1151","Store":"1004","Employee":"1098","SaleDate":"2004/8/10","TaxPercent":"14","SalesAmount":"268.74","TotalAmount":"306.3636"},{"SalesID":"1244","Customer":"1121","Store":"1006","Employee":"1128","SaleDate":"2004/8/10","TaxPercent":"0","SalesAmount":"207.075","TotalAmount":"207.075"},{"SalesID":"1245","Customer":"1531","Store":"1000","Employee":"1038","SaleDate":"2004/8/11","TaxPercent":"0","SalesAmount":"182.17","TotalAmount":"182.17"},{"SalesID":"1246","Customer":"1496","Store":"1004","Employee":"1098","SaleDate":"2004/8/12","TaxPercent":"14","SalesAmount":"241.172","TotalAmount":"274.9361"},{"SalesID":"1247","Customer":"1597","Store":"1002","Employee":"1068","SaleDate":"2004/8/12","TaxPercent":"6.5","SalesAmount":"19.95","TotalAmount":"21.2468"},{"SalesID":"1248","Customer":"1936","Store":"1006","Employee":"1128","SaleDate":"2004/8/13","TaxPercent":"0","SalesAmount":"26.9","TotalAmount":"26.9"},{"SalesID":"1249","Customer":"1663","Store":"1003","Employee":"1083","SaleDate":"2004/8/15","TaxPercent":"14","SalesAmount":"16.99","TotalAmount":"19.3686"},{"SalesID":"1250","Customer":"1210","Store":"1006","Employee":"1128","SaleDate":"2004/8/16","TaxPercent":"0","SalesAmount":"257.21","TotalAmount":"257.21"},{"SalesID":"1251","Customer":"1305","Store":"1001","Employee":"1053","SaleDate":"2004/8/16","TaxPercent":"14","SalesAmount":"239.43","TotalAmount":"272.9502"},{"SalesID":"1252","Customer":"1481","Store":"1004","Employee":"1098","SaleDate":"2004/8/17","TaxPercent":"14","SalesAmount":"294.06","TotalAmount":"335.2284"},{"SalesID":"1253","Customer":"1535","Store":"1004","Employee":"1098","SaleDate":"2004/8/19","TaxPercent":"14","SalesAmount":"24.95","TotalAmount":"28.443"},{"SalesID":"1254","Customer":"1441","Store":"1003","Employee":"1083","SaleDate":"2004/8/19","TaxPercent":"14","SalesAmount":"172.33","TotalAmount":"196.4562"},{"SalesID":"1255","Customer":"1041","Store":"1003","Employee":"1083","SaleDate":"2004/8/21","TaxPercent":"14","SalesAmount":"212.78","TotalAmount":"242.5692"},{"SalesID":"1256","Customer":"1673","Store":"1006","Employee":"1128","SaleDate":"2004/8/21","TaxPercent":"0","SalesAmount":"95.001","TotalAmount":"95.001"},{"SalesID":"1257","Customer":"1203","Store":"1005","Employee":"1113","SaleDate":"2004/8/24","TaxPercent":"14","SalesAmount":"215.65","TotalAmount":"245.841"},{"SalesID":"1258","Customer":"1606","Store":"1000","Employee":"1038","SaleDate":"2004/8/26","TaxPercent":"0","SalesAmount":"185.71","TotalAmount":"185.71"},{"SalesID":"1259","Customer":"1635","Store":"1001","Employee":"1053","SaleDate":"2004/8/26","TaxPercent":"14","SalesAmount":"99.86","TotalAmount":"113.8404"},{"SalesID":"1260","Customer":"1407","Store":"1006","Employee":"1128","SaleDate":"2004/8/26","TaxPercent":"0","SalesAmount":"285.2607","TotalAmount":"285.2607"},{"SalesID":"1261","Customer":"1848","Store":"1002","Employee":"1068","SaleDate":"2004/8/26","TaxPercent":"6.5","SalesAmount":"32.9","TotalAmount":"35.0385"},{"SalesID":"1262","Customer":"1580","Store":"1002","Employee":"1068","SaleDate":"2004/8/29","TaxPercent":"6.5","SalesAmount":"179.374","TotalAmount":"191.0333"},{"SalesID":"1263","Customer":"1272","Store":"1004","Employee":"1098","SaleDate":"2004/8/29","TaxPercent":"14","SalesAmount":"21.95","TotalAmount":"25.023"},{"SalesID":"1264","Customer":"1245","Store":"1006","Employee":"1128","SaleDate":"2004/8/29","TaxPercent":"0","SalesAmount":"88.34","TotalAmount":"88.34"},{"SalesID":"1265","Customer":"1706","Store":"1000","Employee":"1038","SaleDate":"2004/8/30","TaxPercent":"0","SalesAmount":"58.39","TotalAmount":"58.39"},{"SalesID":"1266","Customer":"1049","Store":"1003","Employee":"1083","SaleDate":"2004/8/31","TaxPercent":"14","SalesAmount":"102.4","TotalAmount":"116.736"},{"SalesID":"1267","Customer":"1566","Store":"1000","Employee":"1038","SaleDate":"2004/9/1","TaxPercent":"0","SalesAmount":"120.6659","TotalAmount":"120.6659"},{"SalesID":"1268","Customer":"1470","Store":"1003","Employee":"1083","SaleDate":"2004/9/2","TaxPercent":"14","SalesAmount":"42.48","TotalAmount":"48.4272"},{"SalesID":"1269","Customer":"1918","Store":"1003","Employee":"1083","SaleDate":"2004/9/2","TaxPercent":"14","SalesAmount":"157.81","TotalAmount":"179.9034"},{"SalesID":"1270","Customer":"1096","Store":"1002","Employee":"1068","SaleDate":"2004/9/2","TaxPercent":"6.5","SalesAmount":"252.68","TotalAmount":"269.1042"},{"SalesID":"1271","Customer":"1663","Store":"1003","Employee":"1083","SaleDate":"2004/9/3","TaxPercent":"14","SalesAmount":"179.13","TotalAmount":"204.2082"},{"SalesID":"1272","Customer":"1762","Store":"1001","Employee":"1053","SaleDate":"2004/9/4","TaxPercent":"14","SalesAmount":"98.32","TotalAmount":"112.0848"},{"SalesID":"1273","Customer":"1650","Store":"1005","Employee":"1113","SaleDate":"2004/9/5","TaxPercent":"14","SalesAmount":"218.401","TotalAmount":"248.9771"},{"SalesID":"1274","Customer":"1952","Store":"1000","Employee":"1038","SaleDate":"2004/9/6","TaxPercent":"0","SalesAmount":"78.96","TotalAmount":"78.96"},{"SalesID":"1275","Customer":"1342","Store":"1000","Employee":"1038","SaleDate":"2004/9/6","TaxPercent":"0","SalesAmount":"190.67","TotalAmount":"190.67"},{"SalesID":"1276","Customer":"1188","Store":"1004","Employee":"1098","SaleDate":"2004/9/8","TaxPercent":"14","SalesAmount":"162.142","TotalAmount":"184.8419"},{"SalesID":"1277","Customer":"1290","Store":"1001","Employee":"1053","SaleDate":"2004/9/8","TaxPercent":"14","SalesAmount":"51.43","TotalAmount":"58.6302"},{"SalesID":"1278","Customer":"1854","Store":"1002","Employee":"1068","SaleDate":"2004/9/8","TaxPercent":"6.5","SalesAmount":"208.19","TotalAmount":"221.7224"},{"SalesID":"1279","Customer":"1220","Store":"1003","Employee":"1083","SaleDate":"2004/9/8","TaxPercent":"14","SalesAmount":"277.4","TotalAmount":"316.236"},{"SalesID":"1280","Customer":"1424","Store":"1005","Employee":"1113","SaleDate":"2004/9/9","TaxPercent":"14","SalesAmount":"131.9865","TotalAmount":"150.4646"},{"SalesID":"1281","Customer":"1071","Store":"1005","Employee":"1113","SaleDate":"2004/9/9","TaxPercent":"14","SalesAmount":"213.23","TotalAmount":"243.0822"},{"SalesID":"1282","Customer":"1177","Store":"1003","Employee":"1083","SaleDate":"2004/9/10","TaxPercent":"14","SalesAmount":"175.79","TotalAmount":"200.4006"},{"SalesID":"1283","Customer":"1588","Store":"1000","Employee":"1038","SaleDate":"2004/9/10","TaxPercent":"0","SalesAmount":"208.0665","TotalAmount":"208.0665"},{"SalesID":"1284","Customer":"1236","Store":"1000","Employee":"1038","SaleDate":"2004/9/10","TaxPercent":"0","SalesAmount":"108.38","TotalAmount":"108.38"},{"SalesID":"1285","Customer":"1525","Store":"1002","Employee":"1068","SaleDate":"2004/9/10","TaxPercent":"6.5","SalesAmount":"76.38","TotalAmount":"81.3447"},{"SalesID":"1286","Customer":"1312","Store":"1003","Employee":"1083","SaleDate":"2004/9/12","TaxPercent":"14","SalesAmount":"151.27","TotalAmount":"172.4478"},{"SalesID":"1287","Customer":"1827","Store":"1003","Employee":"1083","SaleDate":"2004/9/12","TaxPercent":"14","SalesAmount":"252.7159","TotalAmount":"288.0961"},{"SalesID":"1288","Customer":"1230","Store":"1006","Employee":"1128","SaleDate":"2004/9/12","TaxPercent":"0","SalesAmount":"126.9907","TotalAmount":"126.9907"},{"SalesID":"1289","Customer":"1809","Store":"1005","Employee":"1113","SaleDate":"2004/9/13","TaxPercent":"14","SalesAmount":"158.27","TotalAmount":"180.4278"},{"SalesID":"1290","Customer":"1185","Store":"1004","Employee":"1098","SaleDate":"2004/9/14","TaxPercent":"14","SalesAmount":"230.39","TotalAmount":"262.6446"},{"SalesID":"1291","Customer":"1608","Store":"1003","Employee":"1083","SaleDate":"2004/9/15","TaxPercent":"14","SalesAmount":"187.2","TotalAmount":"213.408"},{"SalesID":"1292","Customer":"1868","Store":"1001","Employee":"1053","SaleDate":"2004/9/15","TaxPercent":"14","SalesAmount":"81.88","TotalAmount":"93.3432"},{"SalesID":"1293","Customer":"1502","Store":"1006","Employee":"1128","SaleDate":"2004/9/16","TaxPercent":"0","SalesAmount":"18.95","TotalAmount":"18.95"},{"SalesID":"1294","Customer":"1249","Store":"1004","Employee":"1098","SaleDate":"2004/9/16","TaxPercent":"14","SalesAmount":"129.5104","TotalAmount":"147.6419"},{"SalesID":"1295","Customer":"1694","Store":"1006","Employee":"1128","SaleDate":"2004/9/18","TaxPercent":"0","SalesAmount":"38.323","TotalAmount":"38.323"},{"SalesID":"1296","Customer":"1561","Store":"1002","Employee":"1068","SaleDate":"2004/9/19","TaxPercent":"6.5","SalesAmount":"49.48","TotalAmount":"52.6962"},{"SalesID":"1297","Customer":"1847","Store":"1000","Employee":"1038","SaleDate":"2004/9/19","TaxPercent":"0","SalesAmount":"160.76","TotalAmount":"160.76"},{"SalesID":"1298","Customer":"1011","Store":"1006","Employee":"1128","SaleDate":"2004/9/20","TaxPercent":"0","SalesAmount":"212.57","TotalAmount":"212.57"},{"SalesID":"1299","Customer":"1337","Store":"1000","Employee":"1038","SaleDate":"2004/9/20","TaxPercent":"0","SalesAmount":"175.71","TotalAmount":"175.71"},{"SalesID":"1300","Customer":"1056","Store":"1002","Employee":"1068","SaleDate":"2004/9/24","TaxPercent":"6.5","SalesAmount":"46.4","TotalAmount":"49.416"},{"SalesID":"1301","Customer":"1637","Store":"1001","Employee":"1053","SaleDate":"2004/9/25","TaxPercent":"14","SalesAmount":"108.87","TotalAmount":"124.1118"},{"SalesID":"1302","Customer":"1912","Store":"1004","Employee":"1098","SaleDate":"2004/9/26","TaxPercent":"14","SalesAmount":"173.7","TotalAmount":"198.018"},{"SalesID":"1303","Customer":"1800","Store":"1001","Employee":"1053","SaleDate":"2004/9/27","TaxPercent":"14","SalesAmount":"59.6606","TotalAmount":"68.0131"},{"SalesID":"1304","Customer":"1660","Store":"1006","Employee":"1128","SaleDate":"2004/9/28","TaxPercent":"0","SalesAmount":"60.97","TotalAmount":"60.97"},{"SalesID":"1305","Customer":"1901","Store":"1006","Employee":"1128","SaleDate":"2004/9/29","TaxPercent":"0","SalesAmount":"17.49","TotalAmount":"17.49"},{"SalesID":"1306","Customer":"1538","Store":"1003","Employee":"1083","SaleDate":"2004/9/29","TaxPercent":"14","SalesAmount":"228.02","TotalAmount":"259.9428"},{"SalesID":"1307","Customer":"1968","Store":"1002","Employee":"1068","SaleDate":"2004/10/1","TaxPercent":"6.5","SalesAmount":"57.93","TotalAmount":"61.6954"},{"SalesID":"1308","Customer":"1905","Store":"1005","Employee":"1113","SaleDate":"2004/10/1","TaxPercent":"14","SalesAmount":"275.3016","TotalAmount":"313.8438"},{"SalesID":"1309","Customer":"1694","Store":"1006","Employee":"1128","SaleDate":"2004/10/2","TaxPercent":"0","SalesAmount":"57.47","TotalAmount":"57.47"},{"SalesID":"1310","Customer":"1841","Store":"1004","Employee":"1098","SaleDate":"2004/10/4","TaxPercent":"14","SalesAmount":"264.48","TotalAmount":"301.5072"},{"SalesID":"1311","Customer":"1139","Store":"1001","Employee":"1053","SaleDate":"2004/10/4","TaxPercent":"14","SalesAmount":"171.67","TotalAmount":"195.7038"},{"SalesID":"1312","Customer":"1478","Store":"1000","Employee":"1038","SaleDate":"2004/10/5","TaxPercent":"0","SalesAmount":"206.31","TotalAmount":"206.31"},{"SalesID":"1313","Customer":"1924","Store":"1004","Employee":"1098","SaleDate":"2004/10/6","TaxPercent":"14","SalesAmount":"80.92","TotalAmount":"92.2488"},{"SalesID":"1314","Customer":"1298","Store":"1006","Employee":"1128","SaleDate":"2004/10/6","TaxPercent":"0","SalesAmount":"78.46","TotalAmount":"78.46"},{"SalesID":"1315","Customer":"1092","Store":"1005","Employee":"1113","SaleDate":"2004/10/7","TaxPercent":"14","SalesAmount":"134.85","TotalAmount":"153.729"},{"SalesID":"1316","Customer":"1701","Store":"1002","Employee":"1068","SaleDate":"2004/10/7","TaxPercent":"6.5","SalesAmount":"214.49","TotalAmount":"228.4318"},{"SalesID":"1317","Customer":"1668","Store":"1006","Employee":"1128","SaleDate":"2004/10/8","TaxPercent":"0","SalesAmount":"61.92","TotalAmount":"61.92"},{"SalesID":"1318","Customer":"1067","Store":"1001","Employee":"1053","SaleDate":"2004/10/9","TaxPercent":"14","SalesAmount":"299.942","TotalAmount":"341.9339"},{"SalesID":"1319","Customer":"1194","Store":"1004","Employee":"1098","SaleDate":"2004/10/10","TaxPercent":"14","SalesAmount":"161.7606","TotalAmount":"184.4071"},{"SalesID":"1320","Customer":"1595","Store":"1005","Employee":"1113","SaleDate":"2004/10/10","TaxPercent":"14","SalesAmount":"23.45","TotalAmount":"26.733"},{"SalesID":"1321","Customer":"1156","Store":"1002","Employee":"1068","SaleDate":"2004/10/10","TaxPercent":"6.5","SalesAmount":"98.37","TotalAmount":"104.764"},{"SalesID":"1322","Customer":"1152","Store":"1005","Employee":"1113","SaleDate":"2004/10/11","TaxPercent":"14","SalesAmount":"165.3","TotalAmount":"188.442"},{"SalesID":"1323","Customer":"1098","Store":"1004","Employee":"1098","SaleDate":"2004/10/11","TaxPercent":"14","SalesAmount":"163.68","TotalAmount":"186.5952"},{"SalesID":"1324","Customer":"1749","Store":"1006","Employee":"1128","SaleDate":"2004/10/13","TaxPercent":"0","SalesAmount":"45.002","TotalAmount":"45.002"},{"SalesID":"1325","Customer":"1248","Store":"1002","Employee":"1068","SaleDate":"2004/10/13","TaxPercent":"6.5","SalesAmount":"174.0225","TotalAmount":"185.334"},{"SalesID":"1326","Customer":"1601","Store":"1006","Employee":"1128","SaleDate":"2004/10/14","TaxPercent":"0","SalesAmount":"334.4965","TotalAmount":"334.4965"},{"SalesID":"1327","Customer":"1326","Store":"1002","Employee":"1068","SaleDate":"2004/10/15","TaxPercent":"6.5","SalesAmount":"193.8855","TotalAmount":"206.4881"},{"SalesID":"1328","Customer":"1850","Store":"1005","Employee":"1113","SaleDate":"2004/10/17","TaxPercent":"14","SalesAmount":"92.33","TotalAmount":"105.2562"},{"SalesID":"1329","Customer":"1211","Store":"1000","Employee":"1038","SaleDate":"2004/10/19","TaxPercent":"0","SalesAmount":"19.49","TotalAmount":"19.49"},{"SalesID":"1330","Customer":"1949","Store":"1005","Employee":"1113","SaleDate":"2004/10/19","TaxPercent":"14","SalesAmount":"286.7","TotalAmount":"326.838"},{"SalesID":"1331","Customer":"1579","Store":"1000","Employee":"1038","SaleDate":"2004/10/19","TaxPercent":"0","SalesAmount":"101.87","TotalAmount":"101.87"},{"SalesID":"1332","Customer":"1251","Store":"1001","Employee":"1053","SaleDate":"2004/10/20","TaxPercent":"14","SalesAmount":"232.71","TotalAmount":"265.2894"},{"SalesID":"1333","Customer":"1903","Store":"1002","Employee":"1068","SaleDate":"2004/10/20","TaxPercent":"6.5","SalesAmount":"169.29","TotalAmount":"180.2938"},{"SalesID":"1334","Customer":"1653","Store":"1005","Employee":"1113","SaleDate":"2004/10/21","TaxPercent":"14","SalesAmount":"294.8625","TotalAmount":"336.1432"},{"SalesID":"1335","Customer":"1563","Store":"1001","Employee":"1053","SaleDate":"2004/10/21","TaxPercent":"14","SalesAmount":"23.45","TotalAmount":"26.733"},{"SalesID":"1336","Customer":"1461","Store":"1004","Employee":"1098","SaleDate":"2004/10/22","TaxPercent":"14","SalesAmount":"182.16","TotalAmount":"207.6624"},{"SalesID":"1337","Customer":"1797","Store":"1003","Employee":"1083","SaleDate":"2004/10/24","TaxPercent":"14","SalesAmount":"66.35","TotalAmount":"75.639"},{"SalesID":"1338","Customer":"1683","Store":"1004","Employee":"1098","SaleDate":"2004/10/24","TaxPercent":"14","SalesAmount":"31.94","TotalAmount":"36.4116"},{"SalesID":"1339","Customer":"1035","Store":"1004","Employee":"1098","SaleDate":"2004/10/25","TaxPercent":"14","SalesAmount":"110.74","TotalAmount":"126.2436"},{"SalesID":"1340","Customer":"1693","Store":"1006","Employee":"1128","SaleDate":"2004/10/25","TaxPercent":"0","SalesAmount":"47.4","TotalAmount":"47.4"},{"SalesID":"1341","Customer":"1087","Store":"1005","Employee":"1113","SaleDate":"2004/10/26","TaxPercent":"14","SalesAmount":"100.87","TotalAmount":"114.9918"},{"SalesID":"1342","Customer":"1479","Store":"1001","Employee":"1053","SaleDate":"2004/10/28","TaxPercent":"14","SalesAmount":"187.57","TotalAmount":"213.8298"},{"SalesID":"1343","Customer":"1781","Store":"1001","Employee":"1053","SaleDate":"2004/10/28","TaxPercent":"14","SalesAmount":"207.82","TotalAmount":"236.9148"},{"SalesID":"1344","Customer":"1695","Store":"1004","Employee":"1098","SaleDate":"2004/10/28","TaxPercent":"14","SalesAmount":"49.7401","TotalAmount":"56.7037"}] ```

最終的には次の画像のようなレポートとなります。

  1. ページレポートを作成し、4つのTextBoxコントロールをデザイン面上にドラッグ＆ドロップします。**［値］**プロパティを次のように設定します。 |コントロール名|設定値| |---|---| |TextBox1|=Globals!ExecutionTime| |TextBox2|店舗：| |TextBox3|=Fields!Store.Value| |TextBox4|お世話になっております。貴方の昨年の販売合計は一覧のようになっております。どうぞご確認ください。ご不明な点は1-800-DNT-CALLまでご連絡いただきますようお願い申し上げます。|

  2. OverflowPlaceHolderコントロールをドラッグ＆ドロップし、**［プロパティ］**ウィンドウから以下のプロパティを設定します。 |プロパティ名|設定値| |---|---| |左|3.4in| |上|2.7in| |幅|3in| |高さ|5.6in|

  3. 同様に、Tableデータ領域をドラッグ＆ドロップし、次のプロパティを設定します。 |プロパティ名|設定値| |---|---| |データセット|ドロップダウンリストからデータセットを選択します。| |名前|OverflowPlaceHolder1| |左|0.2in| |上|2.7in| |幅|3in| |高さ|0.5in| |固定の幅|3in| |固定の高さ|5.6in|

  4. **［フィルタ］プロパティで、［項目の表示］をクリックし、［+ 項目の追加］**をクリックします。

  5. 表示される**［[A]=[B]］の隣にあるをクリックして、［フィルタのプロパティ］を表示します。［式］プロパティの隣にあるボタンをクリックしてフィールドのリストを表示し、「Store」**を選択します。

  6. **［演算子］プロパティの隣にあるドロップダウンを開き、「Equal」**を選択します。

  7. **［値］プロパティの隣にあるボタンをクリックし、［1002］**を入力します。

  8. 次のように、Tableデータ領域の詳細行のテキストボックスを**［SalesID］、［SaleDate］、および［TotalAmount］**のフィールドにバインドします。

  9. 2つのTextBoxコントロールをデザイン面上にドラッグ＆ドロップします。**［値］**プロパティを次のように設定します。 |コントロール名|設定値| |---|---| |TextBox1|合計| |TextBox2|=SUM(Fields!TotalAmount.Value)|

  10. レポートに配置する各コントロールのサイズや位置を調整して、レポートの外観をカスタマイズします。

  1. レポートをプレビューします。