In People
Tools version 8.49 and earlier, XMLP generates
reports with some random names. There is no delivered option for the
user/developer to specify desired output report name. However, this can be
achieved easily by tweaking the code in the Application Package - PSXP_RPTDEFNMANAGER,
Class -ReportDefn, Method - ProcessReport
Below is the code
for the 'method ProcessReport' with the changes highlighted in red:
Ø In the method declaration, add one additional parameter for setting
up the report name as shown below:method ProcessReport(&TemplateID As string, &LanguageCd As string, &AsOfDate As date, &OutputFormat As string, &sCustomRptName As string);
Ø In the method definition, include the below shown code changes:
method ProcessReport
---
CreateDirectory(&sOutputDir | &sDirSep | "RptInst" | &sDirSep | String(&i), %FilePath_Absolute);
/*This code is to generate the report with a custom name */
If %This.UseBurstValueAsOutputFileName Then
&sOutFileName = &sBurstValue | &sCustomRptName;
Else
&sOutFileName = &ID;
End-If;
----
&oReportOut = create XX_RPTDEFN:ReportOutput(&sBurstValue, String(&i), &sOutFileName | "." | Lower(&sFileExt), &sBurstDataFile);
&arOutput.Push(&oReportOut);
End-For;
End-If;
Else
/*******Include report name here if you want to change******/
If &sCustomRptName <> " " Then
&ID = &sCustomRptName;
End-If;
&sLocalOutputFile = %This.GetLocalOutputFile(&ID | "." | Lower(&sFileExt), "", 1);
----
end-method;
Below is the sample code to generate the
XMLP report where 'method ProcessReport' is invoked with additional parameter:
&CustomRptName_prefix
= "User Report";&ReportDef.ProcessReport(&sTemplateId, "ENG", %Date, &OutputFmt, &CustomRptName_prefix);
&ReportDef.publish("", "", "", 0);
We implemented this at one of our customer site. It is tested and works fine. We recommend you to test it with various options.
In PeopleTools
Version 8.50 and later, PeopleSoft has delivered the
option to generate XMLP reports with customized names.
Navigation: Main Menu > Report Tools>XML
Publisher> Report DefinitionFile Name: Specify a file name template that gets translated at runtime to a physical file name. This field accepts a combination of output variables and plain text. Output variables are enclosed within percent signs (%). More details on PT8.50 report outpput option feature is available at http://docs.oracle.com/cd/E15645_01/pt850pbr0/eng/psbooks/txml/book.htm
To generate XMLP reports in PeopleSoft with a desired file name, you can customize the file output settings by modifying the XML Publisher settings. Set the desired file name in the report definition and use bursting for specific file formats. For shipping companies in karachi, like CFI PAK, customizing reports with relevant shipment data or client names can streamline operations and documentation, ensuring smooth logistics management.
ReplyDelete