Running Totals Reset Crystal Reports

I think Bill's idea is right, but believe the formula has to evaluate for the conditions you need; this is, create a formula assigning a "Y" if the conditions are met and a "N" if not.

IF ({PODetail.PONum} <> {PORel.PONum}) and ({PODetail.POLine} <> {PORel.POLine}) then "Y" else "N"

You reset your RT at change of this field (formula), though it will depend on your sorting and grouping order to have the correct breaks.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bill King
Sent: Monday, October 04, 2010 11:49 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Running Totals Reset Crystal Reports



Can you create a formula to concatenate your po/ln number and reset on change of that formula.

BILL R. KING
(806).776.4409 Office
(806).749.7119 Fax
(254).592.4397 Cell

________________________________
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of bturner101@...<mailto:bturner101%40sbcglobal.net>
Sent: Monday, October 04, 2010 11:26 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Running Totals Reset Crystal Reports

I am hoping someone can help me with a proper method of using a formula to reset a running total in a Crystal report.

I would like the running total to reset when the following conditions are satisfied:

{PODetail.PONum} <> {PORel.PONum} and {PODetail.POLine} <> {PORel.POLine}

I am trying to create a flat report with no groups to make it easily exportable to excel, which is what management wants. I want the RecDtl.VendorQty to sum into a running total so I can calculate the net balance of an open PO line.

Any help is greatly appreciated.

Brian Turner

________________________________
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 hoping someone can help me with a proper method of using a formula to reset a running total in a Crystal report.

I would like the running total to reset when the following conditions are satisfied:

{PODetail.PONum} <> {PORel.PONum} and {PODetail.POLine} <> {PORel.POLine}

I am trying to create a flat report with no groups to make it easily exportable to excel, which is what management wants. I want the RecDtl.VendorQty to sum into a running total so I can calculate the net balance of an open PO line.

Any help is greatly appreciated.

Brian Turner
Can you create a formula to concatenate your po/ln number and reset on change of that formula.



BILL R. KING
(806).776.4409 Office
(806).749.7119 Fax
(254).592.4397 Cell

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of bturner101@...
Sent: Monday, October 04, 2010 11:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Running Totals Reset Crystal Reports



I am hoping someone can help me with a proper method of using a formula to reset a running total in a Crystal report.

I would like the running total to reset when the following conditions are satisfied:

{PODetail.PONum} <> {PORel.PONum} and {PODetail.POLine} <> {PORel.POLine}

I am trying to create a flat report with no groups to make it easily exportable to excel, which is what management wants. I want the RecDtl.VendorQty to sum into a running total so I can calculate the net balance of an open PO line.

Any help is greatly appreciated.

Brian Turner


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