Skip to main content

Peoplesoft Peoplecode Stuff

Search This Blog

Current Year in BI Publisher

Posted by die van niekerkuu's on January 25, 2016

Get link
Facebook
X
Pinterest
Email
Other Apps

<?if@inlines:number(STRM)=xdoxslt:get_year(xdoxslt:current_date(‘’,’America/USA’),$_XDOLOCALE)?>

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

UnknownSeptember 12, 2016 at 9:59 PM
very useful post thanks for sharing
Best Selenium Training in Chennai | Android Training in Chennai | Java Training in chennai | Webdesigning Training in Chennai
ReplyDelete
Replies
Anbarasan14January 7, 2019 at 1:13 AM
This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog and useful information. keep doing more.

IELTS Coaching in Mulund
IELTS Training in Mulund West
IELTS Courses in Mulund
Best IELTS Coaching Institute in Mulund
IELTS Classes in Mulund
Best IELTS Training Centres in Mulund East
IELTS Classes near me
ReplyDelete
Replies
Lucky PatcherJune 29, 2019 at 9:15 AM
b612 apk
ReplyDelete
Replies
luckysJuly 4, 2019 at 7:47 AM
gomovies
ReplyDelete
Replies
luckysJuly 6, 2019 at 2:19 AM
yesmovies
ReplyDelete
Replies
tech zoneJuly 12, 2019 at 7:45 AM
gifts whatsapp groups
ReplyDelete
Replies
Sakira November 6, 2019 at 12:06 AM
Try this apk now its on trending : what is the best android emulator for pc
ReplyDelete
Replies
parvinaNovember 6, 2019 at 10:30 PM
Thanks for this article.You might be interested in :vivavideo pro apk free download
ReplyDelete
Replies

Post a Comment

Popular Posts

SendMail with PT_MCF_MAIL (multiple attachments)

import PT_MCF_MAIL:*; /**** Send Mail ****/ Local PT_MCF_MAIL:MCFOutboundEmail &email = create PT_MCF_MAIL:MCFOutboundEmail(); &email.From = " PSCSMPRA@up.ac.za "; SQLExec("select EMAILID from PSUSEREMAIL where OPRID=:1 and Primary_email = 'Y'", %OperatorId, &Email_To); &email.Recipients = &Email_To; &email.Subject = %DbName | ": Update Dual Class Sections to English"; Local string &plain_text = "Please see report output attached for Class Section update from Dual to English (D100 to E100)."; Local PT_MCF_MAIL:MCFBodyPart &text = create PT_MCF_MAIL:MCFBodyPart(); &text.Text = &plain_text; &File_name_path = GetCwd() | "\files\Dual_UpdatedTo_English.csv"; &file_name_email = "Dual_UpdatedTo_English.csv"; &File_name_path2 = GetCwd() | "\files\English_ClassSection_Exist.csv"; &file_name_email2 = "English_ClassSection_Exist.csv"; Local PT_MC

BI Publisher little tricks

While creating a BI Publisher Invoice report for a client I had to google like a mad women. Here are some of the things I've learned: The template consists of 2 pages because one of the requirements was a remittance advice at the end of each invoice (per student) - almost like a footer but only on the last page. This was the final .rtf template: The body of the template looked like this: Tips: 1. Formatting the date: <?format-date:A.DATE_DUE;'dd/mm/yyyy';'UTC'?> 2. Formatting the amounts: <?format-number:A.TOT_FUTURE_AMT;'999G999D99'?> 3. Calculating the sum of the current group: <?sum(current-group()//EXPR64_64)?> 4. If statements: <?if:sum(current-group()//A.DEBIT_UFS)<0.00?><?sum(current-group()//EXPR64_64)?><?end if?> OR <?if:A.TOT_FUTURE_AMT!=0.00?> 5. Upper Case: <?xdofx:upper(A.NAME_TITLE)?> Because of the last page "footer" both pa

Date Format for Insert in DATAMOVER

to_date('19000101','YYYYMMDD')

Powered by Blogger