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

OverflowPlaceHolder

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




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

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

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

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

主なプロパティ

共通

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

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

位置とサイズ

  • 左： コンテナを基準としたレポートアイテムの左上端の位置。

  • 上： コンテナを基準としたレポートアイテムの左上端の位置。

  • 幅： レポートアイテムのサイズ。

  • 高さ： レポートアイテムのサイズ。

レイアウト

  • レイヤー名： 含まれるレイヤーの名前。

使用例

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


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

データソース

[
	{"SalesID":"1000","Customer":"1199","Store":"1002","Employee":"1060","SaleDate":"2004/1/1","TaxPercent":"6.5","SalesAmount":"172.1703","TotalAmount":"183.3614"},
	{"SalesID":"1007","Customer":"1460","Store":"1002","Employee":"1068","SaleDate":"2004/1/9","TaxPercent":"6.5","SalesAmount":"113.8275","TotalAmount":"121.2263"},
	{"SalesID":"1013","Customer":"1839","Store":"1000","Employee":"1038","SaleDate":"2004/1/15","TaxPercent":"0","SalesAmount":"157.27","TotalAmount":"157.27"},
	{"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":"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":"1033","Customer":"1743","Store":"1000","Employee":"1038","SaleDate":"2004/2/2","TaxPercent":"0","SalesAmount":"41.642","TotalAmount":"41.642"},
	{"SalesID":"1035","Customer":"1597","Store":"1002","Employee":"1068","SaleDate":"2004/2/5","TaxPercent":"6.5","SalesAmount":"21.45","TotalAmount":"22.8442"},
	{"SalesID":"1040","Customer":"1398","Store":"1002","Employee":"1068","SaleDate":"2004/2/8","TaxPercent":"6.5","SalesAmount":"186.63","TotalAmount":"198.761"},
	{"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":"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":"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":"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":"1074","Customer":"1264","Store":"1000","Employee":"1038","SaleDate":"2004/3/16","TaxPercent":"0","SalesAmount":"74.92","TotalAmount":"74.92"},
	{"SalesID":"1077","Customer":"1972","Store":"1000","Employee":"1038","SaleDate":"2004/3/19","TaxPercent":"0","SalesAmount":"150.8975","TotalAmount":"150.8975"},
	{"SalesID":"1079","Customer":"1295","Store":"1000","Employee":"1038","SaleDate":"2004/3/20","TaxPercent":"0","SalesAmount":"179.21","TotalAmount":"179.21"},
	{"SalesID":"1088","Customer":"1279","Store":"1001","Employee":"1053","SaleDate":"2004/3/29","TaxPercent":"14","SalesAmount":"266.46","TotalAmount":"303.7644"},
	{"SalesID":"1090","Customer":"1504","Store":"1000","Employee":"1038","SaleDate":"2004/3/30","TaxPercent":"0","SalesAmount":"244.21","TotalAmount":"244.21"},
	{"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":"1100","Customer":"1042","Store":"1000","Employee":"1038","SaleDate":"2004/4/12","TaxPercent":"0","SalesAmount":"172.3265","TotalAmount":"172.3265"},
	{"SalesID":"1103","Customer":"1931","Store":"1000","Employee":"1038","SaleDate":"2004/4/16","TaxPercent":"0","SalesAmount":"279.12","TotalAmount":"279.12"},
	{"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":"1110","Customer":"1222","Store":"1002","Employee":"1068","SaleDate":"2004/4/21","TaxPercent":"6.5","SalesAmount":"190.08","TotalAmount":"202.4352"},
	{"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":"1126","Customer":"1126","Store":"1002","Employee":"1068","SaleDate":"2004/5/2","TaxPercent":"6.5","SalesAmount":"111.78","TotalAmount":"119.0457"},
	{"SalesID":"1129","Customer":"1074","Store":"1001","Employee":"1053","SaleDate":"2004/5/4","TaxPercent":"14","SalesAmount":"231.17","TotalAmount":"263.5338"},
	{"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":"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":"1141","Customer":"1738","Store":"1002","Employee":"1068","SaleDate":"2004/5/16","TaxPercent":"6.5","SalesAmount":"203.74","TotalAmount":"216.9831"},
	{"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":"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":"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":"1161","Customer":"1498","Store":"1000","Employee":"1038","SaleDate":"2004/6/2","TaxPercent":"0","SalesAmount":"247.7604","TotalAmount":"247.7604"},
	{"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":"1171","Customer":"1393","Store":"1000","Employee":"1038","SaleDate":"2004/6/9","TaxPercent":"0","SalesAmount":"189.25","TotalAmount":"189.25"},
	{"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":"1182","Customer":"1132","Store":"1002","Employee":"1068","SaleDate":"2004/6/19","TaxPercent":"6.5","SalesAmount":"98.2055","TotalAmount":"104.5889"},
	{"SalesID":"1185","Customer":"1991","Store":"1000","Employee":"1038","SaleDate":"2004/6/21","TaxPercent":"0","SalesAmount":"316.07","TotalAmount":"316.07"},
	{"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":"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":"1197","Customer":"1468","Store":"1000","Employee":"1038","SaleDate":"2004/7/2","TaxPercent":"0","SalesAmount":"176.63","TotalAmount":"176.63"},
	{"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":"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":"1206","Customer":"1410","Store":"1002","Employee":"1068","SaleDate":"2004/7/10","TaxPercent":"6.5","SalesAmount":"36.9","TotalAmount":"39.2985"},
	{"SalesID":"1211","Customer":"1088","Store":"1000","Employee":"1038","SaleDate":"2004/7/13","TaxPercent":"0","SalesAmount":"105.4","TotalAmount":"105.4"},
	{"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":"1218","Customer":"1338","Store":"1001","Employee":"1053","SaleDate":"2004/7/22","TaxPercent":"14","SalesAmount":"204.0251","TotalAmount":"232.5886"},
	{"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":"1227","Customer":"1244","Store":"1000","Employee":"1038","SaleDate":"2004/7/30","TaxPercent":"0","SalesAmount":"300.23","TotalAmount":"300.23"},
	{"SalesID":"1229","Customer":"1579","Store":"1000","Employee":"1038","SaleDate":"2004/7/31","TaxPercent":"0","SalesAmount":"156.69","TotalAmount":"156.69"},
	{"SalesID":"1231","Customer":"1076","Store":"1002","Employee":"1068","SaleDate":"2004/8/2","TaxPercent":"6.5","SalesAmount":"236.8635","TotalAmount":"252.2596"},
	{"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":"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":"1245","Customer":"1531","Store":"1000","Employee":"1038","SaleDate":"2004/8/11","TaxPercent":"0","SalesAmount":"182.17","TotalAmount":"182.17"},
	{"SalesID":"1247","Customer":"1597","Store":"1002","Employee":"1068","SaleDate":"2004/8/12","TaxPercent":"6.5","SalesAmount":"19.95","TotalAmount":"21.2468"},
	{"SalesID":"1251","Customer":"1305","Store":"1001","Employee":"1053","SaleDate":"2004/8/16","TaxPercent":"14","SalesAmount":"239.43","TotalAmount":"272.9502"},
	{"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":"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":"1265","Customer":"1706","Store":"1000","Employee":"1038","SaleDate":"2004/8/30","TaxPercent":"0","SalesAmount":"58.39","TotalAmount":"58.39"},
	{"SalesID":"1267","Customer":"1566","Store":"1000","Employee":"1038","SaleDate":"2004/9/1","TaxPercent":"0","SalesAmount":"120.6659","TotalAmount":"120.6659"},
	{"SalesID":"1270","Customer":"1096","Store":"1002","Employee":"1068","SaleDate":"2004/9/2","TaxPercent":"6.5","SalesAmount":"252.68","TotalAmount":"269.1042"},
	{"SalesID":"1272","Customer":"1762","Store":"1001","Employee":"1053","SaleDate":"2004/9/4","TaxPercent":"14","SalesAmount":"98.32","TotalAmount":"112.0848"},
	{"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":"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":"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":"1292","Customer":"1868","Store":"1001","Employee":"1053","SaleDate":"2004/9/15","TaxPercent":"14","SalesAmount":"81.88","TotalAmount":"93.3432"},
	{"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":"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":"1303","Customer":"1800","Store":"1001","Employee":"1053","SaleDate":"2004/9/27","TaxPercent":"14","SalesAmount":"59.6606","TotalAmount":"68.0131"},
	{"SalesID":"1307","Customer":"1968","Store":"1002","Employee":"1068","SaleDate":"2004/10/1","TaxPercent":"6.5","SalesAmount":"57.93","TotalAmount":"61.6954"},
	{"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":"1316","Customer":"1701","Store":"1002","Employee":"1068","SaleDate":"2004/10/7","TaxPercent":"6.5","SalesAmount":"214.49","TotalAmount":"228.4318"},
	{"SalesID":"1318","Customer":"1067","Store":"1001","Employee":"1053","SaleDate":"2004/10/9","TaxPercent":"14","SalesAmount":"299.942","TotalAmount":"341.9339"},
	{"SalesID":"1321","Customer":"1156","Store":"1002","Employee":"1068","SaleDate":"2004/10/10","TaxPercent":"6.5","SalesAmount":"98.37","TotalAmount":"104.764"},
	{"SalesID":"1325","Customer":"1248","Store":"1002","Employee":"1068","SaleDate":"2004/10/13","TaxPercent":"6.5","SalesAmount":"174.0225","TotalAmount":"185.334"},
	{"SalesID":"1327","Customer":"1326","Store":"1002","Employee":"1068","SaleDate":"2004/10/15","TaxPercent":"6.5","SalesAmount":"193.8855","TotalAmount":"206.4881"},
	{"SalesID":"1329","Customer":"1211","Store":"1000","Employee":"1038","SaleDate":"2004/10/19","TaxPercent":"0","SalesAmount":"19.49","TotalAmount":"19.49"},
	{"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":"1335","Customer":"1563","Store":"1001","Employee":"1053","SaleDate":"2004/10/21","TaxPercent":"14","SalesAmount":"23.45","TotalAmount":"26.733"},
	{"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"}
]

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



  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. レポートをプレビューします。