Using the style sheet tool

NAV has built-in functionality to send data to outside applications like Word and Excel. They allow you to view data on a style sheet which can make it look much better than just a black-and-white report. This recipe will show you how to create these style sheets using a tool within NAV.

Getting ready

Download and install the Style Sheet Tool version 2.0 (links can be found in the There's More section). Run the Style Sheet setup and form and if you are using the RTC, fill out the RoleTailored Client tab.

How to do it...

1. Run the Style Sheet Card form from Object Designer.

2. Create a new record and fill in these fields with the following values:

   Field	Value
   Code	CUSTLIST
   Description	Customer List Style Sheet
   Form No.	22
   Page No.	22

3. Add a line with the following values:

   Field	Value
   Table No.	18
   Base Record	Yes
   Multiple Lines	Yes

4. Click on the Style Sheet button, then Select Fields.

5. Add lines with the following values:

   Field No.	Field Name	Include Caption...