Crystal Reports - text supression - AR Form

system · July 15, 2009, 9:58am

thank you for your help.
I created a group for CustID and placed that supression condition on the group footer. works like a charm.
thanks again and may the the force be with you.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Wednesday, July 15, 2009 9:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> wrote:

> Here is what I am trying to do.
> I have a customer who wants some special text to appear on
> their invoices.
> I created a text object with these values and created a flag
> where if one of their three customerID appear on the invoice,
> the text appears. For all other customers, supress.

I would put this text object in its own section (right mouse click on the
closest Group Header or Footer and choose Insert Section Below from the
context menu) and then put your suppression formula (custID <> "whatever")
in that section.

Mark W.

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

system · July 15, 2009, 6:44am

I have a crystal report that displays/supresses some text based upon the CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

system · July 15, 2009, 7:07am

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK <dplaman@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

system · July 15, 2009, 7:26am

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK <dplaman@...<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

system · July 15, 2009, 8:02am

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK <dplaman@...
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

system · July 15, 2009, 8:52am

Tried at the InvNum Foot Group & page footer. still only supresses the last invoice.
regards,

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Wednesday, July 15, 2009 7:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK <dplaman@...<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>" <vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

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

system · July 15, 2009, 9:16am

Dick,

Are you trying to NOT group if Customer = 'XXXX' ???

You can suppress group headers and footers but you cannot control
grouping levels like that.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 8:52 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Tried at the InvNum Foot Group & page footer. still only supresses the
last invoice.
regards,

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, July 15, 2009 7:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK
<dplaman@...<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

