售 价:¥
温馨提示:数字商品不支持退换货,不提供源文件,不支持导出打印
为你推荐
Microsoft Dynamics NAV 7 Programming Cookbook
Table of Contents
Microsoft Dynamics NAV 7 Programming Cookbook
Credits
About the Author
About the Reviewers
Acknowledgements
www.PacktPub.com
Support files, eBooks, discount offers and more
Why Subscribe?
Free Access for Packt account holders
Instant Updates on New Packt Books
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Errata
Piracy
Questions
1. String, Dates, and Other Data Types
Introduction
Retrieving the system date and time
How to do it...
How it works...
There's more...
See also
Retrieving the work date
Getting ready
How to do it...
How it works...
There's more...
See also
Determining the day, month, and year from a given date
How to do it...
How it works...
There's more...
See also
Using the date formula to calculate dates
How to do it...
How it works...
There's more...
See also
Converting a value to a formatted string
How to do it...
How it works...
There's more...
See also
Creating an array
How to do it...
How it works...
There's more...
See also
Creating an option variable
How to do it...
How it works...
There's more...
See also
Converting a string to another data type
How to do it...
How it works...
There's more...
See also
Manipulating string contents
How to do it...
How it works...
There's more...
See also
2. General Development
Introduction
Displaying the progress bar and data in process
How to do it...
How it works...
There's more...
See also
Repeating code using a loop
How to do it...
How it works...
There's more...
Using a WHILE loop
Using a REPEAT..UNTIL loop
See also
Checking for conditions using an IF statement
How to do it...
How it works...
There's more...
The nested IF statement
See also
Using the CASE statement to test multiple conditions
How to do it...
How it works...
See also
Rounding decimal values
How to do it...
How it works...
See also
Creating functions
How to do it...
How it works...
There's more...
Creating local or private functions
See also
Passing parameters by reference
How to do it...
How it works...
There's more...
See also
Referencing dynamic tables and fields
How to do it...
How it works...
There's more...
See also
Using recursion
How to do it...
How it works...
There's more...
See also
3. Working with Tables, Records, and Queries
Introduction
Creating a table
How to do it...
How it works...
There's more...
See also
Adding a key to a table
How to do it...
How it works...
There's more...
See also
Retrieving data using the FIND and GET statements
How to do it...
How it works...
There's more...
See also
Advanced filtering
How to do it...
How it works...
There's more...
See also
Adding a FlowField
How to do it...
How it works...
There's more...
See also
Creating a SumIndexField
How to do it...
How it works...
There's more...
See also
Retrieving data from FlowField and SumIndexField
How to do it...
How it works...
There's more...
See also
Using a temporary table
How to do it...
How it works...
There's more...
Storing records to be processed
See also
Retrieving data from other companies
Getting ready…
How to do it...
How it works...
See also
Using a query to extract data
How to do it...
How it works...
There's more...
See also
Creating a query to link three tables
How to do it...
How it works...
There's more...
Left outer join
Inner join
Right outer join
Full outer join
Cross join
See also
Working with queries in C/AL
How to do it...
How it works...
There's more...
See also
4. Designing Pages
Introduction
Creating a page using a wizard
How to do it...
How it works...
There's more...
See also
Using multiple options to run the page
How to do it...
How it works...
There's more...
See also
Applying filters on the lookup page
How to do it...
How it works...
There's more...
See also
Updating the subform page from a parent page
How to do it...
How it works...
See also
Creating a FactBox page
How to do it...
How it works...
There's more...
See also
Creating a Queue page
How to do it...
How it works...
See also
Creating a Role Center page
How to do it...
How it works...
See also
Creating a wizard page
How to do it...
How it works...
See also
Displaying a .NET add-in on a page
Getting ready
How to do it...
How it works...
See also
Adding a chart to the page
How to do it...
How it works...
There's more...
See also
5. Report Design
Introduction
Creating an RDLC report
How to do it...
How it works...
There's more...
See also
Using multiple options to run a report
How to do it...
How it works...
See also
Adding custom filters to the Request Page
How to do it...
How it works...
There's more...
See also
Setting filters when report is loaded
How to do it...
How it works...
There's more...
See also
Creating reports to process data
How to do it...
How it works...
There's more...
See also
Creating a link from report to page
How to do it...
How it works...
There's more...
See also
Creating a link from report to report
How to do it...
How it works...
See also
Adding totals on decimal field
How to do it...
How it works...
See also
Adding interactive sorting on reports
How to do it...
How it works...
See also
Creating a matrix report
How to do it...
How it works...
There's more...
Exporting an RDLC report from viewer
Exporting an RDLC report from C/AL code
See also
6. Diagnosing Code Problems
Introduction
Using the debugger
How to do it...
How it works...
There's more...
See also
Setting breakpoints
How to do it...
How it works...
There's more...
Breakpoint options in the debugger
See also
Handling runtime errors
How to do it...
How it works...
There's more...
See also
Using About This Page and About This Report
How to do it...
About This Page
About This Report
How it works...
There's more...
How to get the subform information
See also
Finding errors while using NAS
Getting ready
How to do it...
How it works...
There's more...
See also
7. Roles and Security
Introduction
Assigning a role to a user
How to do it...
How it works...
There's more...
See also
Creating a new role
How to do it...
How it works...
There's more...
See also
Using the FILTERGROUP function
How to do it...
How it works...
See also
Using security filters
How to do it...
How it works...
There's more...
See also
Applying security filter modes
How to do it...
How it works...
There's more...
See also
Field-level security
How to do it...
How it works...
There's more...
See also
Assigning permission to use the About This Page function
How to do it...
How it works...
There's more...
About This Page for subform page
About This Page for report
See also
Killing a user session
How to do it…
How it works...
See also
8. Leveraging Microsoft Office
Introduction
Sending data to Microsoft Word
Getting ready
How to do it...
How it works...
There's more...
See also
Managing stylesheets
Getting ready
How to do it...
How it works...
Sending an e-mail from NAV through SMTP
Getting ready
How to do it...
How it works...
There's more...
Sending an HTML-formatted e-mail
Exporting data using the Excel Buffer
Getting ready
How to do it...
How it works...
There's more...
See also
Creating data connection from Excel to NAV
Getting ready
How to do it...
How it works...
There's more...
See also
Showing data in Excel using PowerPivot
Getting ready
How to do it...
How it works...
There's more...
See also
Creating an InfoPath form for the NAV data
Getting ready
How to do it...
How it works...
There's more...
See also
Creating charts with Visio
Getting ready
How to do it...
How it works...
There's more...
See also
9. OS Interaction
Introduction
Using HYPERLINK to open external files
How to do it...
How it works...
There's more...
See also
Working with environmental variables
How to do it...
How it works...
See also
Using SHELL to run external applications
How to do it...
How it works...
See also
Browsing for a file
How to do it...
How it works...
There's more...
See also
Browsing for a folder
How to do it...
How it works...
There's more...
See also
Checking file and folder access permissions
How to do it...
How it works...
See also
Querying the registry
How to do it...
How it works...
There's more...
See also
Zipping folders and files within NAV
How to do it...
How it works...
10. Integration
Introduction
Sharing information through XMLports
How to do it...
How it works...
There's more...
Exporting Sales Invoices in the CSV format
See also
Writing to and reading from a file using the C/AL code
How to do it...
How it works...
See also
Creating web services
How to do it...
How it works...
See also
Consuming web services
How to do it...
How it works...
See also
Sending data through FTP
Getting ready
How to do it...
How it works...
There's more...
See also
Printing a report in a PDF, Excel, and Word format
How to do it...
How it works...
See also
Writing your own automation using C#
How to do it...
How it works...
See also
Using ADO to access outside data
How to do it...
How it works...
11. Working with the SQL Server
Introduction
Creating a basic SQL query
How to do it...
How it works...
There's more...
See also
Understanding SIFT
How to do it...
How it works...
See also
Using the SQL profiler
How to do it...
How it works...
See also
Displaying data from a SQL view in NAV
How to do it...
How it works...
There's more...
See also
Identifying Blocked and Blocking sessions from SQL
How to do it...
How it works...
There's more...
See also
Setting up a backup plan
How to do it...
How it works...
There's more...
See also
Maintaining the transaction logfiles
Getting ready
How to do it...
How it works...
See also
12. NAV Server Administration
Introduction
Creating a NAV Server Instance
How to do it...
How it works...
There's more...
Using Microsoft Dynamics NAV Administration Shell
See also
Configuring NAS to run Job Queue
How to do it...
How it works...
There's more...
See also
Creating a user on NAV
How to do it...
How it works...
There's more...
See also
Changing the NAV license
How to do it...
How it works...
There's more...
See also
Creating a new database
How to do it...
How it works...
There's more...
See also
Testing the NAV database
How to do it...
How it works...
See also
Index
买过这本书的人还买过
读了这本书的人还在读
同类图书排行榜