mibuso.com

Microsoft Dynamics NAV Style Sheet Tool v1.0
The Style Sheet feature in Microsoft Dynamics NAV 5.0 has been enhanced with a new tool that allows you to easily and without programming knowledge create and modify style sheets in Microsoft® Office Word.

The release of Microsoft Dynamics NAV 5.0 introduced the option to export any form (apart from matrix forms) from Microsoft Dynamics NAV to Microsoft Office® Word and Excel®. By simply clicking a button, Microsoft Dynamics NAV will generate an XML document that works in conjunction with an XML style sheet that passes the requested information to either Word or Excel.

Seven style sheets are included in Microsoft Dynamics NAV. You can read about these in the White Paper ‘Creating XML Style Sheets for Data Export from Microsoft Dynamics NAV 5.0’. However, if you want to create more style sheets or modify an existing one, you need to have knowledge of XML and C/AL programming in order to add the relevant data elements.

To simplify this process, a style sheet tool has been created that does not require programming knowledge. The first version of this tool will support the export of data to Word, and this means that the only skill required to create additional style sheets is some end-user knowledge of Word.

The Microsoft Dynamics NAV Stylesheet Tool supports integration to Microsoft Word 2003 and Microsoft Word 2007.
It consists of a fob file and a user guide.

Note: To be able to use the tool, a license update is required.

http://www.mibuso.com/dlinfo.asp?FileID=869

Discuss this download here.

Great, it seams very nice, however i have got a quesstion. Maybe I am missing something. It seams that Table Relationships work only for the "Base Table". For instance if you want to create a template for Sales order you can attach the Customer Table to the Header and get Customer's Info but i could not find a way to attach the Item table to the lines to get Item information. Am I missing something?

Does anyone knows how to export pictures to these templates?

Example, Company LOGO or Item Pictures?

Hi wwestendorp

did you find out how to export Item Pictures?


Or does anybody else know how to do that?
It would be really great if someone could tell me how to export pictures.

Hi,

How can I make a link with some tables.

Example :

Item Card with :
table for sales prices
table for purch prices
Comment

When I do this, only the first table is multi-line. The others don't work.

I use the tool to make a exerise for item card. But when click "Send Option" and select the "item card", and click "Send", I only see the origin mail merge. the tag still on document. and does not change to the real item data. Can anyone tell me whick step should I notice?

If I understood you correctly you followed all the steps in the guide to create style sheet, but instead of a Word document with item data, you got a Word document with the original merge fields?

I've seen something like that happen on rare occasions, but when trying to reproduce it just doesn't wan't to do it.

One way I've solved it myself, was to export the definition and merge docs, delete the definition in NAV, and then re-import the documents and have the system generate a new style sheet - this seems to work . . .

What's even more funny is that if you the delete the item defintion in the system and try to do exactly the same steps as when you originally created the first definition - the error does not show up!!??

Hope this helps.

You just have to add the picture to the word document the normal way
As the normal way I mean as described in the whitepaper
LnZ

Microsoft Dynamics NAV Style Sheet Tool v1.1
The Style Sheet feature in Microsoft Dynamics NAV 5.0 has been enhanced with a new tool that allows you to easily and without programming knowledge create and modify style sheets in Microsoft® Office Word.

The release of Microsoft Dynamics NAV 5.0 introduced the option to export any form (apart from matrix forms) from Microsoft Dynamics NAV to Microsoft Office® Word and Excel®. By simply clicking a button, Microsoft Dynamics NAV will generate an XML document that works in conjunction with an XML style sheet that passes the requested information to either Word or Excel.

Seven style sheets are included in Microsoft Dynamics NAV. You can read about these in the White Paper ‘Creating XML Style Sheets for Data Export from Microsoft Dynamics NAV 5.0’. However, if you want to create more style sheets or modify an existing one, you need to have knowledge of XML and C/AL programming in order to add the relevant data elements.

To simplify this process, a style sheet tool has been created that does not require programming knowledge. The first version of this tool will support the export of data to Word, and this means that the only skill required to create additional style sheets is some end-user knowledge of Word.

The Microsoft Dynamics NAV Stylesheet Tool supports integration to Microsoft Word 2003 and Microsoft Word 2007.
It consists of a fob file and a user guide.

Note: To be able to use the tool, a license update is required.


The following issues have been corrected in version 1.1:

- If a Header or Footer was specified, the Style Sheet Tool ignored them.
- If a long option strings was defined for a field, the user received a text overflow error message.
- When changing local languages, the Style Sheet tool only looked for a '.' instead of the local language decimal separator.
- When you create the mail merge document, the Style Sheet Tool would ignore the landscape orientation.
- If you have created a table relationship and the value being looked up doesn't exist, the style sheet won't load. If you close down NAV then you would get an error indicating that the value couldn't be found.
- When using page numbers (page x of y), then all pages come out as page 1 of 1

http://www.mibuso.com/dlinfo.asp?FileID=869

Discuss this download here.

Hi,

what does "Note: To be able to use the tool, a license update is required." excatly mean? I know how to update a license, but do I have do pay for it in this case?

Cheers,
Bob


edit: It's free.

It uses new objects, so the customer license need to be updated (for free).

I'm using Style Sheet Tool v1.1 (StyleSheetToolW111.fob dated 10/29/07)

Relates to replies in this thread from
SRAD750


and

zeninoleg


Also relates to another similar topic with subject:"Multiple multi lines in style sheets" http://mibuso.com/forum/viewtopic.php?t=23007&start=0&postdays=0&postorder=asc&highlight=style+sheet&sid=76729974b89d6c5e5a0e74c7514d366f

I've debugged and diagnosed the reason. NAV incorrectly creates a beginning TR tag(beginning of table) and ending TR tag(End of table) when building the XML node for the table. It does not account for two tables within a single style sheet. So the result is a table with a begining TR and ending TR with the end of the first table and begining of the second sandwiched in as text.

Workaround is to modify the XML. You need to create a style sheet with table 1 as you would normally. I'll call this "MAIN". Create the second table as a basic empty table with no merge fields. Save it. Then create another style sheet with just the second table formatted the way you want. I'll call this one "Second Table". Save it, then open (xslt file) in XML editor. Copy the table node from "Second Table" and paste it over the table node in "MAIN". Save.

This solution would need to be duplicated every time the Style Sheet is modified via Word, which is what the client will no doubt use. Not a great solution unless you have a style sheet that doesn't change often and you have someone willing to get their hands dirty doing a little XML editing.

Hopefully, MS will fix this issue in coming releases of the Style Sheet toolkit.

I have some problems with Microsoft Dynamics NAV Style Sheet Tool v1.1
I have used it for export sales quote on Ms Word.

I have created some table relation to a new table ( > 50000 - MyTableName) but when exporting the fields are not recalculated for this table - it comes : «RELATION_MyTableName» and not the value. The others relations to standard tables work... Is that normal? Is there some work around?


Thank you very much

The other problem is that if I insert a MergeField in Page Footer - for example: «Sales_Header_No», it comes updated when I have the Word Document on screen but when I make a print preview of a print on printer it shows the variable name «Sales_Header_No» and not the value of Document No.
The same merge field out from page footer is printed correctly.

Thank you very much

I have the same problem with multiline tab, only the first multiline tab is show..
I've test your solution but what .xslt file I have to modify ?