Report Builder (extract) question

Yahoo Archive
1
Was worth a try. I added my calculated field x(3) to the beginning of the
record,
and then concatenated the rest of the record. Unfortunately, I got the same
result.
The record below represent one of the records taken from the file. You can
see it
starts 5 bytes to the right.

IS 0000XX0000000000000XXXXXXX000000XXXXXXX000000002191520020905EMERY
WORLDWIDE

Fortunately I live by the saying that "what don't kill you will make you
stronger".

regards,
2
I am trying to extract a record format to send to a bank. The data must be
in a precise format
as follows:

IS 0000XX0000000000000123456780000001012345000000002191520020905EMERY
WORLDWIDE

When I concatenate my record and print it, it looks fine and is in the
correct format. But when I
extract to a text file, I am getting 5 embedded spaces before each record.
I have a constant field
defined ('IS ') (a three byte field). When I run my extract, the field
turns into an 8 byte character field so my
record looks like the following:
IS 000095000000000000018776010000001016428000000002191520020905EMERY
WORLDWIDE.
Can anyone enlighten me as to how to get rid of the 5 unwanted spaces before
each record when I run the extract?

Thanks again,



[Non-text portions of this message have been removed]
3
Try looking at the format for that field. It may have been created size 5 or
perhaps you had something longer in it previously and reduced it to 3?
Either way the original size is probably still there. Change the field size
to 3 and also "match" it and the extra padding characters should go away.
-Todd C.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, September 11, 2002 1:38 PM
To: 'Vantage (vantage@yahoogroups.com)'
Subject: [Vantage] Report Builder (extract) question


I am trying to extract a record format to send to a bank. The data must be
in a precise format
as follows:

IS 0000XX0000000000000123456780000001012345000000002191520020905EMERY
WORLDWIDE

When I concatenate my record and print it, it looks fine and is in the
correct format. But when I
extract to a text file, I am getting 5 embedded spaces before each record.
I have a constant field
defined ('IS ') (a three byte field). When I run my extract, the field
turns into an 8 byte character field so my
record looks like the following:
IS 000095000000000000018776010000001016428000000002191520020905EMERY
WORLDWIDE.
Can anyone enlighten me as to how to get rid of the 5 unwanted spaces before
each record when I run the extract?

Thanks again,



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=233351.2287382.3722243.2225243/D=egroupweb/S=17050071
83:HM/A=1212977/R=0/*http://www.gotomypc.com/u/tr/yh/grp/300_textG/g22lp?Tar
get=mm/g22lp.tmpl>

<http://us.adserver.yahoo.com/l?M=233351.2287382.3722243.2225243/D=egroupmai
l/S=:HM/A=1212977/rand=553969052>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
The offending field is a constant field. I am adding it to the record as
follows:

record = 'IS ' + Field1 + Field2 + Field3 + Field4 + Field5

The 'IS ' field is exporting as ' IS '
I don't know how to specify a size for a constant field.

I'm ready to just run the export, and delete the blank spaces.

thanks for your help.
5
Is the format size (that is X(?) ) for the field called Record set to the
true sum of 'IS ' + Field1 + Field2 + ......?
I have had this happen several times in exports where the Format setting
does not automatically follow the changes in the sizes of the components
that make up a field, especially when the total size is decreased. If one
of the component fields was reduced in size or one was eliminated from the
concatenation then the format size would be overstated and have to manually
be reduced. Check to be sure the size of Record is not 5 more than it
should be for the sum of all the fields being added.
-Todd C.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, September 11, 2002 2:06 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder (extract) question


The offending field is a constant field. I am adding it to the record as
follows:

record = 'IS ' + Field1 + Field2 + Field3 + Field4 + Field5

The 'IS ' field is exporting as ' IS '
I don't know how to specify a size for a constant field.

I'm ready to just run the export, and delete the blank spaces.

thanks for your help.




Yahoo! Groups Sponsor

ADVERTISEMENT



<http://rd.yahoo.com/M=212804.2303158.3720906.2225242/D=egroupweb/S=17050071
83:HM/A=810373/R=0/*http://geocities.yahoo.com/ps/info?.refer=blrecs>
<http://rd.yahoo.com/M=212804.2303158.3720906.2225242/D=egroupweb/S=17050071
83:HM/A=810373/R=1/*http://geocities.yahoo.com/ps/info?.refer=blrecs>

<http://us.adserver.yahoo.com/l?M=212804.2303158.3720906.2225242/D=egroupmai
l/S=:HM/A=810373/rand=916040503>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
6
Did you try setting the left hand margin to 0? In properties page layout.
If it is set at .50 that gives me 5 spaces before my export line.

Just a Thought
Bart Sgroi

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, September 11, 2002 3:06 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder (extract) question


The offending field is a constant field. I am adding it to the record as
follows:

record = 'IS ' + Field1 + Field2 + Field3 + Field4 + Field5

The 'IS ' field is exporting as ' IS '
I don't know how to specify a size for a constant field.

I'm ready to just run the export, and delete the blank spaces.

thanks for your help.




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
7
I tried setting margins to zero, Report Builder String
Manipulators, printing to a generic text file and I am still
getting those blasted 5 blank spaces. Report Builder
sees my defined field ('IS ') as an 8 byte block.
So far the only remedy I have is to manually delete the
spaces. It only takes a couple of minutes to do it, but
I have a user who runs this report weekly, and they are
not keen to have to spend a couple of minutes removing
format characters.
I appreciate all of your helpful comments.

thanks again,
8
One more idea... could you create a function field for 'IS ' and force it to
format x(3) and then use that in the function that appends all the other
stuff, instead of using a literal string?
-Todd C.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, September 11, 2002 3:09 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Report Builder (extract) question


I tried setting margins to zero, Report Builder String
Manipulators, printing to a generic text file and I am still
getting those blasted 5 blank spaces. Report Builder
sees my defined field ('IS ') as an 8 byte block.
So far the only remedy I have is to manually delete the
spaces. It only takes a couple of minutes to do it, but
I have a user who runs this report weekly, and they are
not keen to have to spend a couple of minutes removing
format characters.
I appreciate all of your helpful comments.

thanks again,





Yahoo! Groups Sponsor

ADVERTISEMENT



<http://rd.yahoo.com/M=212804.2303158.3720906.2225242/D=egroupweb/S=17050071
83:HM/A=810327/R=0/*http://geocities.yahoo.com/ps/info?.refer=blrecs>
<http://rd.yahoo.com/M=212804.2303158.3720906.2225242/D=egroupweb/S=17050071
83:HM/A=810327/R=1/*http://geocities.yahoo.com/ps/info?.refer=blrecs>

<http://us.adserver.yahoo.com/l?M=212804.2303158.3720906.2225242/D=egroupmai
l/S=:HM/A=810327/rand=724631427>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]