Microsoft

Searching for Data in Microsoft Dynamics AX 2009: Part 1

by Erlend Dalen | December 2009 | BPEL Microsoft SOA Web Services

This article by Erlend Dalen, explains the different options to use when you need to search and retrieve a set of data from the database. It shows you how to create a query, how to create a view, and how to write different select statements.

In this article, you will learn about the different methods of retrieving data from the database. They are as follows:

  • Queries which are reusable and often used in reports and periodic Jobs
  • Views that are created in AOT and translated to optimized select statements at runtime
  • Select statements to use in X++ to fetch data from the database to the application
Read Searching for Data in Microsoft Dynamics AX 2009: Part 1 in full

Writing XML data to the File System with SSIS

by Jayaram Krishnaswamy | November 2009 | Microsoft

This article by Dr. Jayaram Krishnaswamy, shows how you may retrieve XML data from a relational database and write it to a folder on your file system as a text or xml file using Microsoft SQL Server Integration Services 2008. The following are the different steps involved in this EL process (there being no transformation):

  • Creating a stored procedure that retrieves XML
  • Creating a package in BIDS or Visual Studio 2008
  • Adding and configuring a ExecuteSQL task
  • Adding and configuring a Script task
  • Running the package and verifying the results
Read Writing XML data to the File System with SSIS in full

Venturing Beyond the Basics in MS Office Live Small Business

by Rahul Pitre | December 2009 | Beginner's Guides Microsoft Content Management e-Commerce

This article by Rahul Pitre, will help you try your hands at writing your own HTML mark up to tweak your site.How to install off-the-shelf components to enhance your website is the next skill you'll learn in this article. You'll install a custom FAQ component because the built-in FAQ page doesn't work as advertised.

In this article you will:

  • Add an HTML module to your page.
  • Write HTML in the HTML module. Chances are that you don't know a lot about HTML. So, you'll take a crash course on a small subset of HTML that will help you to get started with writing your own markup, if you so desire.
  • Perform some common page-building tasks such as embedding flash movies, PayPal buttons, and other such external content in your web pages using the HTML module.
  • Download and install an FAQ solution that renders a customized FAQ page.
Read Venturing Beyond the Basics in MS Office Live Small Business in full

Customizing Headers and Footers with MS Office Live Small Business

by Rahul Pitre | November 2009 | .NET Beginner's Guides Microsoft Content Management e-Commerce

In this article by Rahul Pitre you'll start using the design tools to personalize your site's headers and footers. You'll customize its name and slogan, and in the bargain put your distinctive stamp on your website.

In this article, you will:

  • Decide what your website's title should be, and set it in your template
  • Decide what your website's slogan should be, and set it in your template
  • Decide what information should go into your website's footer, and set it
Read Customizing Headers and Footers with MS Office Live Small Business in full

Report components in NAV 2009: Part 1

by David A. Studebaker | November 2009 | .NET Microsoft Open Source

In this article David Studebaker, we will review the components that make up reports. We'll look in detail at the triggers, properties, and controls that are part of NAV reports. We will study the Report Designer tools that are a combination of pure NAV (the C/SIDE Report Designer) and the Visual Studio Report Designer that is tightly integrated into NAV 2009. We'll create some reports with the Report Designer tools. We'll also modify a report or two using the Report Designer. We'll examine the data flow of a standard report and the concept of reports used for processing only (with no printed or displayed output).

Read Report components in NAV 2009: Part 1 in full
Syndicate content
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software