Quote Form Totals

Yahoo Archive
1
Cathy,
That's what I've done but it still doesn't subtotal the misc. charges, it only uses one of the charges for some reason.

--- In vantage@yahoogroups.com, "Cathy" <cathy@...> wrote:
>
> You will need to do a subtotal on the misc charges in the sub-report and
> make this a shared variable.
>
>
>
> This is what we used in the subreport
>
>
>
> Shared NumberVar TSQuoteMiscCharges;
>
>
>
> TSQuoteMiscCharges := Sum ({QuoteLnMsc.MiscAmt})
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Sean Toler
> Sent: Friday, February 15, 2013 10:32 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Quote Form Totals
>
>
>
>
>
> Thanks. I gave that a try and was able to get some success, however, if
> there are multiple lines with multiple misc. charges, the misc. charges are
> not being summarized. It is only using one of the misc. charges in the final
> calculation.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "CalvinDekker" wrote:
> >
> > Sean -
> >
> > You may want to check out this instructional message:
> >
> http://forums.codeguru.com/showthread.php?449494-How-to-get-formula-field-va
> lue-from-Subreport-to-main-report
> >
> > Then use another formula field to add up the values returned from the
> sub-report(s). This must be placed in a report section that is displayed
> after the sub-report section(s)
> >
> > Hope this helps,
> > Calvin Dekker
> > Office: 630-672-7688 Ext. 1484
> > Email: calvin@
> > http://www.codabears.com
> >
> >
> > "No trees were harmed during the sending of this message, however a large
> number of electrons were terribly inconvenienced."
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
> Toler" wrote:
> > >
> > > Hello,
> > > I have been asked to add a line at the bottom of our quote form that
> gives a grand total. At first I thought this would be easily done with a
> summary of the @extendedprice formula until I noticed the Line Misc Charges
> subreport. I have very limited experience with shared variables and have
> been attempting to create one that would allow me to add the total misc
> charges to the total extended price but can not get it to work.
> > > Can someone walk me through this?
> > >
> > > Thanks!
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Hello,
I have been asked to add a line at the bottom of our quote form that gives a grand total. At first I thought this would be easily done with a summary of the @extendedprice formula until I noticed the Line Misc Charges subreport. I have very limited experience with shared variables and have been attempting to create one that would allow me to add the total misc charges to the total extended price but can not get it to work.
Can someone walk me through this?

Thanks!
3
You can still create your own, the Misc Tables are available to you outside
the sub report simply add together the misc charges , and add together the
lines, then add both of those together.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Fri, Feb 15, 2013 at 10:44 AM, Sean Toler <seantoler@...>wrote:

> **
>
>
> Hello,
> I have been asked to add a line at the bottom of our quote form that gives
> a grand total. At first I thought this would be easily done with a summary
> of the @extendedprice formula until I noticed the Line Misc Charges
> subreport. I have very limited experience with shared variables and have
> been attempting to create one that would allow me to add the total misc
> charges to the total extended price but can not get it to work.
> Can someone walk me through this?
>
> Thanks!
>
>
>


[Non-text portions of this message have been removed]
4
OK, that worked great until I tested removing the misc. charges and everything on the form disappeared when I did a print preview.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> You can still create your own, the Misc Tables are available to you outside
> the sub report simply add together the misc charges , and add together the
> lines, then add both of those together.
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Fri, Feb 15, 2013 at 10:44 AM, Sean Toler <seantoler@...>wrote:
>
> > **
> >
> >
> > Hello,
> > I have been asked to add a line at the bottom of our quote form that gives
> > a grand total. At first I thought this would be easily done with a summary
> > of the @extendedprice formula until I noticed the Line Misc Charges
> > subreport. I have very limited experience with shared variables and have
> > been attempting to create one that would allow me to add the total misc
> > charges to the total extended price but can not get it to work.
> > Can someone walk me through this?
> >
> > Thanks!
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
5
On your Final Sum do a Check For Null on your MiscTotal if its Null replace
with 0

Somethign like

YourLineTotla + If IsNull(yourMisctotal) then 0 else yourmisctotal


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Fri, Feb 15, 2013 at 11:11 AM, Sean Toler <seantoler@...>wrote:

