RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

NAV 2015 Word Layout Reporting Tips

Word Layout Vs RDL Layout Structure

Now you can create (example for a new report) only the Word Layout Structure and not RDL Layout, also you can create a RDL report structure on Sql Reporting and after import in Report structure;

You can also use linked subreports on rdl report layout (if necessary) and use in your rdlc report like standard reporting services, you need report viewer 2014 to display rdl layout.

Report Personalizations

You can define default report layout and after personalize your reports layouts with Modify, Import & Export features.


Office Templates for Your Reports

You can download many word reports templates directly from "OfficeOnline" Word templates and use it as new Word Layout, you only need to select fields from XML fields Repositorys and drag&drop on layout.

https://store.office.live.com/templates  -> you can save the word template to CLoud "OneDrive" or on your desktop.

ex: ScheduleTemplatesWord.docx (Word free Template  for Appointments, like this); you can plan resources activities using NAV Jobs & Projects resourse planning & after compile this module for week appointments using word grid part linecycle component (simulating a simple project portfolio resource load)

i try to Change (duplicate Always !!) standard report 1006 Job Planning Lines that is a good dataset starting point for this kinds of reports..

..after some dataset modifications, some global variables for calculations, more drag&drop & report controls positioning activities... we can have a word report layout like this...

ASSEGNAZIONI SETTIMANALI (RESOURCE WEEK ASSIGNEMENTS) 


NOME: 

ROBERTO STEFANETTI 

MESE: 

OCTOBER 

ANNO: 

2014 

 WEEK LOAD   DAYS  06/10..10/10    M10,  Y2014

 

DATE 

 PRIMARY ACTIVITY  

ACTIVITY 2 

ACTIVITY 3 

ACTIVITY 4 

ACTIVITY 5 

TOTAL TIME SCHEDULE 

Lun

06/10 

 JOB14-0002

 ABSENCE







 

 4 (4+0)

Mar 

07/10 

 JOB14-0017

 JOB14-0004

 

 

 

 8 (8)

Mer 

08/10 

 JOB14-0017

 JOB14-0002

 JOB14-0011

 JOB14-0024

 

 10 (4+4+2)

Gio 

09/10 

 JOB14-0006

 JOB14-0017

 

 

 

 8 (4+4)

Ven 

10/10 

 NOT ASSIG - TBD

 

 

 

 

 0

... is only an example !!!! ... but with simple & clear layout !


Dataset &  XML Parts

Word report layouts are based on word custom XML parts that will dynamically map a report dataset into a report at runtime mode 

Limitations: Word 2013 ... visibility & some conditions are not supported, number formatting limitations

Categoria: Dynamics NAV 2015
venerdì, 03 ott 2014 Ore. 22.37

Messaggi collegati


Statistiche
  • Views Home Page: 451.244
  • Views Posts: 863.650
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003