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
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.
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
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
In this article by David Studebaker, we will review different types of reports and 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.
Some consider the library of reports, provided as part of the standard NAV product distribution from Microsoft, to be relatively simple in design and limited in its features. Other people feel that the provided reports satisfy most needs because they are simple. Their basic structure is easy to use, and made much more powerful and flexible through the multiplier of NAV's filtering and SIFT capabilities. Some say that the simplicity of the standard product provides more opportunities for creative enhancement.
The fact remains that NAV's standard reports are basic. In order to obtain more complex or more sophisticated reports, we must use the Report Designer features that are part of the product. Through creative use of these features, many different types of complex report logic may be implemented. You can also use NAV reports to feed processed data to other reporting tools such as Excel or "third-party" reporting products.Read NAV 2009: Reports in full