Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] fields coming as *** in report
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] fields coming as *** in report
 Login/Join
 
Gold member
posted
Hi ,
I have CM, CYC_CD, CYC_MNTH,CYC_YR coming in the report as ***
the code is written as below -*================= Definitions of report fields ============================
-*
-SET &&MARKET=FGETENV(10,'TLG_MARKET',3,'A3');
-*
DEFINE FILE BLADSOC
CM/A1=',';
CYC_CD/I2=CYCLE_CODE;
CYC_MNTH/I2=CYCLE_RUN_MONTH;
CYC_YR/I4=CYCLE_RUN_YEAR;
SUB_MKT_CD/A3=SUB_MARKET_CODE;
OVR_REC_IND/A1=OVER_REC_IND;
SOC_CD/A9=SOC;
PRD_SET_CD/A4=PRD_SET_CODE;
MIN/P12.2=MINUTES;
REV/P12.2=REVENUE;
END
-RUN

TABLE FILE BLADSOC
PRINT
CYC_CD CM
CYC_MNTH CM
CYC_YR CM
OVR_REC_IND CM
SOC_CD CM
PRD_SET_CD CM
SUB_MKT_CD CM
MIN CM
REV CM
ON TABLE SAVE AS TMSFILE
END
-RUN

Can anyone help with this?/

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS, Linux
Excel, CSV
 
Posts: 62 | Registered: May 23, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Lack of space to display the entire field's value. Field definition is not long enough.

Asterisk is the default value : Overflowchar


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2161 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
hi,

thanks for ur quick reply. but i tried increasing the size with changing
CYC_CD/I2=CYCLE_CODE;
CYC_MNTH/I2=CYCLE_RUN_MONTH;
CYC_YR/I4=CYCLE_RUN_YEAR;

to

CYC_CD/I4=CYCLE_CODE;
CYC_MNTH/I4=CYCLE_RUN_MONTH;
CYC_YR/I6=CYCLE_RUN_YEAR;

but now its printing these values which is not the expected result.

NXT - Additional SOC Activity
256,1280, -7929,N,24BNSTEST, ,BAR, .00, .00,
256,1280, -7929,N,24BNSTEST, ,CVY, .00, .00,
256,1280, -7929,N,24BNSTEST, ,KN , .00, .00,
256,1280, -7929,N,302USUM , ,CHI, .00, .00,


Can u please suggest something

Thanks


WebFOCUS, Linux
Excel, CSV
 
Posts: 62 | Registered: May 23, 2017Reply With QuoteReport This Post
Gold member
posted Hide Post
i tried changing mass file also but did not work

SEGNAME=FIRST
FIELDNAME=CYCLE_CODE ,ALIAS= ,FORMAT=I2 ,ACTUAL=I4 ,$
FIELDNAME=CYCLE_RUN_MONTH ,ALIAS= ,FORMAT=I2 ,ACTUAL=I4 ,$
FIELDNAME=CYCLE_RUN_YEAR ,ALIAS= ,FORMAT=I2 ,ACTUAL=I6 ,$


WebFOCUS, Linux
Excel, CSV
 
Posts: 62 | Registered: May 23, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
First try to perform a sample data from the master file itself and look at the result.

Second, do a TABLE FILE from the master file with printing the fields themselves, not the DEFINEd
TABLE FILE BLADSOC
PRINT
 CYCLE_CODE
 CYCLE_RUN_MONTH
 CYCLE_RUN_YEAR
 SUB_MARKET_CODE
 OVER_REC_IND
 SOC
 PRD_SET_CODE
 MINUTES
 REVENUE
END
-RUN


Third, why would you want to create DEFINEd fields where the only thing you do is assigning the read data to the DEFINEd field ?


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2161 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Gold member
posted Hide Post
Hi,

I tried printing the fields from TABLE FILE
and its printing

256,1280, -7929,N,24BNSTEST, ,BAR, .00, .00,
256,1280, -7929,N,24BNSTEST, ,CVY, .00, .00,

which is wrong value


WebFOCUS, Linux
Excel, CSV
 
Posts: 62 | Registered: May 23, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
First try to perform a sample data from the master file itself and look at the result.

What is the result of the above ? You must start from there. Then create your master file using the tool. The connector may fix the issue by itself when it will recreates the file.

When you post data sample or code sample, use the code tag to enclose it.
Far right icon from discussion ribbon
</>


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2161 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
I tried printing the fields from TABLE FILE
and its printing

256,1280, -7929,N,24BNSTEST, ,BAR, .00, .00,
256,1280, -7929,N,24BNSTEST, ,CVY, .00, .00,

which is wrong value


OK, so not necessarily trying to be cute, but what would be the "right" value? And how do you get those values (other tool?) => look at settings.

If you get that from the database, that is what is in the database, so no reporting magic will turn crap into gold.

If 256,1280, -7929, are your code/month/year; month 1280 and year -7929 there is something really interesting going on, my guess the data is packed? You need to look into the database/adapter first, and the box => look at settings.


Cheers,
H.

WebFOCUS 8.1.05M
Oracle 11g - DB2
RedHat
 
Posts: 114 | Location: Brighton UK | Registered: February 19, 2005Reply With QuoteReport This Post
Guru
posted Hide Post
Genius

Did the suggestions from Martin and Hank help?

Let us know if you have figured out your issue or if you need further assistance.

"****" will also indicate that the data is too large to fit into the format of the field, this can be the format of a field set up in a report or the format in the Synonym.

Since this question is similar to your other - file seq no field which is taken from file is printing as *** in reports I am marking this [SOLVED]


We kindly ask that you update the topic with your solution/further questions as well as add a tag to your subject line.

Here is a list of keywords to use: FOCUS Guidelines

[SOLVED]
[CODE]
[WORKAROUND]
[CLOSED]
[SHARING]
[CASE-OPENED]

Thank you for participating in the Focal Point Forum!
Tamra Colangelo
Focal Point Moderator
Information Builders

This message has been edited. Last edited by: Tamra,


WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
 
Posts: 487 | Location: Toronto | Registered: June 23, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] fields coming as *** in report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.