# Crystal Report Date formula

You can do a "Previous" function to look at the previous recordset value. If
it is the same then don't display it.

I think there is also a checkbox to suppress duplicates in the object itself

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
liss_c
Sent: Thursday, March 11, 2010 4:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Date formula

That work Steve! I just used the MIN but how can you supress a field from
duplicating??

Thanks,

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Bill
King <bking@...> wrote:
>
> make a formula using the min or max then tell it to suppress duplicates.
>
>
> Stevie Wonder
> J&B Industrial Services
> (806).776.4409 Office
> (254).592.4397 Cell
>
>
>
> ________________________________
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of liss_c
> Sent: Thursday, March 11, 2010 3:03 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Crystal Report Date formula
>
>
>
> I know where to find it. Is the POrel.Duedate. But what i am trying to do
is to have a general needed date for the entire PO by using only the first
line's due date.
>
> What i need to do is:
>
> a)Put a condition in crystal that will only let me print the date in the
first page only , or
>
> b)lock that date for the very first line of the PO and display it in all
the pages of the PO.
>
> Hope this makes more sense.
>
> Lissette
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>, "Late, Travis" <tlate@> wrote:
> >
> > Are you looking for a due date for the PO line?
> >
> >
> >
> > 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 liss_c
> > Sent: Thursday, March 11, 2010 1:56 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Crystal Report Date formula
> >
> >
> >
> >
> >
> > I am trying to add a overall date for the PO crystal report. Currently
> > is showing the dates for each lines. However since most of this dates
> > are the same I just want the PO to display the first line date. Any
> > ideas which formula i could use to calculate the very first line date
> > only for my PO?
> >
> > thanks,
> >
> > Lissette Contreras
> >
> >
> >
> >
> >
> >
> > M-B Companies Confidentiality Notice:
> > This message is being sent by M-B Companies. It is intended exclusively
for
> > the individuals and entities to which it is addressed. This
communication,
> > including any attachments, may contain information that is proprietary,
> > privileged and confidential if you are not the named addressee; you are
not
> > authorized to read,print,retain copy or disseminate this message or any
part
> > of it.If you have received this message in error, please notify the
sender
> > immediately by email.
> >
> > [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]
>

[Non-text portions of this message have been removed]
I am trying to add a overall date for the PO crystal report. Currently is showing the dates for each lines. However since most of this dates are the same I just want the PO to display the first line date. Any ideas which formula i could use to calculate the very first line date only for my PO?

thanks,

Lissette Contreras
Are you looking for a due date for the PO line?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of liss_c
Sent: Thursday, March 11, 2010 1:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Report Date formula

I am trying to add a overall date for the PO crystal report. Currently
is showing the dates for each lines. However since most of this dates
are the same I just want the PO to display the first line date. Any
ideas which formula i could use to calculate the very first line date
only for my PO?

thanks,

Lissette Contreras

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively for
the individuals and entities to which it is addressed. This communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are not
authorized to read,print,retain copy or disseminate this message or any part
of it.If you have received this message in error, please notify the sender
immediately by email.

[Non-text portions of this message have been removed]
I know where to find it. Is the POrel.Duedate. But what i am trying to do is to have a general needed date for the entire PO by using only the first line's due date.

What i need to do is:

a)Put a condition in crystal that will only let me print the date in the first page only , or

b)lock that date for the very first line of the PO and display it in all the pages of the PO.

Hope this makes more sense.

Lissette

--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
>
> Are you looking for a due date for the PO line?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of liss_c
> Sent: Thursday, March 11, 2010 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report Date formula
>
>
>
>
>
> I am trying to add a overall date for the PO crystal report. Currently
> is showing the dates for each lines. However since most of this dates
> are the same I just want the PO to display the first line date. Any
> ideas which formula i could use to calculate the very first line date
> only for my PO?
>
> thanks,
>
> Lissette Contreras
>
>
>
>
>
>
> M-B Companies Confidentiality Notice:
> This message is being sent by M-B Companies. It is intended exclusively for
> the individuals and entities to which it is addressed. This communication,
> including any attachments, may contain information that is proprietary,
> privileged and confidential if you are not the named addressee; you are not
> authorized to read,print,retain copy or disseminate this message or any part
> of it.If you have received this message in error, please notify the sender
> immediately by email.
>
> [Non-text portions of this message have been removed]
>
make a formula using the min or max then tell it to suppress duplicates.

Stevie Wonder
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of liss_c
Sent: Thursday, March 11, 2010 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Date formula

I know where to find it. Is the POrel.Duedate. But what i am trying to do is to have a general needed date for the entire PO by using only the first line's due date.

What i need to do is:

a)Put a condition in crystal that will only let me print the date in the first page only , or

b)lock that date for the very first line of the PO and display it in all the pages of the PO.

Hope this makes more sense.

Lissette

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Late, Travis" <tlate@...> wrote:
>
> Are you looking for a due date for the PO line?
>
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> Of liss_c
> Sent: Thursday, March 11, 2010 1:56 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Report Date formula
>
>
>
>
>
> I am trying to add a overall date for the PO crystal report. Currently
> is showing the dates for each lines. However since most of this dates
> are the same I just want the PO to display the first line date. Any
> ideas which formula i could use to calculate the very first line date
> only for my PO?
>
> thanks,
>
> Lissette Contreras
>
>
>
>
>
>
> M-B Companies Confidentiality Notice:
> This message is being sent by M-B Companies. It is intended exclusively for
> the individuals and entities to which it is addressed. This communication,
> including any attachments, may contain information that is proprietary,
> privileged and confidential if you are not the named addressee; you are not
> authorized to read,print,retain copy or disseminate this message or any part
> of it.If you have received this message in error, please notify the sender
> immediately by email.
>
> [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]
I know where to find it. Is the POrel.Duedate. But what i am trying to do is to have a general needed date for the entire PO by using only the first line's due date.

