Found 891 results.
This blog includes the steps to implement PeopleSoft enhanced features in reporting.
This blog outlines the steps to implement enhanced reporting features in PeopleSoft.
The following BI Publisher features are available for PDF documents:
The Java object com.lowagie.text.pdf.PdfReader is used to determine the number of pages in a PDF file.
Local JavaObject &obj_Split_PDF_Size = CreateJavaObject(“com.lowagie.text.pdf.PdfReader”, “”);
/* &NumberofPages – returns the number of pages in the PDF file */
Local number &NumberofPages = &obj_Split_PDF_Size.getNumberOfPages();
The Application Package PSXP_ENGINE:PDFMerger can be used to merge two or more PDF files.
&Reportmrg = create PSXP_ENGINE:PDFMerger();
&ret = &Reportmrg.mergePDFs(,
The following features are available for Oracle-PeopleSoft BI Publisher .rtf templates:
To use barcodes in BI Publisher reports, follow these steps:
Setting this property ensures the barcode is visible in the PDF output.
Form fields cannot be inserted directly into the header or footer of .rtf templates in BI Publisher. To include dynamic or conditional content in these sections, XML tags must be written directly into the header or footer. These tags are replaced with actual values during report generation.
<?fld_DESCR?>
To add a dynamic or conditional watermark in an .rtf template:
<?xdoxslt:ifelse(<condition>, ‘Watermark to be displayed when the condition is satisfied’, ‘Watermark to be displayed when the condition is not satisfied’)?>
This will ensure that the watermark content changes dynamically based on the specified condition.
To include dynamic images in a BI Publisher report, follow these steps:
Example: url:{.//}
Here, refers to the record field that holds the image path used in the report.
The following feature is available in Oracle-PeopleSoft BI Publisher Excel templates:
You can generate multi-sheet Excel reports using the Excel COM object in PeopleCode. Below is a sample PeopleCode snippet to demonstrate the process:
&oWorkApp = CreateObject(“COM”, “Excel.Application”);
&oWorkApp.DisplayAlerts = False;
/* Make the Excel application visible */
ObjectSetProperty(&oWorkApp, “Visible”, True);
/* Add a new workbook */
&oWorkBook = ObjectGetProperty(&oWorkApp, “Workbooks”);
&oWorkBook.Add();
/* Access and rename the first worksheet */
&oWorkSheet = &oWorkApp.Worksheets(“Sheet1”);
&oWorkSheet.Name = “Test Sheet”;
/* Set a value in cell A1 of the first worksheet */
&oWorkSheet.Cells(1, 1).Value = “Test”;
/* Access and rename the second worksheet */
&oWorkSheet = &oWorkApp.Worksheets(“Sheet2”);
&oWorkSheet.Name = “Access”;
/* Delete the third worksheet */
&oWorkSheet = &oWorkApp.Worksheets(“Sheet3”);
&oWorkSheet.Delete();
/* Save the workbook to the specified path */
&oWorkApp.ActiveWorkbook.SaveAs(“”);
/* Close the workbook and quit Excel */
&oWorkApp.ActiveWorkbook.Close();
&oWorkApp.Quit();
This script creates a multi-sheet Excel report, renames sheets, writes data to cells, deletes unused sheets, and saves the final output.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