[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

system · July 15, 2009, 9:27am

Here is what I am trying to do.
I have a customer who wants some special text to appear on their invoices.
I created a text object with these values and created a flag where if one of their three customerID appear on the invoice,
the text appears. For all other customers, supress.
This worked as designed when printing one invoice at a time, but when loaded into a group and mass printed, only the last
invoice is evaluated. I cannot find a way to evaluate at each invoice when group printing.
thanks for your help.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, July 15, 2009 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Dick,

Are you trying to NOT group if Customer = 'XXXX' ???

You can suppress group headers and footers but you cannot control
grouping levels like that.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 8:52 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Tried at the InvNum Foot Group & page footer. still only supresses the
last invoice.
regards,

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Wednesday, July 15, 2009 7:59 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK
<dplaman@...<mailto:dplaman%40tse-industries.com><mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

[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

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

system · July 15, 2009, 9:37am

I don't know why that's not working. But, here is another way to accomplish what you want. Create a formula like this (Basic Syntax):

Formula = ""
If {BAQReportResult.[Field Name Here]} = "XXXXX" then
Formula = "Text to print if this is the correct customer id"
End If

Then, put the field on the report wherever you want. It will always be there, but it will be blank if it is not the customer in question.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Here is what I am trying to do.
I have a customer who wants some special text to appear on their invoices.
I created a text object with these values and created a flag where if one of their three customerID appear on the invoice,
the text appears. For all other customers, supress.
This worked as designed when printing one invoice at a time, but when loaded into a group and mass printed, only the last
invoice is evaluated. I cannot find a way to evaluate at each invoice when group printing.
thanks for your help.

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Vic Drecchio
Sent: Wednesday, July 15, 2009 9:15 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Dick,

Are you trying to NOT group if Customer = 'XXXX' ???

You can suppress group headers and footers but you cannot control
grouping levels like that.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 8:52 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Tried at the InvNum Foot Group & page footer. still only supresses the
last invoice.
regards,

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Wednesday, July 15, 2009 7:59 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK
<dplaman@...<mailto:dplaman%40tse-industries.com><mailto:dplaman%40tse-industries.com><mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

[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/.<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

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

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

system · July 15, 2009, 9:40am

This is what I use for our PO. We have one vendor that wants to see some
special wording on the PO. See formula below:

If{@vendadd1} like "SunSource" then " *We acknowledge that this order is
non cancelable or returnable*"

Simply create a formula and it should only display if the criteria is
met. Hope this helps.

Travis

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Wednesday, July 15, 2009 8:31 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I don't know why that's not working. But, here is another way to
accomplish what you want. Create a formula like this (Basic Syntax):

Formula = ""
If {BAQReportResult.[Field Name Here]} = "XXXXX" then
Formula = "Text to print if this is the correct customer id"
End If

Then, put the field on the report wherever you want. It will always be
there, but it will be blank if it is not the customer in question.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:27 AM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com> '
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Here is what I am trying to do.
I have a customer who wants some special text to appear on their
invoices.
I created a text object with these values and created a flag where if
one of their three customerID appear on the invoice,
the text appears. For all other customers, supress.
This worked as designed when printing one invoice at a time, but when
loaded into a group and mass printed, only the last
invoice is evaluated. I cannot find a way to evaluate at each invoice
when group printing.
thanks for your help.

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf Of Vic Drecchio
Sent: Wednesday, July 15, 2009 9:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Dick,

Are you trying to NOT group if Customer = 'XXXX' ???

You can suppress group headers and footers but you cannot control
grouping levels like that.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 8:52 AM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.co
m>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Tried at the InvNum Foot Group & page footer. still only supresses the
last invoice.
regards,

________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of Rob Bucek
Sent: Wednesday, July 15, 2009 7:59 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>] On
Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.co
m><mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK
<dplaman@... <mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com><mailto:dplaman%40tse-industries.co
m><mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mai
lto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

[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/.
<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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

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

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

system · July 15, 2009, 9:43am

OH, OK.

Yes, makes sense. Well, not really, but the ARForm is one of the most complicated Crystal Reports forms Vantage comes with. The form is executed differently depending upon how it's launched. Grouping levels are dynamically assigned in that form so what may be "Group1" when executing the ARForm from Invoice Tracker is not "Group1" when mass printing.

If you still are stuck feel free to email your generated XML (both data XMLs: mass print and single print) and your ARForm and if I get a few spare minutes today I can try and hack it out.

Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Mobile:Â 704.530.3092

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 9:27 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Here is what I am trying to do.
I have a customer who wants some special text to appear on their invoices.
I created a text object with these values and created a flag where if one of their three customerID appear on the invoice,
the text appears. For all other customers, supress.
This worked as designed when printing one invoice at a time, but when loaded into a group and mass printed, only the last
invoice is evaluated. I cannot find a way to evaluate at each invoice when group printing.
thanks for your help.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Wednesday, July 15, 2009 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Dick,

Are you trying to NOT group if Customer = 'XXXX' ???

You can suppress group headers and footers but you cannot control
grouping levels like that.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 8:52 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Tried at the InvNum Foot Group & page footer. still only supresses the
last invoice.
regards,

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Rob Bucek
Sent: Wednesday, July 15, 2009 7:59 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

Try suppressing at the group level, in the section expert place your
condition there

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On
Behalf
Of PLAMAN DICK
Sent: Wednesday, July 15, 2009 6:26 AM
To: 'vantage@yahoogroups.com<mailto:%27vantage%40yahoogroups.com><mailto:%27vantage%40yahoogroups.com>'
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

I have a flag (T1) defined as if CustID = 'XXXXX' then 1 else 0
Then on the text format I have supress if T1 <> 1.
This works fine if printed individually, but in a group, it seems that
the flag cannot be evaluated.
Only the last invoice in the group works.
regards,
________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Chris Thompson
Sent: Wednesday, July 15, 2009 7:07 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports - text supression - AR Form

What formula are you using with for the supress?

________________________________
From: PLAMAN DICK
<dplaman@...<mailto:dplaman%40tse-industries.com><mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>
<mailto:dplaman%40tse-industries.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>"
<vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>>
Sent: Wednesday, 15 July, 2009 11:44:44
Subject: [Vantage] Crystal Reports - text supression - AR Form

I have a crystal report that displays/supresses some text based upon the
CustomerID. The ARForm works fine if I print just
one, but does not work if I print a group (only the last one works).
I tried the WhilePrinting, WhileReading, etc, but the text supression
does not hide when printing a group. Does anyone know
if there is a solution to this?
TIA

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

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

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

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

[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

[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

system · July 15, 2009, 9:46am

vantage@yahoogroups.com wrote:

> Here is what I am trying to do.
> I have a customer who wants some special text to appear on
> their invoices.
> I created a text object with these values and created a flag
> where if one of their three customerID appear on the invoice,
> the text appears. For all other customers, supress.

I would put this text object in its own section (right mouse click on the
closest Group Header or Footer and choose Insert Section Below from the
context menu) and then put your suppression formula (custID <> "whatever")
in that section.

Mark W.

system · July 15, 2009, 9:55am

what Mark said is correct, we have added several little customizations to forms, including ARForm, and that's what we have done without troubles. 1 thing to be aware of is CRW is all about location, so it is important that your text box is inside your group that controls the suppression.

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 Mark Wonsil
Sent: Wednesday, July 15, 2009 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Reports - text supression - AR Form

vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> wrote:

> Here is what I am trying to do.
> I have a customer who wants some special text to appear on
> their invoices.
> I created a text object with these values and created a flag
> where if one of their three customerID appear on the invoice,
> the text appears. For all other customers, supress.

I would put this text object in its own section (right mouse click on the
closest Group Header or Footer and choose Insert Section Below from the
context menu) and then put your suppression formula (custID <> "whatever")
in that section.

Mark W.

________________________________
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]