> **
>
>
> OK, that worked great until I tested removing the misc. charges and
> everything on the form disappeared when I did a print preview.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > You can still create your own, the Misc Tables are available to you
> outside
> > the sub report simply add together the misc charges , and add together
> the
> > lines, then add both of those together.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > http://www.linkedin.com/in/josecgomez> http://www.facebook.com/josegomez
> >
> > http://www.google.com/profiles/jose.gomez> http://www.twitter.com/joc85>
> > http://www.josecgomez.com/professional-resume/>
> > http://www.josecgomez.com/feed/>
> > http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Fri, Feb 15, 2013 at 10:44 AM, Sean Toler wrote:
> >
> > > **
>
> > >
> > >
> > > Hello,
> > > I have been asked to add a line at the bottom of our quote form that
> gives
> > > a grand total. At first I thought this would be easily done with a
> summary
> > > of the @extendedprice formula until I noticed the Line Misc Charges
> > > subreport. I have very limited experience with shared variables and
> have
> > > been attempting to create one that would allow me to add the total misc
> > > charges to the total extended price but can not get it to work.
> > > Can someone walk me through this?
> > >
> > > Thanks!
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
6
OK,
I got that idea too, so I created this formula:
If isnull(Sum ({@LineMiscAmount})) then (Sum ({@Extended Price}))
else
(Sum ({@LineMiscAmount})) + (Sum ({@Extended Price}))

But the same thing happens. Where would I substitute in your formula?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> On your Final Sum do a Check For Null on your MiscTotal if its Null replace
> with 0
>
> Somethign like
>
> YourLineTotla + If IsNull(yourMisctotal) then 0 else yourmisctotal
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Fri, Feb 15, 2013 at 11:11 AM, Sean Toler <seantoler@...>wrote:
>
> > **
> >
> >
> > OK, that worked great until I tested removing the misc. charges and
> > everything on the form disappeared when I did a print preview.
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez wrote:
> > >
> > > You can still create your own, the Misc Tables are available to you
> > outside
> > > the sub report simply add together the misc charges , and add together
> > the
> > > lines, then add both of those together.
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > > http://www.linkedin.com/in/josecgomez> http://www.facebook.com/josegomez
> > >
> > > http://www.google.com/profiles/jose.gomez> http://www.twitter.com/joc85>
> > > http://www.josecgomez.com/professional-resume/>
> > > http://www.josecgomez.com/feed/>
> > > http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > > On Fri, Feb 15, 2013 at 10:44 AM, Sean Toler wrote:
> > >
> > > > **
> >
> > > >
> > > >
> > > > Hello,
> > > > I have been asked to add a line at the bottom of our quote form that
> > gives
> > > > a grand total. At first I thought this would be easily done with a
> > summary
> > > > of the @extendedprice formula until I noticed the Line Misc Charges
> > > > subreport. I have very limited experience with shared variables and
> > have
> > > > been attempting to create one that would allow me to add the total misc
> > > > charges to the total extended price but can not get it to work.
> > > > Can someone walk me through this?
> > > >
> > > > Thanks!
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
7
Sean –

You may want to check out this instructional message:
http://forums.codeguru.com/showthread.php?449494-How-to-get-formula-field-value-from-Subreport-to-main-report

Then use another formula field to add up the values returned from the sub-report(s). This must be placed in a report section that is displayed after the sub-report section(s)

Hope this helps,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@...
http://www.codabears.com


"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."


--- In vantage@yahoogroups.com, "Sean Toler" <seantoler@...> wrote:
>
> Hello,
> I have been asked to add a line at the bottom of our quote form that gives a grand total. At first I thought this would be easily done with a summary of the @extendedprice formula until I noticed the Line Misc Charges subreport. I have very limited experience with shared variables and have been attempting to create one that would allow me to add the total misc charges to the total extended price but can not get it to work.
> Can someone walk me through this?
>
> Thanks!
>
8
Thanks. I gave that a try and was able to get some success, however, if there are multiple lines with multiple misc. charges, the misc. charges are not being summarized. It is only using one of the misc. charges in the final calculation.

