Production Detail Crystal Report Modifications

just a FYI - there is a Crystal Report Group similar to this Vantage Group here on Yahoo that might be very helpful to several of you struggling with a CRW issue or two. There are some very knowledgeable folks and a few hacks such as myself but you'll soon learn who to listen to. Just a thought.


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 Sean Toler
Sent: Monday, April 05, 2010 1:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Production Detail Crystal Report Modifications



I think I sent you a private message, but I'm not sure.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "Sean McDaniel" <smcdanie@...> wrote:
>
> You can't display a shared variable within the same section that it is
> modified. I can't even tell you what results you may or may not get :o)
>
> What I typically do is add a new section directly below where a shared
> variable is set and put my "display" there.
>
> You also need to be careful as a section or object that is suppressed will
> not change a shared variable, but a section that is hidden will still set
> the shared variable.
>
> If you'd like you can send me the report and I can take a quick look for you
> (smcdaniel@...). If you have the XML data file that would be
> a great help so I don't need to try and reproduce one.
>
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> Sean Toler
> Sent: Monday, April 05, 2010 2:16 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Production Detail Crystal Report Modifications
>
>
>
>
>
> Sometimes I feel like the things that I'm asked to make happen whether it be
> in a BAQ, Dashboard, Customization, or in a Crystal Report require a
> four-year degree to understand and figure out!
>
> Anyway, I'm not sure if you guys utilize the Production Detail Report or
> not, but what I think I've discovered is that the Gross amount variable is
> created in the Invoice Activity SubReport.
>
> It is then recalled in Group Footer #2s. This footer displays the
> profitability of the current job in the report. If I select a number of jobs
> for the report, this footer is displayed at the end of each report for each
> job.
>
> But, when I try to recall this same variable in the report footer in an
> attempt to display the grand total for all of the jobs in the report, I've
> been either getting zero, or the gross amount for the last job in the
> selection.
>
> I haven't been able to come up with a way to get a grand total.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> , "Sean
> McDaniel" <smcdanie@> wrote:
> >
> > You'll need to do something like this in a formula.
> >
> > Then you drag the formula where you want it in your report.
> >
> > Shared NumberVar GrossAmt:=GrossAmt;
> > GrossAmt
> >
> >
> >
> > 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
> > Sean Toler
> > Sent: Monday, April 05, 2010 1:42 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Production Detail Crystal Report Modifications
> >
> >
> >
> >
> >
> > OK, I have no idea how to make this work.
> >
> > How can I get the report to give me a grand total in the report footer
> using
> > these shared variables?
> >
> > Everything I try either gives me zeroes or the incorrect amount.
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Sean
> > Toler" <seantoler@> wrote:
> > >
> > > Looks like I have a lot more to learn about Crystal. I haven't had to
> work
> > with variables before.
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Sean
> > McDaniel" <smcdanie@> wrote:
> > > >
> > > > This is a shared variable. So, while you are editing the formula, do a
> > > > search for "GrossAmt" and see what comes up. My guess is that there is
> > > > another formula that is something like "GrossAmt := GrossAmt + ."
> > > >
> > > >
> > > >
> > > > 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
> > > > Sean Toler
> > > > Sent: Monday, April 05, 2010 10:17 AM
> > > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Production Detail Crystal Report Modifications
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hello.
> > > > I've been asked to modify our Production Detail Report so it will give
> a
> > > > grand total of the prices of the products (gross amount, misc.
> charges,
> > net
> > > > amount). I see where this is done on the report for each job, but what
> > we
> > > > want to be able to do is to have a grand total at the end of the
> report
> > when
> > > > the report consists of multiple jobs (the report already does this for
> > the
> > > > costs and hours).
> > > >
> > > > There is a formula used on the report that brings in the gross amount
> on
> > > > each job, but it is a type of formula that I am not familiar with. I
> > tried
> > > > to do a summary of it, but CR wouldn't let me. The formula is called
> > > > VarGrossAmount and its code is as follows:
> > > > Shared NumberVar GrossAmt:=GrossAmt;
> > > > GrossAmt
> > > >
> > > > Does anyone know if this formula can be modified to give a grand
> total,
> > or
> > > > if a new one can be written that will give me the desired result?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
Hello.
I've been asked to modify our Production Detail Report so it will give a grand total of the prices of the products (gross amount, misc. charges, net amount). I see where this is done on the report for each job, but what we want to be able to do is to have a grand total at the end of the report when the report consists of multiple jobs (the report already does this for the costs and hours).

