Crystal Formatting Q?

Yahoo Archive
1
Do a replace on "Date Label 3: Date Label 4:" and replace it with just "Date
Label 4:"



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Tuesday, August 11, 2009 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Formatting Q?





All,

I have a very large text box in crystal that has a form we use for
corrective actions, that we print off. Looks pretty on a company letter head
blah blah blah. Well at one point in the text box I have a series of 4 dates
that are relative to the CA. When you stack them up one on top of another it
makes the form quite a bit longer than it needs to be. So what I would like
to do is put them in a format similar to this:

Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date3 Date Label 4: Date4

The only problem is that if one of the fields is blank say date 3 doesn't
have anything entered it looks like this:

Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date Label 4: Date4

This is completely unprofessional.

Above I used tabs to space everything out. This obviously isn't working for
me.

Any ideas how to get this formatting right in this text box?

~Charlie

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





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



I have a very large text box in crystal that has a form we use for
corrective actions, that we print off. Looks pretty on a company letter head
blah blah blah. Well at one point in the text box I have a series of 4 dates
that are relative to the CA. When you stack them up one on top of another it
makes the form quite a bit longer than it needs to be. So what I would like
to do is put them in a format similar to this:



Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date3 Date Label 4: Date4



The only problem is that if one of the fields is blank say date 3 doesn't
have anything entered it looks like this:



Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date Label 4: Date4



This is completely unprofessional.



Above I used tabs to space everything out. This obviously isn't working for
me.



Any ideas how to get this formatting right in this text box?



~Charlie





[Non-text portions of this message have been removed]
3
use a formula for your labels such as IF ISNULL DATE3 THEN '' ELSE DATE LABEL 3 then suppress null fields in your text box


BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell



________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Charlie Wilson
Sent: Tuesday, August 11, 2009 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Formatting Q?



All,

I have a very large text box in crystal that has a form we use for
corrective actions, that we print off. Looks pretty on a company letter head
blah blah blah. Well at one point in the text box I have a series of 4 dates
that are relative to the CA. When you stack them up one on top of another it
makes the form quite a bit longer than it needs to be. So what I would like
to do is put them in a format similar to this:

Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date3 Date Label 4: Date4

The only problem is that if one of the fields is blank say date 3 doesn't
have anything entered it looks like this:

Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date Label 4: Date4

This is completely unprofessional.

Above I used tabs to space everything out. This obviously isn't working for
me.

Any ideas how to get this formatting right in this text box?

~Charlie

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




________________________________
The information contained in this message is intended solely for the individual to whom it is specifically and originally addressed. This message and its contents may contain confidential or privileged information. If you are not the intended recipient, you are hereby notified that any disclosure or distribution, or taking any action in reliance on the contents of this information, is strictly prohibited.
We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

This message (including any attachments) is intended only for
the use of the individual or entity to which it is addressed and
may contain information that is non-public, proprietary,
privileged, confidential, and exempt from disclosure under
applicable law or may constitute as attorney work product.
If you are not the intended recipient, you are hereby notified
that any use, dissemination, distribution, or copying of this
communication is strictly prohibited. If you have received this
communication in error, notify us immediately by telephone and
(i) destroy this message if a facsimile or (ii) delete this message
immediately if this is an electronic communication.

Thank you.


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

Create a new formula and concatenate your 4 date fields. Chr(13) will
put in a carriage return. Make your field on your report one line and
enable "Can Grow" in the properties of the text box.


(
if IsNull({Date01}) or {Date01} = "" then ""
Else
("Date Label 1: " + {Date01} + Chr(13))
)
+
(
if IsNull({Date02}) or {Date02} = "" then ""
Else
("Date Label 2: " + {Date02} + Chr(13))
)
+
(
if IsNull({Date03}) or {Date03} = "" then ""
Else
("Date Label 3: " + {Date03} + Chr(13))
)
+
(
if IsNull({Date04}) or {Date04} = "" then ""
Else
("Date Label 4: " + {Date04} + Chr(13))
)


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, August 11, 2009 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Formatting Q?

All,



I have a very large text box in crystal that has a form we use for
corrective actions, that we print off. Looks pretty on a company letter
head
blah blah blah. Well at one point in the text box I have a series of 4
dates
that are relative to the CA. When you stack them up one on top of
another it
makes the form quite a bit longer than it needs to be. So what I would
like
to do is put them in a format similar to this:



Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date3 Date Label 4: Date4



The only problem is that if one of the fields is blank say date 3
doesn't
have anything entered it looks like this:



Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date Label 4: Date4



This is completely unprofessional.



Above I used tabs to space everything out. This obviously isn't working
for
me.



Any ideas how to get this formatting right in this text box?



~Charlie





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



------------------------------------

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/linksYahoo! Groups Links
5
I think I can make this work. thanks



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Tuesday, August 11, 2009 4:11 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Formatting Q?





Charlie,

Create a new formula and concatenate your 4 date fields. Chr(13) will
put in a carriage return. Make your field on your report one line and
enable "Can Grow" in the properties of the text box.

(
if IsNull({Date01}) or {Date01} = "" then ""
Else
("Date Label 1: " + {Date01} + Chr(13))
)
+
(
if IsNull({Date02}) or {Date02} = "" then ""
Else
("Date Label 2: " + {Date02} + Chr(13))
)
+
(
if IsNull({Date03}) or {Date03} = "" then ""
Else
("Date Label 3: " + {Date03} + Chr(13))
)
+
(
if IsNull({Date04}) or {Date04} = "" then ""
Else
("Date Label 4: " + {Date04} + Chr(13))
)

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, August 11, 2009 3:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Crystal Formatting Q?

All,

I have a very large text box in crystal that has a form we use for
corrective actions, that we print off. Looks pretty on a company letter
head
blah blah blah. Well at one point in the text box I have a series of 4
dates
that are relative to the CA. When you stack them up one on top of
another it
makes the form quite a bit longer than it needs to be. So what I would
like
to do is put them in a format similar to this:

Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date3 Date Label 4: Date4

The only problem is that if one of the fields is blank say date 3
doesn't
have anything entered it looks like this:

Date Label 1: Date1 Date Label 2: Date2

Date Label 3: Date Label 4: Date4

This is completely unprofessional.

Above I used tabs to space everything out. This obviously isn't working
for
me.

Any ideas how to get this formatting right in this text box?

~Charlie

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

------------------------------------

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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links





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