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,

Lack of space to display the entire field's value. Field definition is not long enough.

Asterisk is the default value : Overflowchar

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

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 ,$

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 ?

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

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

</>

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.

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,