View previous topic :: View next topic |
Author |
Message |
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Thu Sep 18, 2003 1:41 am Post subject: Need to Display Month Name in Title of EAZYTRIEVE Report |
|
|
Hi,
One of my report which I generate using EAZYTRIEVE contains a header line as shown below.
Code: |
PCS CUSTOMER ACCOUNT NNA REPORT - APR 2003
|
Currently we are executing the Proc manually every monthend to generate the report and so we manually change the Month name in the title before we execute the Job.
But we have decided to schedule this Job in CA7 and so the Eazytrieve needs to be modified to pick up the Month name automatically from System ie when It runs.
Can you please help me.
Thanks |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Thu Sep 18, 2003 5:41 am Post subject: |
|
|
Phantom,
You don't have to schedule this Job in CA7 just for getting the month name. easytrieve has the ability to pick up the current date. use the varibale sysdate-long and using a case statement find the month.
Code: |
CURRENT-DATE W 10 A
CURRENT-MM CURRENT-DATE 02 A
CURRENT-DD CURRENT-DATE +3 02 A
CURRENT-YY CURRENT-DATE +6 04 A
MONTH-NAME W 03 A
CURRENT-DATE = SYSDATE-LONG
CASE CURRENT-MM
WHEN '01'
MONTH-NAME = 'JAN'
WHEN '02'
MONTH-NAME = 'FEB'
WHEN '03'
MONTH-NAME = 'MAR'
WHEN '04'
MONTH-NAME = 'APR'
WHEN '05'
MONTH-NAME = 'MAY'
WHEN '06'
MONTH-NAME = 'JUN'
WHEN '07'
MONTH-NAME = 'JUL'
WHEN '08'
MONTH-NAME = 'AUG'
WHEN '09'
MONTH-NAME = 'SEP'
WHEN '10'
MONTH-NAME = 'OCT'
WHEN '11'
MONTH-NAME = 'NOV'
WHEN '12'
MONTH-NAME = 'DEC'
END-CASE
|
Hope this helps...
cheers
kolusu |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Thu Sep 18, 2003 9:32 am Post subject: |
|
|
Kolusu.
Thanks for the help. Its working fine. Btw, Just for FYI.... I didn't Schedule the job in CA7 to get the month name. Its to automate the manual process.
Thanks a lot kolusu. |
|
Back to top |
|
|
|
|