CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Can Codecharge do this?

Print topic Send  topic

Author Message
Frank Rocco
Posted: 05/22/2001, 3:41 PM

Hello,
I don't think CodeCharge can do what I am trying to do.
I want to select fields from a table and sum the amounts and print break
totals and a grand total.

I have started doing this by hand using vbscript as I cannot see how
Codecharge can so this.

Is it possible?

Thanks
Frank

Alexey Alexapolsky
Posted: 05/23/2001, 8:06 AM

Please see BookStore example , ShoppingCart page ,
you will see how to count total.
Does your page have scroller ?

--
Regards,
Alexey
CodeCharge Support



Frank Rocco <farocco@hotmail.com> wrote in message
news:9eepue$vhl$1@mail.tankhill.com...
> Hello,
> I don't think CodeCharge can do what I am trying to do.
> I want to select fields from a table and sum the amounts and print break
> totals and a grand total.
>
> I have started doing this by hand using vbscript as I cannot see how
> Codecharge can so this.
>
> Is it possible?
>
> Thanks
> Frank
>
>

Frank Rocco
Posted: 05/23/2001, 8:37 AM

I looked at this.
I want to break on a list of multiple records by Account # giving totals.

Account Amount
123 50.00
123 75.00
125.00
456 10.00
456 60.00
70.00

Thanks
Frank
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9egjku$fqp$1@mail.tankhill.com...
> Please see BookStore example , ShoppingCart page ,
> you will see how to count total.
> Does your page have scroller ?
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
>
> Frank Rocco <farocco@hotmail.com> wrote in message
>news:9eepue$vhl$1@mail.tankhill.com...
> > Hello,
> > I don't think CodeCharge can do what I am trying to do.
> > I want to select fields from a table and sum the amounts and print break
> > totals and a grand total.
> >
> > I have started doing this by hand using vbscript as I cannot see how
> > Codecharge can so this.
> >
> > Is it possible?
> >
> > Thanks
> > Frank
> >
> >
>
>

CodeCharge
Posted: 05/24/2001, 1:12 PM

You may use an SQL statment instead of table. The SQL could be similar to
this:
select account,sum(order_amount) from orders group by account;


"Frank Rocco" <farocco@hotmail.com> wrote in message
news:9eglg1$hvq$1@mail.tankhill.com...
> I looked at this.
> I want to break on a list of multiple records by Account # giving totals.
>
> Account Amount
> 123 50.00
> 123 75.00
> 125.00
> 456 10.00
> 456 60.00
> 70.00
>
> Thanks
> Frank
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:9egjku$fqp$1@mail.tankhill.com...
> > Please see BookStore example , ShoppingCart page ,
> > you will see how to count total.
> > Does your page have scroller ?
> >
> > --
> > Regards,
> > Alexey
> > CodeCharge Support
> >
> >
> >
> > Frank Rocco <farocco@hotmail.com> wrote in message
> >news:9eepue$vhl$1@mail.tankhill.com...
> > > Hello,
> > > I don't think CodeCharge can do what I am trying to do.
> > > I want to select fields from a table and sum the amounts and print
break
> > > totals and a grand total.
> > >
> > > I have started doing this by hand using vbscript as I cannot see how
> > > Codecharge can so this.
> > >
> > > Is it possible?
> > >
> > > Thanks
> > > Frank
> > >
> > >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.