--- In vantage@yahoogroups.com, "CalvinDekker" <calvind@...> wrote:
>
> Sean –
>
> You may want to check out this instructional message:
> http://forums.codeguru.com/showthread.php?449494-How-to-get-formula-field-value-from-Subreport-to-main-report
>
> Then use another formula field to add up the values returned from the sub-report(s). This must be placed in a report section that is displayed after the sub-report section(s)
>
> Hope this helps,
> Calvin Dekker
> Office: 630-672-7688 Ext. 1484
> Email: calvin@...
> http://www.codabears.com
>
>
> "No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."
>
>
> --- In vantage@yahoogroups.com, "Sean Toler" <seantoler@> wrote:
> >
> > Hello,
> > I have been asked to add a line at the bottom of our quote form that gives a grand total. At first I thought this would be easily done with a summary of the @extendedprice formula until I noticed the Line Misc Charges subreport. I have very limited experience with shared variables and have been attempting to create one that would allow me to add the total misc charges to the total extended price but can not get it to work.
> > Can someone walk me through this?
> >
> > Thanks!
> >
>
9
You will need to do a subtotal on the misc charges in the sub-report and
make this a shared variable.



This is what we used in the subreport



Shared NumberVar TSQuoteMiscCharges;



TSQuoteMiscCharges := Sum ({QuoteLnMsc.MiscAmt})



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Sean Toler
Sent: Friday, February 15, 2013 10:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Quote Form Totals





Thanks. I gave that a try and was able to get some success, however, if
there are multiple lines with multiple misc. charges, the misc. charges are
not being summarized. It is only using one of the misc. charges in the final
calculation.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"CalvinDekker" wrote:
>
> Sean -
>
> You may want to check out this instructional message:
>
http://forums.codeguru.com/showthread.php?449494-How-to-get-formula-field-va
lue-from-Subreport-to-main-report
>
> Then use another formula field to add up the values returned from the
sub-report(s). This must be placed in a report section that is displayed
after the sub-report section(s)
>
> Hope this helps,
> Calvin Dekker
> Office: 630-672-7688 Ext. 1484
> Email: calvin@...
> http://www.codabears.com
>
>
> "No trees were harmed during the sending of this message, however a large
number of electrons were terribly inconvenienced."
>
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Sean
Toler" wrote:
> >
> > Hello,
> > I have been asked to add a line at the bottom of our quote form that
gives a grand total. At first I thought this would be easily done with a
summary of the @extendedprice formula until I noticed the Line Misc Charges
subreport. I have very limited experience with shared variables and have
been attempting to create one that would allow me to add the total misc
charges to the total extended price but can not get it to work.
> > Can someone walk me through this?
> >
> > Thanks!
> >
>





[Non-text portions of this message have been removed]
10
When you can add a miscellaneous charge for 0 $.

I don't think you need to check for nulls.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jose Gomez
Sent: Friday, February 15, 2013 9:13 AM
To: Vantage
Subject: Re: [Vantage] Re: Quote Form Totals

On your Final Sum do a Check For Null on your MiscTotal if its Null replace
with 0

Somethign like

YourLineTotla + If IsNull(yourMisctotal) then 0 else yourmisctotal


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Fri, Feb 15, 2013 at 11:11 AM, Sean Toler
<seantoler@...>wrote:

> **
>
>
> OK, that worked great until I tested removing the misc. charges and
> everything on the form disappeared when I did a print preview.
>
>
> --- In vantage@yahoogroups.com, Jose Gomez wrote:
> >
> > You can still create your own, the Misc Tables are available to you
> outside
> > the sub report simply add together the misc charges , and add
> > together
> the
> > lines, then add both of those together.
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > http://www.linkedin.com/in/josecgomez>
> > http://www.facebook.com/josegomez
> >
> > http://www.google.com/profiles/jose.gomez>
> > http://www.twitter.com/joc85>
> > http://www.josecgomez.com/professional-resume/>
> > http://www.josecgomez.com/feed/>
> > http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Fri, Feb 15, 2013 at 10:44 AM, Sean Toler wrote:
> >
> > > **
>
> > >
> > >
> > > Hello,
> > > I have been asked to add a line at the bottom of our quote form
> > > that
> gives
> > > a grand total. At first I thought this would be easily done with a
> summary
> > > of the @extendedprice formula until I noticed the Line Misc
> > > Charges subreport. I have very limited experience with shared
> > > variables and
> have
> > > been attempting to create one that would allow me to add the total
> > > misc charges to the total extended price but can not get it to work.
> > > Can someone walk me through this?
> > >
> > > Thanks!
> > >
> > >
> > >
> >
> >
> > [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