(ENU) Technical Inside NAV 5.00.01 incl. SQL Reporting Service

CONTENTS
CHAPTER 1 FOREWORD 6
About the author 7
Contents of this book 8
Sample-Files and Support 8
CHAPTER 2 THE NEW MICROSOFTT OUTLOOK INTEGRATION 9
2.1 Installation of MicrosoftT Outlook Integration 9
2.1.1 Software requirements 9
2.1.2 Hardware requirements 10
2.1.3 Installation of necessary components 10
2.1.4 Configuration of Application Server 12
2.2 Configuration and Setup of MicrosoftT Outlook Components 13
2.2.1 Menu structure in Microsoft DynamicsT NAV 15
2.2.2 MicrosoftT Outlook-Synch. Entities 15
2.2.3 Case Study Contacts 16
2.2.4 MicrosoftT Outlook Synch. User Setup 19
2.3 MicrosoftT Outlook Integration and Customizing 23
2.3.1 Creating Outlook Units 23
2.3.2 Fields of the type "Option" 27
2.3.3 Entities and Users 29
2.3.4 Setting up in MicrosoftT Outlook 30
2.3.5 Creating your own Microsoft DynamicsT NAV Homepage 32
2.4 Best Practice and Error Analysis 38
CHAPTER 3 XML STYLESHEETS AND MICROSOFTT OFFICE 41
CHAPTER 4 NEWS IN C/SIDE - C/AL 47
4.1 New C/AL Commands - ERRORHANDLING 47
4.2 New C/AL Commands - APPLICATIONPATH 49
4.3 New C/AL Commands - TEMPORARYPATH 49
4.4 New Attributes in Forms - SOURCETABLETEMPORARY 49
4.5 New C/AL Commands - SMTP Codeunit 51
4.6 New C/AL Commands - RECORD LINKS 52
4.6.1 Best Practice - LINKS Functions 53
4.7 General News in C/AL 55
4.7.1 New C/AL Commands 56
4.7.2 New System tables 56
4.7.3 New Database tables 57
4.7.4 Deleted Tables 60
4.7.5 New Codeunits 63
CHAPTER 5 REPORTING SERVICES IN MICROSOFTT DYNAMICS NAV 68
5.1 REPORTING SERVICES - THE CONCEPT 69
5.1.1 SQL Server 2005 Editions 73
5.2 My first Reporting Services Report with Microsoft DynamicsT NAV 79
Reporting Services 81
5.2.1 Preview of my first Reporting Services Report 87
5.3 Extend the Report with a Chart 88
5.4 Extended Report Options 93
5.4.1. Combining Columns (Expressions) 93
5.4.2 Grouping data 94
5.4.3 Using Drill Down for interactive Previews 96
5.4.4 Extending the query with a second Table 97
5.4.5 Navigation with Drill Through 100
5.4.6. Set relation between the Reports with Drill- Through 102
5.5 Toolbox and Control Elements 103
5. 6 RDL Report Definition Language 104
5.6.1 RDL in Microsoft DynamicsT NAV 105
5.7 Reporting Services and Microsoft DynamicsT NAV Advanced 116
5.7.1 MLCaption from Microsoft DynamicsT NAV 116
5.7.2 Reporting Services (MicrosoftT SQL Server) and SIFT Technology 117
5.8 Deployment - Reporting Services Reports 128
5.8.1 Deploy Reports on the Report Server 128
5.8.2 Providing Reports in Microsoft DynamicsT NAV 129
5.9 Summary Reporting Services with Microsoft DynamicsT NAV 130
CHAPTER 6 MICROSOFT DYNAMICS NAV 5.00.01 - SERVICE PACK 1 131
6.1 Indexed Views 132
6.1.1 Indexed Views - Name and Definition 134
6.1.2 Indexed Views with Reporting Services 135
6.2 Bulk Insert 137
6.3 General Improvements and Enhancements 138
6.3.1 Financial Management 139
6.3.2 Purchase 139
6.3.4 Sales 140
Summary 141
6.4 Microsoft Dynamics NAV Mobile 142
APPENDIX A SYSTEM REQUIREMENTS 145
APPENDIX B XML PORT REPORT DEFINITION LANGUAGE 148