What i need to do is:

a)Put a condition in crystal that will only let me print the date in the first page only , or

b)lock that date for the very first line of the PO and display it in all the pages of the PO.

Hope this makes more sense.

Lissette

--- In vantage@yahoogroups.com, "Late, Travis" <tlate@...> wrote:
>
> Are you looking for a due date for the PO line?
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of liss_c
> Sent: Thursday, March 11, 2010 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Report Date formula
>
>
>
>
>
> I am trying to add a overall date for the PO crystal report. Currently
> is showing the dates for each lines. However since most of this dates
> are the same I just want the PO to display the first line date. Any
> ideas which formula i could use to calculate the very first line date
> only for my PO?
>
> thanks,
>
> Lissette Contreras
>
>
>
>
>
>
> M-B Companies Confidentiality Notice:
> This message is being sent by M-B Companies. It is intended exclusively for
> the individuals and entities to which it is addressed. This communication,
> including any attachments, may contain information that is proprietary,
> privileged and confidential if you are not the named addressee; you are not
> authorized to read,print,retain copy or disseminate this message or any part
> of it.If you have received this message in error, please notify the sender
> immediately by email.
>
> [Non-text portions of this message have been removed]
>
Lissette,

* If you right click on the POREL.DUEDATE and click Format
Field.

* Then select the Common tab.

* Check the box that says: Suppress

* Then select the formula box and put in this formula:
{PORel.POLine}>1

* This should work.

Thanks,

Travis

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of liss_c
Sent: Thursday, March 11, 2010 3:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal Report Date formula

I know where to find it. Is the POrel.Duedate. But what i am trying to
do is to have a general needed date for the entire PO by using only the
first line's due date.

What i need to do is:

a)Put a condition in crystal that will only let me print the date in the
first page only , or

b)lock that date for the very first line of the PO and display it in all
the pages of the PO.

Hope this makes more sense.

Lissette

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Late, Travis" <tlate@...> wrote:
>
> Are you looking for a due date for the PO line?
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of liss_c
> Sent: Thursday, March 11, 2010 1:56 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Crystal Report Date formula
>
>
>
>
>
> I am trying to add a overall date for the PO crystal report. Currently
> is showing the dates for each lines. However since most of this dates
> are the same I just want the PO to display the first line date. Any
> ideas which formula i could use to calculate the very first line date
> only for my PO?
>
> thanks,
>
> Lissette Contreras
>
>
>
>
>
>
> M-B Companies Confidentiality Notice:
> This message is being sent by M-B Companies. It is intended
exclusively for
> the individuals and entities to which it is addressed. This
communication,
> including any attachments, may contain information that is
proprietary,
> privileged and confidential if you are not the named addressee; you
are not
> authorized to read,print,retain copy or disseminate this message or
any part
> of it.If you have received this message in error, please notify the
sender
> immediately by email.
>
> [Non-text portions of this message have been removed]
>

M-B Companies Confidentiality Notice:
This message is being sent by M-B Companies. It is intended exclusively for
the individuals and entities to which it is addressed. This communication,
including any attachments, may contain information that is proprietary,
privileged and confidential if you are not the named addressee; you are not
authorized to read,print,retain copy or disseminate this message or any part
of it.If you have received this message in error, please notify the sender
immediately by email.

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

--- In vantage@yahoogroups.com, "liss_c" <lissette.contreras@...> wrote:
>
> I am trying to add a overall date for the PO crystal report. Currently is showing the dates for each lines. However since most of this dates are the same I just want the PO to display the first line date. Any ideas which formula i could use to calculate the very first line date only for my PO?
>
> thanks,
>
> Lissette Contreras
>
That work Steve! I just used the MIN but how can you supress a field from duplicating??

Thanks,

--- In vantage@yahoogroups.com, Bill King <bking@...> wrote:
>
> make a formula using the min or max then tell it to suppress duplicates.
>
>
> Stevie Wonder
> J&B Industrial Services
> (806).776.4409 Office
> (254).592.4397 Cell
>
>
>
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of liss_c
> Sent: Thursday, March 11, 2010 3:03 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report Date formula
>
>
>
> I know where to find it. Is the POrel.Duedate. But what i am trying to do is to have a general needed date for the entire PO by using only the first line's due date.
>
> What i need to do is:
>
> a)Put a condition in crystal that will only let me print the date in the first page only , or
>
> b)lock that date for the very first line of the PO and display it in all the pages of the PO.
>
> Hope this makes more sense.
>
> Lissette
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Late, Travis" <tlate@> wrote:
> >
> > Are you looking for a due date for the PO line?
> >
> >
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
> > Of liss_c
> > Sent: Thursday, March 11, 2010 1:56 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Crystal Report Date formula
> >
> >
> >
> >
> >
> > I am trying to add a overall date for the PO crystal report. Currently
> > is showing the dates for each lines. However since most of this dates
> > are the same I just want the PO to display the first line date. Any
> > ideas which formula i could use to calculate the very first line date
> > only for my PO?
> >
> > thanks,
> >
> > Lissette Contreras
> >
> >
> >
> >
> >
> >
> > M-B Companies Confidentiality Notice:
> > This message is being sent by M-B Companies. It is intended exclusively for
> > the individuals and entities to which it is addressed. This communication,
> > including any attachments, may contain information that is proprietary,
> > privileged and confidential if you are not the named addressee; you are not
> > authorized to read,print,retain copy or disseminate this message or any part
> > of it.If you have received this message in error, please notify the sender
> > immediately by email.
> >
> > [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]
>