IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to display Numeric field in report


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
khyati kumar

New User


Joined: 04 Jan 2008
Posts: 15
Location: Pune

PostPosted: Wed May 28, 2008 6:43 pm
Reply with quote

Hi All,

Actually i am writing the program to display the report using easytrieve.In this there is one Amount field in my input file which is defined as
9(12).But in my report i want to display this field right justified replacing zeros by spaces(eg: if the input contain
Code:
000000123456
, then in my report it should be displayed as
Code:
      123456
.

the field is used as follows:-

Code:
WS-RPT-TYPE7-DTL4                           W      80 A         
 WS07-RPT-COMMON-DTL-HDR WS-RPT-TYPE7-DTL4         25 A         
 WS07-RPT-DR-ITEM-COUNT  WS-RPT-TYPE7-DTL4 +25      7 N MASK +   
 ('ZZZZZZ9')                                                     
 FILLER-20               WS-RPT-TYPE7-DTL4 +32      1 A         
 [color=red]WS07-RPT-DR-ITEM-AMOUNT [/color]WS-RPT-TYPE7-DTL4 +33     12 N MASK +   
 ('ZZZZZZZZZZZ9')                                               
 FILLER-21               WS-RPT-TYPE7-DTL4 +45      6 A         
 WS07-RPT-CR-ITEM-COUNT  WS-RPT-TYPE7-DTL4 +51      7 N MASK +   
 ('ZZZZZZ9')                                                     
 FILLER-22               WS-RPT-TYPE7-DTL4 +58      1 A         
 WS07-RPT-CR-ITEM-AMOUNT WS-RPT-TYPE7-DTL4 +59     12 N MASK +   
 ('ZZZZZZZZZZZ9')                                               
 FILLER-23               WS-RPT-TYPE7-DTL4 +71      9 A         


In the above WS07-RPT-CR-ITEM-AMOUNT.Here i had used the mask parameter to supress the laeding zeros but when i am displaying whole WS-RPT-TYPE7-DTL4 it displays the amount field without supressing the zeros.Please if anyone can help me for this.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Wed May 28, 2008 10:30 pm
Reply with quote

The mask works for the report, but the display does not see the mask.
Does that help?
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed May 28, 2008 11:16 pm
Reply with quote

Hello,

Said slightly differently, If you display WS07-RPT-CR-ITEM-AMOUNT, you should see the zero suppression you want.
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu May 29, 2008 2:47 am
Reply with quote

Let's try again,

The mask option will only work in the report section. Display will NOT use the mask (ie: leading zero will NOT be suppressed).
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu May 29, 2008 4:27 am
Reply with quote

Hello,

Quote:
Display will NOT use the mask (ie: leading zero will NOT be suppressed).
Even if the masked field is named in the DISPLAY?
Back to top
View user's profile Send private message
khyati kumar

New User


Joined: 04 Jan 2008
Posts: 15
Location: Pune

PostPosted: Thu May 29, 2008 9:50 am
Reply with quote

hi ,

actually i am not using report writer in this program i am just arranging the data as per my requirement and puting it to output report file so in this case it is not suppressing leading zeros.
Back to top
View user's profile Send private message
khyati kumar

New User


Joined: 04 Jan 2008
Posts: 15
Location: Pune

PostPosted: Thu May 29, 2008 10:11 am
Reply with quote

Actually what is happening when i am trying to display only amount field it is displaying the proper amount which is masked,but i am displaying WS-RPT-TYPE7-DTL4 ...in this the zeros are not suppressed in the amount field.
Back to top
View user's profile Send private message
lcmontanez

New User


Joined: 19 Jun 2007
Posts: 50
Location: Chicago

PostPosted: Thu May 29, 2008 7:09 pm
Reply with quote

dick scherrer wrote:
Hello,

Quote:
Display will NOT use the mask (ie: leading zero will NOT be suppressed).
Even if the masked field is named in the DISPLAY?


Sorry, I just tried this and it does work (maybe it depends on the release). I do recall this NOT working.

I stand corrected.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 31, 2008 12:00 am
Reply with quote

Hello,

Quote:
Sorry, I just tried this and it does work (maybe it depends on the release). I do recall this NOT working.
Not to worry icon_smile.gif
Between product changes and subtle differences in specific code, oh well. . .

It's been one of those weeks for me as well - i've been "away" and haven't actually tested everything as i reply. . . Gotten "bit" on 2 things i remembered, but didn't verify icon_redface.gif

Have a gr8 weekend,

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Need help on formatting a report DFSORT/ICETOOL 14
No new posts Join 2 files according to one key field. JCL & VSAM 3
No new posts Creating Report using SORT DFSORT/ICETOOL 7
Search our Forums:

Back to Top