Microsoft Forum 2016, 19 Aprile 2016, FieraMilanoCity


Microsoft Forum

Microsoft Forum 2016, 19 Aprile 2016, FieraMilanoCity

“AccelerateYourBusiness”: a “Microsoft Forumla tecnologia incontra il business.  Scopri le soluzioni di Microsoft e dei suoi Partner. Diventa protagonista, oggi.

Microsoft Forum 2016  http://www.microsoftforum.it

Iscrizioni: https://www.microsoftevents.com/profile/form/index.cfm?PKformID=0x103893e0fa

Advertisements

Directions EMEA 2016, The Biggest NAV event, Prague


emed 2016.png
Directions EMEA 2016, The Biggest NAV event, Prague
Directions EMEA 2016 will take place in Prague, October 12-14, 2016.
You can register by clicking REGISTER NOW. At registration, you will be requested to enter your Microsoft Voice ID.

Cumulative Update 4 for Microsoft Dynamics NAV 2016 has been released


Cumulative Update 4 for Microsoft Dynamics NAV 2016 has been released

3139364  https://support.microsoft.com/kb/3139364

Source: Cumulative Update 4 for Microsoft Dynamics NAV 2016 has been released | Dynamics NAV Team Blog

Released Cumulative Updates for Microsoft Dynamics NAV 2016 – ALL Updates

https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?scid=kb,en-us,3108728

Cumulative Updates for Microsoft Dynamics NAV 2016  (Partnersource\Customersource Login required)

Knowledge

Base ID

Title Release date Build no. Local versions included
3139364  (https://support.microsoft.com/kb/3139364/ ) Cumulative update 4 for Microsoft Dynamics NAV 2016 February, 2016 44974 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3130298  (https://support.microsoft.com/kb/3130298/ ) Cumulative update 3 for Microsoft Dynamics NAV 2016 January, 2016 44365 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3121038  (https://support.microsoft.com/kb/3121038/ ) Cumulative update 2 for Microsoft Dynamics NAV 2016 December, 2015 43897 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3106089  (https://support.microsoft.com/kb/3106089/ ) Cumulative Update 1 for Microsoft Dynamics NAV 2016 November, 2015 43402 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK

Connecting Dynamics NAV 2013/2015 to the NAV content pack in PowerBI.com


Suvidha-blogpost

PowerBI.com has a Dynamics NAV content pack which connects to Dynamics NAV 2016 out of the box. I’ve discussed about it here.

Customers using NAV 2013 or NAV 2015 can also connect to this NAV Content pack in powerbi.com.

View original post 342 altre parole

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV


…nice reporting functions are available from NAV 2015:  EX: RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS

MY BEST FUCTION IS:  “RUNREQUESTPAGE” -> This function lets you run a request page for a report, without actually running the report. When the user clicks OK, the function simply returns a text value, which is an XML document describing the user’s selection and filters of the request page.”; you can use this function also to schedule a report on Job Queue (OnDemand report schedule)

ex: a reports launcher page, scope of this page is run selected reports and generate PDF files after reports printing (or after preview mode report printing)

laucnher

The system use fiunction REPORT.RUNREQUESTPAGE to read and retrieve reports parameters

RUNREQUESTPAGE

XmlParameters:= REPORT.RUNREQUESTPAGE(intIDReport);

… after you get the following XML document as a result:

xml.png

EXECUTE

Now is time to run report with EXECUTE function. This function runs a report without showing a request page. It receives the parameters as an argument of type text, and you can feed the results of the RUNREQUESTPAGE to it. If the report you are executing is a processing-only report, then it will simply silently execute. If it’s a printable report, then it runs in the preview mode.

SAVEAS

SAVEAS function: “It does the same as SAVEASXML, SAVEASPDF, SAVEASEXCEL, and SAVEASWORD, only it does it without showing the request page”.

SOME EXAMPLES:

REPORT.RUNREQUESTPAGE

XmlParameters:= REPORT.RUNREQUESTPAGE(intIDReport);

// Use the REPORT.SAVEAS function to save the report as a PDF file

REPORT.SAVEAS (intIDReport,XmlParameters,REPORTFORMAT::Pdf,OStream);

// Use the REPORT.EXECUTE function to preview the report

REPORT.EXECUTE (intIDReport,XmlParameters);

// Use the REPORT.Print function to print the report

REPORT.PRINT (intIDReport,XmlParameters);

DEMO FUNCTION: “SaveReportPDF”

SaveReportPDF (intIDReport : Integer;txtNomeFile : Text;blnPreview : Boolean;blnPrint : Boolean;blnSavePDF : Boolean;txtPath : Text)

//DEMO .sn

// Use the REPORT.RUNREQUESTPAGE function to run the request page to get report   parameters

CLEAR(XmlParameters);

XmlParameters := REPORT.RUNREQUESTPAGE(intIDReport);

CurrentUser := USERID;

// Use the REPORT.SAVEAS function to save the report as a PDF file

IF blnSavePDF THEN

BEGIN

Content.CREATE(txtPath + txtNomeFile+DELCHR(FORMAT(CURRENTDATETIME,0,'<Day,2>-<Month,2>-<Year> <Hours24>.<Minutes,2>.<Seconds,2>’),’=’,’-:/. ‘)+’.pdf’);

Content.CREATEOUTSTREAM(OStream);

REPORT.SAVEAS(intIDReport,XmlParameters,REPORTFORMAT::Pdf,OStream);

Content.CLOSE;

MESSAGE(‘PDF File written > OK’);

END;

// Use the REPORT.EXECUTE function to preview the report

IF blnPreview THEN

REPORT.EXECUTE(intIDReport,XmlParameters);

// Use the REPORT.Print function to print the report

IF blnPrint THEN

REPORT.PRINT(intIDReport,XmlParameters);

//DEMO .en