Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Weekly and Monthly Report		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

kolucoms6
Average Member

845 Posts
Posted - 19 March 2008 :  20:47:34  Show Profile

I have a field called LDate and Status Column.

Status Column can be Passed, Failed or Pending.

I want to create a report in ASP as :

quote:

Daily Weekly Monthly
-----------------------------------------------------------------
Passed |
Failed |
Pending |



Guidance Required on how to start :-)

phy1729
Average Member

USA
589 Posts
Posted - 19 March 2008 :  21:01:58  Show Profile
A field in what? MySQL? Excel? CSV?

What do you want the report to look like? Is it supposed to be a table that totals the Pending for today and the Failed and Passed and then the same for weekly including or excluding the daily ones?

Are you outputting in HTML, CSV, plain text?

Guidance Required to give the guidance requested.
Edited by - phy1729 on 19 March 2008 21:02:25
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 19 March 2008 :  22:12:27  Show Profile

1) MS-Access
2) Output in HTML
3) Table with


.................Today.................This Week....................This Month
---------------------------------------------------------------------------
Passed ......|
Failed...... |
Pending..... |
%Conversion..|
---------------------------------------------------------------------------

% Conversion is Passed %.
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 20 March 2008 :  01:53:58  Show Profile  Visit HuwR's Homepage
is the LDATE field a date or a string or an integer ?
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 20 March 2008 :  08:42:51  Show Profile
Its a Date field.
Edited by - kolucoms6 on 20 March 2008 18:36:29
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 21 March 2008 :  03:38:51  Show Profile  Visit HuwR's Homepage
could you try to provide more info if you want help, like what format the date is, english/US or some other etc etc
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 21 March 2008 :  05:29:38  Show Profile


In my db i am storing it as

21/03/2008

means ,

21st March,2008.
Go to Top of Page

kolucoms6
Average Member

845 Posts
Posted - 21 March 2008 :  22:48:17  Show Profile
Sample



I am looking for a layout like above
Edited by - kolucoms6 on 22 March 2008 06:46:51
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.21 seconds. Powered By: Snitz Forums 2000 Version 3.4.07