There is a formula used on the report that brings in the gross amount on each job, but it is a type of formula that I am not familiar with. I tried to do a summary of it, but CR wouldn't let me. The formula is called VarGrossAmount and its code is as follows:
Shared NumberVar GrossAmt:=GrossAmt;
GrossAmt

Does anyone know if this formula can be modified to give a grand total, or if a new one can be written that will give me the desired result?
This is a shared variable. So, while you are editing the formula, do a
search for "GrossAmt" and see what comes up. My guess is that there is
another formula that is something like "GrossAmt := GrossAmt + ."



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean Toler
Sent: Monday, April 05, 2010 10:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Production Detail Crystal Report Modifications





Hello.
I've been asked to modify our Production Detail Report so it will give a
grand total of the prices of the products (gross amount, misc. charges, net
amount). I see where this is done on the report for each job, but what we
want to be able to do is to have a grand total at the end of the report when
the report consists of multiple jobs (the report already does this for the
costs and hours).

There is a formula used on the report that brings in the gross amount on
each job, but it is a type of formula that I am not familiar with. I tried
to do a summary of it, but CR wouldn't let me. The formula is called
VarGrossAmount and its code is as follows:
Shared NumberVar GrossAmt:=GrossAmt;
GrossAmt

Does anyone know if this formula can be modified to give a grand total, or
if a new one can be written that will give me the desired result?





[Non-text portions of this message have been removed]
Looks like I have a lot more to learn about Crystal. I haven't had to work with variables before.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> This is a shared variable. So, while you are editing the formula, do a
> search for "GrossAmt" and see what comes up. My guess is that there is
> another formula that is something like "GrossAmt := GrossAmt + ."
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Sean Toler
> Sent: Monday, April 05, 2010 10:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Production Detail Crystal Report Modifications
>
>
>
>
>
> Hello.
> I've been asked to modify our Production Detail Report so it will give a
> grand total of the prices of the products (gross amount, misc. charges, net
> amount). I see where this is done on the report for each job, but what we
> want to be able to do is to have a grand total at the end of the report when
> the report consists of multiple jobs (the report already does this for the
> costs and hours).
>
> There is a formula used on the report that brings in the gross amount on
> each job, but it is a type of formula that I am not familiar with. I tried
> to do a summary of it, but CR wouldn't let me. The formula is called
> VarGrossAmount and its code is as follows:
> Shared NumberVar GrossAmt:=GrossAmt;
> GrossAmt
>
> Does anyone know if this formula can be modified to give a grand total, or
> if a new one can be written that will give me the desired result?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
OK, I have no idea how to make this work.

How can I get the report to give me a grand total in the report footer using these shared variables?

Everything I try either gives me zeroes or the incorrect amount.

--- In vantage@yahoogroups.com, "Sean Toler" <seantoler@...> wrote:
>
> Looks like I have a lot more to learn about Crystal. I haven't had to work with variables before.
>
> --- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@> wrote:
> >
> > This is a shared variable. So, while you are editing the formula, do a
> > search for "GrossAmt" and see what comes up. My guess is that there is
> > another formula that is something like "GrossAmt := GrossAmt + ."
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> > Sean Toler
> > Sent: Monday, April 05, 2010 10:17 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Production Detail Crystal Report Modifications
> >
> >
> >
> >
> >
> > Hello.
> > I've been asked to modify our Production Detail Report so it will give a
> > grand total of the prices of the products (gross amount, misc. charges, net
> > amount). I see where this is done on the report for each job, but what we
> > want to be able to do is to have a grand total at the end of the report when
> > the report consists of multiple jobs (the report already does this for the
> > costs and hours).
> >
> > There is a formula used on the report that brings in the gross amount on
> > each job, but it is a type of formula that I am not familiar with. I tried
> > to do a summary of it, but CR wouldn't let me. The formula is called
> > VarGrossAmount and its code is as follows:
> > Shared NumberVar GrossAmt:=GrossAmt;
> > GrossAmt
> >
> > Does anyone know if this formula can be modified to give a grand total, or
> > if a new one can be written that will give me the desired result?
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
Not a big deal - but different.

You have local variables - only visible during the time of a formula

You have Global variables - visible to anything anywhere within the current
report.

You have shared variables - visible to anything, anywhere in current or sub
reports



The shared variables come in really handy at times.

For example let's say that you wanted to track 57 totals in a report.

You could go through and add 57 summaries or running totals - very
monotonous .

