Sitemap

Amicuk Programming Answers

LPAD in RTF template of BI Publisher help

2015-10-11   Views:13

Advertisement

I'm trying to use the Lpad feature in hopes when I export to excel I can use calculations based on the numbers. Currently it comes in spaced poorly and will only do counts based off of the values. But I have two columns (BFY and SGL) that have a set

I'm trying to use the Lpad feature in hopes when I export to excel I can use calculations based on the numbers. Currently it comes in spaced poorly and will only do counts based off of the values. But I have two columns (BFY and SGL) that have a set number of characters and they allow for calculations.

The replay answer
Advertisement
it's good for ideas but implementation a bit different
Oracle Business Intelligence Publisher Report Designer's Guide
This function provides a method to get the difference between two dates in the given locale. The dates need to be in "yyyy-MM-dd" format. This function supports only the Gregorian calendar. The syntax is as follows:
<?xdoxslt:date_diff(‘format’, ‘YYYY-MM-DD’, ‘YYYY-MM-DD’, $_XDOLOCALE, $_XDOTIMEZONE)?>
where
format is the time value for which the difference is to be calculated
Example:
<?xdoxslt:date_diff(‘d’, ‘2006-04-08’, ‘2006-04-01’, $_XDOLOCALE, ‘America/Los_Angeles’)?>
returns
-7

Go to See the other 4 answers

LPAD in RTF template of BI Publisher help

Category:DefaultRelease time:2015-10-11Views:130

I'm trying to use the Lpad feature in hopes when I export to excel I can use calculations based on the numbers. Currently it comes in spaced poorly and will only do counts based off of the values. But I have two columns (BFY and SGL) that have a set[More]

Creating Parameters in RTF Template for BI Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

hi, I have created Parameters in my BI Publisher Report and in SQL query. But i need to create same parameters in RTF Template , so that when i publish this report in dashboard , parameters will be visible. Can you please tell me how to create Parame[More]

How to migrate rtf Templates in XML Publisher ?

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I want the script so that i can download and upload the RTF files directly from my development instance to my production instance. For this i have come across 3 links How to migrate rtf Templates in XML Publisher? http://download.oracle.com/d[More]

How Can I apply a RTF Function on a variable in RTF Template in XML Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

Hi Everyone, I am developing a RTF Template of XML Publisher Report, I have a variable lv_counter which I can declare using below syntax <?xdoxslt: set_variable($_XDOCTX, 'lv_counter',0)?> I can access this variable in the template as <?xdoxslt:[More]

How to display no data found in RTF template ? XML Publisher

Category:DefaultRelease time:2015-10-11Views:130

Hi    I have xml file, how to display no data found in RTF template ? XML Publisher ? This is the XML File <?xml version="1.0" encoding="UTF-8"?> <INVALIDSERIALPRODUCT> <P_ORG_CODE></P_ORG_CODE><P_DATE_RANGE_[More]

How can we get Dynamic columns and data with RTF Templates in BI Publisher

Category:DefaultRelease time:2015-10-11Views:130

How can we get Dynamic columns and data with RTf Templates. My requirement is : create table xxinv_item_pei_taginfo(item_id number, Organization_id number, item varchar2(4000), record_type varchar2(4000), record_value CLOB, State varchar2(4000)); ins[More]

Reseting page number in Word RTF template for BI Publisher PDF generation

Category:DefaultRelease time:2015-10-11Views:130

Hi! Apex 4.0.2, Oracle 10.2.0.4, BIP 10.2 Bills are created based on Word RTF file with BI Publisher. Reszulting file is one big PDF file, which has many pages. Word RTF template is grouped on BILLS.ID field with page break option. So one BILLS.ID ma[More]

Freeze Pane Property of Excel in RTF template for XML Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have created RTF template and it's output type is Excel. I want to apply Freeze Pane Property of Excel in rtf template so that it can be applied to Excel Output. Please let me know any information regarding this ASAP. Thanks, P.A.This is th[More]

Excel's Freeze Pane Property  in RTF template for XML Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have created RTF template and it's output type is Excel. I want to apply Freeze Pane Property of Excel in rtf template so that it can be applied to Excel Output. Please let me know any information regarding this. ta, PI am looking for the s[More]

Query on fetching the no.of days between Invoice date and due date in rtf template embedded BI Publisher Report

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, We have a requirement to fetch the value of 'No of days' between Invoice date and due date (Two variable date fields on the template) in an Analysis. Please let me know the procedure of how to achieve the same. Regards, Revit's good for i[More]

Round Edged boxes in rtf templates

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have been really struggling to design rtf templates for XML Publisher with round edged boxes. The client requirement is to have all the tables/objects that contain data to have rounded edges..Just like a flowchart box.. I have tried using t[More]

Hot
Hi, While downloading data using gui_download I want to bring the negative sign to the left side of the value. Is this possible? Regrads, MadhuHi, Use FM CALL FUNCTION  'CLOI_PUT_SIGN_IN_FRONT' Regards. Eshwar.Read other 7 answers [More]
Hi, I have site with contains many document library each contains many MS Office and Pdf files. We have provided document library level access rights. While users click the file name, "Prompting the credentials while click MS office documents in docu [More]
I have a PowerBook G4 15" 1.25 GHz purchased almost three years ago. Mac OS running is 10.4.8. The Powerbook comes with 256MB RAM. Today I decided to install 1GB. When I opened the compartment on the bottom of the computer, I noticed both upper and l [More]
Hi there, I'm in a bit of a panic because when I press the Mail icon on my macbook air - the page opens but then the small ball just keeps on rolling and it doesn't actually open. I have tried doing a Force Quit and restarting the computer 3 times bu [More]
hi guru, i developed a report. IF S_BGPRO = 'X'.     SELECT  AUFNR   GMNGA  FROM     AFRU INTO CORRESPONDING FIELDS OF TABLE IT_AFRU12 WHERE WERKS = 'PD01'                                                     AND BUDAT  IN S_BUDAT.     IF NOT IT_AFRU1 [More]
I tried to update to the most recent version of itunes but the update failed.  Now when I try to open itunes I get a dialog box telling me it can,t open because MSVCR80.dll is missing.  I tried uninstalling and reinstalling itunes but I grt the same [More]
I upgraded today to 8.1 and now when I start my computer I get a message box telling me <re-install Dolby advanced audio driver>. I found the Dolby program in my control panel, programs and features, and there is no un-installer or, seemingly a way [More]
I multiple ipods (3 different users) on the same itunes account. All of the music is either from cd's or purchased from iTunes legally. A new iPod has been purchased, and I want to open a new iTunes account for the daughter so I can actually use iClo [More]
So let me preface this - for months I'd hoped for a way that Time Machine could backup my FileVault encrypted account without logging out.  Last night Snow Leopard spontaneously started doing this.  I know many may think that I'm looking a gift horse [More]
HI YA how many times can i copy logic 8 on different computers.I have 2 macs you see and want to no how many times i can copy logic 8 onto different macs.Plus if it got deleted of the hard drive if i could install it again without using up its instal [More]