Microsoft レポートによ る ... - needtec.sakura.ne.jp

1 Microsoft Microsoft .NET Framework 2013/12/14 Microsoft 1 Microsoft Microsoft Visual Studio ReportViewer Microsoft XML Visual Studio ReportViewer Report Viewer Microsoft 2 Microsoft Excel Microsoft 3 Microsoft 4

2 Visual Studio 2005 Professional Express ReportViewer SQL Server Visual Studio2013 Professional SQL Server2012 Express SQL Server Management Studio(SSMS ) Microsoft 5 Microsoft VisualStudio2013 SQLSERVER2012 SQLSERVER : AdventureWorks SQLSERVER PC SQLSERVER AdventureWorks Sample Databases for the SQL Server 2012 Database Training Kit Microsoft 6 MDF SQLSERVER SQLSERVER C: Program Files Microsoft SQL Server MSSQL DATA SQLSERVER EXPRESS C.

3 Program Files Microsoft SQL Server MSSQL DATA MDF SQLS erver Management Studio SQLSERVER localhost Windows Express Localhost SQLEXPRESS MDF OK OK MDF Microsoft 7 REPORTVIEW ER : ReportViewer SQLSERVER C# WINDOWS Windows 1. Microsoft 8 2.

4 TableAdapter TableAdapter 3.[ ] [ ] 4. Microsoft 9 VisualStudio2008 SQLSERVER2012 VS2008 SQLSERVER2012 5. TableAdapter SQL SELECT , , AS TotalSales, , FROM AS E INNER JOIN AS C ON = INNER JOIN AS S ON = 6. Microsoft 10 1. 3.[ ] [ ] Microsoft 11 GUI XML 1.

5 DataSet1 OK Microsoft 12 2. Microsoft 13 3. 4. tablibn Size Width 5. ( ) ( ) LastName Microsoft 14 .. 1 Last Name Microsoft 15 =Fields! LastName ( )

6 OrderData,SalesOrderNumber TotalSales REPORTVIEWER ReportViewer ReportViewer ReportViewer Dock Fill Form Microsoft 16 ReportViewer ReportViewer Form Microsoft 17 Excel,PDF,Word Microsoft 18 OrderDate 1.

7 2. OK Microsoft 19 3. OrderDate Microsoft 20 4. TotalSales Microsoft 21 5. TotalSales 1. Microsoft 22 2. BackgroundColer 3. Color 4. Font Microsoft 23 5. BorderStyle 6. Microsoft 24 Microsoft 25 Height Microsoft 26 ReportViewer Microsoft 27

8 Today 2013/12/16 0:00:00 Microsoft 28 =Globals!PageNumber & "/" & Globals!TotalPages Microsoft 29 / (Visual Studio ) ( SSRS) Microsoft 30 ( ) ( )

9 RepeatOnNewPage True Microsoft 31 ReportViewer LastName FirstName LastName Microsoft 32 [LastName] LastName FirstName Microsoft 33 FirstName Microsoft 34 Microsoft 35 =Sum(Fields!)

10 =Fields! + " " + Fields! + ": " + vbCrLf + Microsoft 36 Count(Fields! ).ToString() LastName Microsoft 37 RepeatOnNewPage True KeepWIthGroup After Microsoft 38 RepeatOnNewPage True KeepWIthGroup After ReportViewer Microsoft 39