RB Input Field

Yahoo Archive
1
For part 3 off-hand I would append a string of X spaces (where X = the
maximum field size) on to the field and then truncate it back to the desired
length. Example - if the desired length is 35 and the length is now 15
append 35 spaces and then truncate it back to 35. You could also calculate
the difference between the length and the desired length (Y) and use the
FILL function to append Y spaces. Then set the formatting of the report
field to the desired length (next point).

If you have intermediate fields that don't print but you are using to hold
values along the way try inserting them somewhere in the report and then
selecting format to make sure they are large enough for the final field
result. You can then delete them from the the visible part of the report
but the formatting will stay. But if any intermediate fields are too small
you will not get the padding you desire. Set the length and then match
format to set the width.

If you are trying to export to a CSV type file for spreadsheet use I believe
that some conversions will trim trailing spaces. In this case you might try
to append some non-printable ASCII character to the far right end. Doing
that would require calculating the difference between the current length and
the desired length and subtract 1 and append that many spaces plus the ASCII
character (use the CHR function). An ASCII 0 (NUL) character should fool it
into not trimming.

I hope one of these ideas helps.

-Todd C.



-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Thursday, June 28, 2001 4:58 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Input Field


Todd,

That part worked great!!! Now for one more question.

I need to be able to take a string field with varying lengths and:
1. Truncate it if it's longer than a certain length
2. Leave it alone if it's the proper length
or
3. Put spaces on the end of it to make it equal to the length I need

I can stick it in the report (extract) if it's the proper length or truncate
it by formatting. The third part is the part I can't get.
I can get the length with the LENGTH(char) function but every time I try to
use a calculation to format it I run into problems.

Thanks,

Dave Cole
Reeder & Kline

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, June 28, 2001 11:38 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Input Field


I do this a lot. Create a bogus text field ( 'xxxx' ) and have them enter
date as text (in quotes) in a filter that includes if not equal to the bogus
text field. The not equal part does not look real good (not intuitive to
the user) but it gets the text into the filter wher you can parse it out. I
use the same technique so user can control whether to print detail lines on
some reports (filter is something like SuppressDetails <> Yes where
SuppressDetails = 'xxxx' so it will always not equal 'yes' or 'no'. It does
involve some training and/or written instructions to guide the report users.

-Todd C.

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Thursday, June 28, 2001 11:25 AM
To: eManfacturing Yahoo Groups (E-mail)
Subject: [Vantage] RB Input Field


Hi,

How can you get an input field to print in Report Builder. I want to query
the user for some specific input like a date. However, this date is not
used as a filter. I just want it to be printed on the report.

Thanks,

Dave Cole
Reeder & Kline




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



Yahoo! Groups Sponsor

<
http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
>
<
http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
>
>
183:N/A=675622/*
http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
<http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937>
< http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
<http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937> >
45599> []

<
http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
>
<
http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
>
>
l/S=1700007183:N/A=675622/rand=235622857>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > > Note: You must have
already linked your email address to a yahoo id to enable access.

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




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



Yahoo! Groups Sponsor

<
http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
>
183:N/A=675622/*
http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
<http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937>
46356> []

<
http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
>
l/S=1700007183:N/A=675622/rand=142812654>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > Note: You must have
already linked your email address to a yahoo id to enable access.

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




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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
183:N/A=675622/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
65471> []

<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
l/S=1700007183:N/A=675622/rand=111434795>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> Note: You must have
already linked your email address to a yahoo id to enable access.

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




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

How can you get an input field to print in Report Builder. I want to query
the user for some specific input like a date. However, this date is not
used as a filter. I just want it to be printed on the report.

Thanks,

Dave Cole
Reeder & Kline




[Non-text portions of this message have been removed]
3
I do this a lot. Create a bogus text field ( 'xxxx' ) and have them enter
date as text (in quotes) in a filter that includes if not equal to the bogus
text field. The not equal part does not look real good (not intuitive to
the user) but it gets the text into the filter wher you can parse it out. I
use the same technique so user can control whether to print detail lines on
some reports (filter is something like SuppressDetails <> Yes where
SuppressDetails = 'xxxx' so it will always not equal 'yes' or 'no'. It does
involve some training and/or written instructions to guide the report users.

-Todd C.

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Thursday, June 28, 2001 11:25 AM
To: eManfacturing Yahoo Groups (E-mail)
Subject: [Vantage] RB Input Field


Hi,

How can you get an input field to print in Report Builder. I want to query
the user for some specific input like a date. However, this date is not
used as a filter. I just want it to be printed on the report.

Thanks,

Dave Cole
Reeder & Kline




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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
183:N/A=675622/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
45599> []

<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
l/S=1700007183:N/A=675622/rand=235622857>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> Note: You must have
already linked your email address to a yahoo id to enable access.

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




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

That part worked great!!! Now for one more question.

I need to be able to take a string field with varying lengths and:
1. Truncate it if it's longer than a certain length
2. Leave it alone if it's the proper length
or
3. Put spaces on the end of it to make it equal to the length I need

I can stick it in the report (extract) if it's the proper length or truncate
it by formatting. The third part is the part I can't get.
I can get the length with the LENGTH(char) function but every time I try to
use a calculation to format it I run into problems.

Thanks,

Dave Cole
Reeder & Kline

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, June 28, 2001 11:38 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB Input Field


I do this a lot. Create a bogus text field ( 'xxxx' ) and have them enter
date as text (in quotes) in a filter that includes if not equal to the bogus
text field. The not equal part does not look real good (not intuitive to
the user) but it gets the text into the filter wher you can parse it out. I
use the same technique so user can control whether to print detail lines on
some reports (filter is something like SuppressDetails <> Yes where
SuppressDetails = 'xxxx' so it will always not equal 'yes' or 'no'. It does
involve some training and/or written instructions to guide the report users.

-Todd C.

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Thursday, June 28, 2001 11:25 AM
To: eManfacturing Yahoo Groups (E-mail)
Subject: [Vantage] RB Input Field


Hi,

How can you get an input field to print in Report Builder. I want to query
the user for some specific input like a date. However, this date is not
used as a filter. I just want it to be printed on the report.

Thanks,

Dave Cole
Reeder & Kline




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



Yahoo! Groups Sponsor

<
http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
>
183:N/A=675622/*
http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
<http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937>
45599> []

<
http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
>
l/S=1700007183:N/A=675622/rand=235622857>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> > Note: You must have
already linked your email address to a yahoo id to enable access.

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




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



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=202225.1433492.3029752.1269402/D=egroupmail/S=1700007
183:N/A=675622/*http://altfarm.mediaplex.com/ad/ck/1177-3936-1039-2?mpt=9937
46356> []

<http://us.adserver.yahoo.com/l?M=202225.1433492.3029752.1269402/D=egroupmai
l/S=1700007183:N/A=675622/rand=142812654>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> Note: You must have
already linked your email address to a yahoo id to enable access.

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




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