Skip to main content

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV

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

Comments

Post a Comment

Popular posts from this blog

The Difference Between Microsoft Dynamics NAV and AX

The Difference Between Microsoft Dynamics NAV and AX Microsoft Dynamics offers a variety of ERP solutions. You might say there is a solution for every purpose and every industry. Two of the offerings,  Dynamics NAV  and  Dynamics AX (now part of  Dynamics 365 ) share some of the same features so you might wonder: ‘what are the differences and which is right for my organization?’ Both ERP solutions are highly customizable, available in and adaptable to many languages and currencies used around the world. The two solutions can also be employed in a central location or across diverse satellite locations and are designed to grow as a business grows. Their industry-specific functionality can assure compliance with local and regional requirements. In short, both solutions could rightly be described as comprehensive and well equipped to manage complex requirements of supply chain and inventory. So, what is the difference? Is one better than the other for your...
Post a Comment
Read more

Quick Fix Visual Studio displaying NAV Report Layout as XML

I got this issue with Visual Studio 2015 Enterprise Edition.  Every time I open a Dynamics NAV report layout in Visual Studio, RDLC is rendered as XML file instead of visual layout with all the fields and tool boxes.  How the report layout looks:  FIX : In order to fix the issue you need to install  "Microsoft SQL Server Data Tools" .  To install "Microsoft SQL Server Data Tools" you need to go to  Control Panel   ->  Programs and Features  - >  Microsoft Visual Studio <Edition>  -> Change Or you can re run the installation setup.  From the features list, enable "Microsoft SQL Server Data Tools" option and proceed.  Once the installation is completed you are good to go. This time report layout will open in correct design layout.  Hope this helps you to resolve the issue. happy designing.  Please provide your feedback with a comment.  Thank you and Regards, +256775120005 ...
Post a Comment
Read more

Office 365 integration in a Dynamics NAV hosting environment

Office 365 integration in a Dynamics NAV hosting environment We from the Microsoft Dynamics NAV support team (Microsoft CSS) see an increasing number of support cases coming in related to Office 365 integration in a hosting environment. This range from the relatively new Edit in Excel feature or the relatively new Outlook Business Inbox to the more familiar Office 365 Single Sign On functionality. This blog post is intended to help you to first discuss the requirements with your customer, it may also help you to understand the difficulties. It should be relatively easy to implement these capabiltities, but since there are so many external components that require different configuration setup, we may end up in high labor intense support cases where we need to put all pieces together. This blog post will hopefully serve as a guide where we summarize all relevant documentation that is out there. Finally, we will showcase a typical environment with several Azure AD’s amo...
Post a Comment
Read more