You could also create a single formula called "Processing". Within it you
create your 57 shared variables to hold your summary info and then modify
your totals within that one formula.



Typically with shared variables I have a "reset formula", a "process
formula" and a "display formula". I'll reset shared variables on a change of
group and display the shared variable at the group/report end.

Once you do this a couple of times it becomes a really powerful tool that is
relative easy to use.



The weird thing is that anytime you use a variable like this you have to
first declare it (even though it's declared someplace else).



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean Toler
Sent: Monday, April 05, 2010 12:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Production Detail Crystal Report Modifications





Looks like I have a lot more to learn about Crystal. I haven't had to work
with variables before.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> This is a shared variable. So, while you are editing the formula, do a
> search for "GrossAmt" and see what comes up. My guess is that there is
> another formula that is something like "GrossAmt := GrossAmt + ."
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Sean Toler
> Sent: Monday, April 05, 2010 10:17 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Production Detail Crystal Report Modifications
>
>
>
>
>
> Hello.
> I've been asked to modify our Production Detail Report so it will give a
> grand total of the prices of the products (gross amount, misc. charges,
net
> amount). I see where this is done on the report for each job, but what we
> want to be able to do is to have a grand total at the end of the report
when
> the report consists of multiple jobs (the report already does this for the
> costs and hours).
>
> There is a formula used on the report that brings in the gross amount on
> each job, but it is a type of formula that I am not familiar with. I tried
> to do a summary of it, but CR wouldn't let me. The formula is called
> VarGrossAmount and its code is as follows:
> Shared NumberVar GrossAmt:=GrossAmt;
> GrossAmt
>
> Does anyone know if this formula can be modified to give a grand total, or
> if a new one can be written that will give me the desired result?
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
You'll need to do something like this in a formula.

Then you drag the formula where you want it in your report.

Shared NumberVar GrossAmt:=GrossAmt;
GrossAmt



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean Toler
Sent: Monday, April 05, 2010 1:42 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Production Detail Crystal Report Modifications





OK, I have no idea how to make this work.

How can I get the report to give me a grand total in the report footer using
these shared variables?

Everything I try either gives me zeroes or the incorrect amount.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
Toler" <seantoler@...> wrote:
>
> Looks like I have a lot more to learn about Crystal. I haven't had to work
with variables before.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@> wrote:
> >
> > This is a shared variable. So, while you are editing the formula, do a
> > search for "GrossAmt" and see what comes up. My guess is that there is
> > another formula that is something like "GrossAmt := GrossAmt + ."
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> > Sean Toler
> > Sent: Monday, April 05, 2010 10:17 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Production Detail Crystal Report Modifications
> >
> >
> >
> >
> >
> > Hello.
> > I've been asked to modify our Production Detail Report so it will give a
> > grand total of the prices of the products (gross amount, misc. charges,
net
> > amount). I see where this is done on the report for each job, but what
we
> > want to be able to do is to have a grand total at the end of the report
when
> > the report consists of multiple jobs (the report already does this for
the
> > costs and hours).
> >
> > There is a formula used on the report that brings in the gross amount on
> > each job, but it is a type of formula that I am not familiar with. I
tried
> > to do a summary of it, but CR wouldn't let me. The formula is called
> > VarGrossAmount and its code is as follows:
> > Shared NumberVar GrossAmt:=GrossAmt;
> > GrossAmt
> >
> > Does anyone know if this formula can be modified to give a grand total,
or
> > if a new one can be written that will give me the desired result?
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>





[Non-text portions of this message have been removed]
Sometimes I feel like the things that I'm asked to make happen whether it be in a BAQ, Dashboard, Customization, or in a Crystal Report require a four-year degree to understand and figure out!

Anyway, I'm not sure if you guys utilize the Production Detail Report or not, but what I think I've discovered is that the Gross amount variable is created in the Invoice Activity SubReport.

It is then recalled in Group Footer #2s. This footer displays the profitability of the current job in the report. If I select a number of jobs for the report, this footer is displayed at the end of each report for each job.

But, when I try to recall this same variable in the report footer in an attempt to display the grand total for all of the jobs in the report, I've been either getting zero, or the gross amount for the last job in the selection.

I haven't been able to come up with a way to get a grand total.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> You'll need to do something like this in a formula.
>
> Then you drag the formula where you want it in your report.
>
> Shared NumberVar GrossAmt:=GrossAmt;
> GrossAmt
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Sean Toler
> Sent: Monday, April 05, 2010 1:42 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Production Detail Crystal Report Modifications
>
>
>
>
>
> OK, I have no idea how to make this work.
>
> How can I get the report to give me a grand total in the report footer using
> these shared variables?
>
> Everything I try either gives me zeroes or the incorrect amount.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
> Toler" <seantoler@> wrote:
> >
> > Looks like I have a lot more to learn about Crystal. I haven't had to work
> with variables before.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
> McDaniel" <smcdanie@> wrote:
> > >
> > > This is a shared variable. So, while you are editing the formula, do a
> > > search for "GrossAmt" and see what comes up. My guess is that there is
> > > another formula that is something like "GrossAmt := GrossAmt + ."
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > > Sean Toler
> > > Sent: Monday, April 05, 2010 10:17 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Production Detail Crystal Report Modifications
> > >
> > >
> > >
> > >
> > >
> > > Hello.
> > > I've been asked to modify our Production Detail Report so it will give a
> > > grand total of the prices of the products (gross amount, misc. charges,
> net
> > > amount). I see where this is done on the report for each job, but what
> we
> > > want to be able to do is to have a grand total at the end of the report
> when
> > > the report consists of multiple jobs (the report already does this for
> the
> > > costs and hours).
> > >
> > > There is a formula used on the report that brings in the gross amount on
> > > each job, but it is a type of formula that I am not familiar with. I
> tried
> > > to do a summary of it, but CR wouldn't let me. The formula is called
> > > VarGrossAmount and its code is as follows:
> > > Shared NumberVar GrossAmt:=GrossAmt;
> > > GrossAmt
> > >
> > > Does anyone know if this formula can be modified to give a grand total,
> or
> > > if a new one can be written that will give me the desired result?
> > >
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
You can't display a shared variable within the same section that it is
modified. I can't even tell you what results you may or may not get :o)

What I typically do is add a new section directly below where a shared
variable is set and put my "display" there.

You also need to be careful as a section or object that is suppressed will
not change a shared variable, but a section that is hidden will still set
the shared variable.

If you'd like you can send me the report and I can take a quick look for you
(smcdaniel@...). If you have the XML data file that would be
a great help so I don't need to try and reproduce one.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean Toler
Sent: Monday, April 05, 2010 2:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Production Detail Crystal Report Modifications





Sometimes I feel like the things that I'm asked to make happen whether it be
in a BAQ, Dashboard, Customization, or in a Crystal Report require a
four-year degree to understand and figure out!

Anyway, I'm not sure if you guys utilize the Production Detail Report or
not, but what I think I've discovered is that the Gross amount variable is
created in the Invoice Activity SubReport.

It is then recalled in Group Footer #2s. This footer displays the
profitability of the current job in the report. If I select a number of jobs
for the report, this footer is displayed at the end of each report for each
job.

But, when I try to recall this same variable in the report footer in an
attempt to display the grand total for all of the jobs in the report, I've
been either getting zero, or the gross amount for the last job in the
selection.

I haven't been able to come up with a way to get a grand total.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
McDaniel" <smcdanie@...> wrote:
>
> You'll need to do something like this in a formula.
>
> Then you drag the formula where you want it in your report.
>
> Shared NumberVar GrossAmt:=GrossAmt;
> GrossAmt
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Sean Toler
> Sent: Monday, April 05, 2010 1:42 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Production Detail Crystal Report Modifications
>
>
>
>
>
> OK, I have no idea how to make this work.
>
> How can I get the report to give me a grand total in the report footer
using
> these shared variables?
>
> Everything I try either gives me zeroes or the incorrect amount.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Sean
> Toler" <seantoler@> wrote:
> >
> > Looks like I have a lot more to learn about Crystal. I haven't had to
work
> with variables before.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , "Sean
> McDaniel" <smcdanie@> wrote:
> > >
> > > This is a shared variable. So, while you are editing the formula, do a
> > > search for "GrossAmt" and see what comes up. My guess is that there is
> > > another formula that is something like "GrossAmt := GrossAmt + ."
> > >
> > >
> > >
> > > 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
> > > Sean Toler
> > > Sent: Monday, April 05, 2010 10:17 AM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Production Detail Crystal Report Modifications
> > >
> > >
> > >
> > >
> > >
> > > Hello.
> > > I've been asked to modify our Production Detail Report so it will give
a
> > > grand total of the prices of the products (gross amount, misc.
charges,
> net
> > > amount). I see where this is done on the report for each job, but what
> we
> > > want to be able to do is to have a grand total at the end of the
report
> when
> > > the report consists of multiple jobs (the report already does this for
> the
> > > costs and hours).
> > >
> > > There is a formula used on the report that brings in the gross amount
on
> > > each job, but it is a type of formula that I am not familiar with. I
> tried
> > > to do a summary of it, but CR wouldn't let me. The formula is called
> > > VarGrossAmount and its code is as follows:
> > > Shared NumberVar GrossAmt:=GrossAmt;
> > > GrossAmt
> > >
> > > Does anyone know if this formula can be modified to give a grand
total,
> or
> > > if a new one can be written that will give me the desired result?
> > >
> > >
> > >
> > >
> > >
> > > [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 think I sent you a private message, but I'm not sure.

--- In vantage@yahoogroups.com, "Sean McDaniel" <smcdanie@...> wrote:
>
> You can't display a shared variable within the same section that it is
> modified. I can't even tell you what results you may or may not get :o)
>
> What I typically do is add a new section directly below where a shared
> variable is set and put my "display" there.
>
> You also need to be careful as a section or object that is suppressed will
> not change a shared variable, but a section that is hidden will still set
> the shared variable.
>
> If you'd like you can send me the report and I can take a quick look for you
> (smcdaniel@...). If you have the XML data file that would be
> a great help so I don't need to try and reproduce one.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Sean Toler
> Sent: Monday, April 05, 2010 2:16 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Production Detail Crystal Report Modifications
>
>
>
>
>
> Sometimes I feel like the things that I'm asked to make happen whether it be
> in a BAQ, Dashboard, Customization, or in a Crystal Report require a
> four-year degree to understand and figure out!
>
> Anyway, I'm not sure if you guys utilize the Production Detail Report or
> not, but what I think I've discovered is that the Gross amount variable is
> created in the Invoice Activity SubReport.
>
> It is then recalled in Group Footer #2s. This footer displays the
> profitability of the current job in the report. If I select a number of jobs
> for the report, this footer is displayed at the end of each report for each
> job.
>
> But, when I try to recall this same variable in the report footer in an
> attempt to display the grand total for all of the jobs in the report, I've
> been either getting zero, or the gross amount for the last job in the
> selection.
>
> I haven't been able to come up with a way to get a grand total.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
> McDaniel" <smcdanie@> wrote:
> >
> > You'll need to do something like this in a formula.
> >
> > Then you drag the formula where you want it in your report.
> >
> > Shared NumberVar GrossAmt:=GrossAmt;
> > GrossAmt
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > Sean Toler
> > Sent: Monday, April 05, 2010 1:42 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Re: Production Detail Crystal Report Modifications
> >
> >
> >
> >
> >
> > OK, I have no idea how to make this work.
> >
> > How can I get the report to give me a grand total in the report footer
> using
> > these shared variables?
> >
> > Everything I try either gives me zeroes or the incorrect amount.
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Sean
> > Toler" <seantoler@> wrote:
> > >
> > > Looks like I have a lot more to learn about Crystal. I haven't had to
> work
> > with variables before.
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , "Sean
> > McDaniel" <smcdanie@> wrote:
> > > >
> > > > This is a shared variable. So, while you are editing the formula, do a
> > > > search for "GrossAmt" and see what comes up. My guess is that there is
> > > > another formula that is something like "GrossAmt := GrossAmt + ."
> > > >
> > > >
> > > >
> > > > 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
> > > > Sean Toler
> > > > Sent: Monday, April 05, 2010 10:17 AM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Production Detail Crystal Report Modifications
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hello.
> > > > I've been asked to modify our Production Detail Report so it will give
> a
> > > > grand total of the prices of the products (gross amount, misc.
> charges,
> > net
> > > > amount). I see where this is done on the report for each job, but what
> > we
> > > > want to be able to do is to have a grand total at the end of the
> report
> > when
> > > > the report consists of multiple jobs (the report already does this for
> > the
> > > > costs and hours).
> > > >
> > > > There is a formula used on the report that brings in the gross amount
> on
> > > > each job, but it is a type of formula that I am not familiar with. I
> > tried
> > > > to do a summary of it, but CR wouldn't let me. The formula is called
> > > > VarGrossAmount and its code is as follows:
> > > > Shared NumberVar GrossAmt:=GrossAmt;
> > > > GrossAmt
> > > >
> > > > Does anyone know if this formula can be modified to give a grand
> total,
> > or
> > > > if a new one can be written that will give me the desired result?
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > [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]
>