RB Description Field

Yahoo Archive
1
How was the text entered in the description field? If it was entered with "Enter" (CR) at th end of lines rather than allowing to wrap naturally it can cause multiple lines before 50 characters. Does the text that does print have odd characters in it (like shaded squares or rectangle boxes). This is an indicaiton they entered "hard" returns. You might want to use a formula tofind the first CR ( CHR(13) ) and truncate it there.

-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Thursday, October 09, 2003 8:10 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Description Field


Is there a way to tell Report Builder to only print the first line of let's say the InvcDtl.LineDesc field? I have limited the field to 50 characters but if there is more than one line of text in this field it will show all lines up to the 51st character. I only want to see the first line.

Thanks

Todd Hofert



Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=259395.3614674.4902533.1261774/D=egroupweb/S=1705007183:HM/A=1524963/R=0/SIG=12o885gmo/*http://hits.411web.com/cgi-bin/autoredir?camp=556&lineid=3614674&prop=egroupweb&pos=HM>
<http://us.adserver.yahoo.com/l?M=259395.3614674.4902533.1261774/D=egroupmail/S=:HM/A=1524963/rand=742028372>

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 the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Is there a way to tell Report Builder to only print the first line of let's say the InvcDtl.LineDesc field? I have limited the field to 50 characters but if there is more than one line of text in this field it will show all lines up to the 51st character. I only want to see the first line.

Thanks

Todd Hofert
3
Todd -

You would need to check for CHR(10) & CHR(13) in the LineDesc field.
This is the carriage return/line feed - you need to remove or trim the
field if one is found. You may also want to check for TABS too,
depends how creative your data entry people were!

HTH,
Misha 1, Ltd.
Calvin Dekker


-----Original Message-----
From: Todd Hofert [mailto:thofert@...]
Sent: Thursday, October 09, 2003 8:10 AM
To: Vantage List (E-mail)
Subject: [Vantage] RB Description Field


Is there a way to tell Report Builder to only print the first line of let's
say the InvcDtl.LineDesc field? I have limited the field to 50 characters
but if there is more than one line of text in this field it will show all
lines up to the 51st character. I only want to see the first line.

Thanks

Todd Hofert



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/