Thanks everyone. I got clued in by Terry
I wasn't creating ANOTHER reset formula in ANOTHER GH1a section before my GH1b subreport
WhilePrintingRecords;
Shared numbervar Delivery;
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Linda Lowney" <llowney@...>
Date: Fri, 18 Sep 2009 13:35:17
To: <vantage@yahoogroups.com>
Subject: RE: RE: [Vantage] Crystal Help
Are you resetting the shared variable to zero at the top of the
subreport?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Friday, September 18, 2009 12:01 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] Crystal Help
I swear I am having a brain fade on this it isn't working. Again, How do
you write the formula to evaluate the shared variable. I am getting
where
if there is no data in the subreport for the line the shared var from
previous line is repeating
I have my subreport placed in GH1 (I have it there because I have
duplicate records in Detail.
I have my formula in subreport to show total shipments in that subreport
WhilePrintingRecords;
Shared numbervar DeliveryQty :=Sum ({@TotalShipments});
I have in main report my formula in GF1 taking that Delivery qty and
using
it in another formula
WhilePrintingRecords;
Shared numberVar DeliveryQty
but on one line I get total shipments = 100
next line I get total shipments = 100 (even if there is 0 in the
subreport)
TIA
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Linda Lowney
Sent: Thursday, September 17, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: RE: [Vantage] Crystal Help
Hi Bill,
I usually create a formula in the subreport to reset the shared variable
to zero or a blank string or whatever and place it at the beginning of
the report in the header section.
Hth,
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of advantage@... <mailto:advantage%40wcoil.com>
Sent: Wednesday, September 16, 2009 5:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: RE: [Vantage] Crystal Help
Speaking of shared var. How do you write the formula to evaluate the
shared variable. I am getting where if there is no data in the subreport
for the line the shared var from previous line repeating
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: Bill King <bking@...
<mailto:bking%40jandbindustrial.com>
<mailto:bking%40jandbindustrial.com> >
Date: Wed, 16 Sep 2009 14:05:22
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com> '<
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: RE: RE: [Vantage] Crystal Help
set a variable in your subreport and pass it to your main report.
BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell
________________________________
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 Manasa Reddy
Sent: Wednesday, September 16, 2009 2:00 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Help
Somehow this subreport on each line does not print, but they print
individually where the Total for the order prints. This is where I
would like it summarized, but how do you summarize a subreport at the
bottom of the report?
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
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 Karen Schoenung
Sent: Wednesday, September 16, 2009 1:53 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Help
Can you sum at sales order level and suppress individual misc charge per
line?
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 Manasa Reddy
Sent: Wednesday, September 16, 2009 1:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Help
Probably...it is the standard form that comes with Vista....
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bill King
Sent: Wednesday, September 16, 2009 1:44 PM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com> '
Subject: RE: [Vantage] Crystal Help
do you have the sales tax in a sub-report?
BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Wednesday, September 16, 2009 1:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Help
I have to admit I have always hated the functions Crystal uses. So here
is my dilemma:
Sales Tax on Sales Orders. If every item on a Sales Order is taxed, the
miscellaneous charge shows at the bottom of the order FOR EACH LINE.
What would be the formula to consolidate this? Any help is always
appreciated!
M. Manasa Reddy
Information Technology Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
[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]
[Non-text portions of this message have been removed]
[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]
[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]
I wasn't creating ANOTHER reset formula in ANOTHER GH1a section before my GH1b subreport
WhilePrintingRecords;
Shared numbervar Delivery;
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Linda Lowney" <llowney@...>
Date: Fri, 18 Sep 2009 13:35:17
To: <vantage@yahoogroups.com>
Subject: RE: RE: [Vantage] Crystal Help
Are you resetting the shared variable to zero at the top of the
subreport?
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of advantage@...
Sent: Friday, September 18, 2009 12:01 PM
To: vantage@yahoogroups.com
Subject: RE: RE: [Vantage] Crystal Help
I swear I am having a brain fade on this it isn't working. Again, How do
you write the formula to evaluate the shared variable. I am getting
where
if there is no data in the subreport for the line the shared var from
previous line is repeating
I have my subreport placed in GH1 (I have it there because I have
duplicate records in Detail.
I have my formula in subreport to show total shipments in that subreport
WhilePrintingRecords;
Shared numbervar DeliveryQty :=Sum ({@TotalShipments});
I have in main report my formula in GF1 taking that Delivery qty and
using
it in another formula
WhilePrintingRecords;
Shared numberVar DeliveryQty
but on one line I get total shipments = 100
next line I get total shipments = 100 (even if there is 0 in the
subreport)
TIA
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Linda Lowney
Sent: Thursday, September 17, 2009 9:20 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: RE: [Vantage] Crystal Help
Hi Bill,
I usually create a formula in the subreport to reset the shared variable
to zero or a blank string or whatever and place it at the beginning of
the report in the header section.
Hth,
Linda
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of advantage@... <mailto:advantage%40wcoil.com>
Sent: Wednesday, September 16, 2009 5:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: RE: [Vantage] Crystal Help
Speaking of shared var. How do you write the formula to evaluate the
shared variable. I am getting where if there is no data in the subreport
for the line the shared var from previous line repeating
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: Bill King <bking@...
<mailto:bking%40jandbindustrial.com>
<mailto:bking%40jandbindustrial.com> >
Date: Wed, 16 Sep 2009 14:05:22
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com> '<
vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> >
Subject: RE: RE: [Vantage] Crystal Help
set a variable in your subreport and pass it to your main report.
BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell
________________________________
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 Manasa Reddy
Sent: Wednesday, September 16, 2009 2:00 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Help
Somehow this subreport on each line does not print, but they print
individually where the Total for the order prints. This is where I
would like it summarized, but how do you summarize a subreport at the
bottom of the report?
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
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 Karen Schoenung
Sent: Wednesday, September 16, 2009 1:53 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Help
Can you sum at sales order level and suppress individual misc charge per
line?
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 Manasa Reddy
Sent: Wednesday, September 16, 2009 1:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal Help
Probably...it is the standard form that comes with Vista....
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bill King
Sent: Wednesday, September 16, 2009 1:44 PM
To: 'vantage@yahoogroups.com <mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com>
<mailto:%27vantage%40yahoogroups.com> '
Subject: RE: [Vantage] Crystal Help
do you have the sales tax in a sub-report?
BILL R. KING
J&B Industrial Services
(806).776.4409 Office
(254).592.4397 Cell
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.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>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Wednesday, September 16, 2009 1:40 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Help
I have to admit I have always hated the functions Crystal uses. So here
is my dilemma:
Sales Tax on Sales Orders. If every item on a Sales Order is taxed, the
miscellaneous charge shows at the bottom of the order FOR EACH LINE.
What would be the formula to consolidate this? Any help is always
appreciated!
M. Manasa Reddy
Information Technology Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com> <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
[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]
[Non-text portions of this message have been removed]
[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]
[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]