Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 25th, 2005, 09:38 PM
Authorized User
 
Join Date: Aug 2004
Location: , , .
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Default Group total in a report

Hello,

  I have a table(msaccess) with the structure...
job_code text 6
style text 10
qty number
fabrication text 65
ship_date date/time


I want to show a report like...

job_code style qty fabrication ship_date
------------------------------------------------------
05A001 2464 75000 AAAAAAA 5-Jan-2005
05A002 3800 93430 BBBBBBB 5-Jan-2005
05B001 2845 4900 CCCCCCC 5-Jan-2005

                  ----------
                   173330
05A003 2564 45000 DDDDDDD 5-Feb-2005
05B002 2800 65000 EEEEEEE 15-Feb-2005
05C001 P357G 5500 FFFFFFF 15-Feb-2005
                 ------------
                   115500

....

What could be the query and how can i show an HTML report. I am using ADO with ASP and VBScript.


thanx in advance



 
Old February 28th, 2005, 05:40 PM
Friend of Wrox
 
Join Date: Jan 2004
Location: , , USA.
Posts: 303
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There should be a better solution out there..but

I would try using a dynamic SQL something like this...

Dim var_Month

For var_Month=1 To 12 Step 1

SQL = "SELECT job_code,style,qty,fabrication,ship_date FROM MyTable WHERE Month(Ship_Date) = " & var_Month & "

'create your recrodset and display your results

Next




Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports Group Total evman Crystal Reports 0 July 19th, 2005 03:00 PM
sub report total sanjay_jadam Crystal Reports 1 June 24th, 2005 12:55 PM
Supress record when running total in group meets c ldejesuspr Crystal Reports 1 July 28th, 2004 11:10 PM
Running Total Fields per Group edramail Crystal Reports 0 May 6th, 2004 08:19 PM
Running Total on group header scamp Crystal Reports 0 May 3rd, 2004 06:18 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.