CodeCharge Studio
search Register Login  

Web Reports

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

YesSoftware Forums -> CodeCharge -> Programming

 Count Summary

Print topic Send  topic

Author Message
navcan

Posts: 61
Posted: 01/30/2004, 9:48 AM

Hello all,

This is my first post to the new forum.

I am using CC 2.0.7 (asp with templates) and access database.

Question:
I have a table of service requests submitted by users. there is a fild "Status" in the table and the items in status are
NEW REQUEST
ON HOLD
IN PROGRESS
CLOSED

I would like to count the status and show the summary in a grid like this

SERVICE REQUEST SUMMARY
New Requests = 20
On Hold = 05
In Progress = 25
Closed = 50
Total Requests = 100

I tried to count status and got the result but for every status I had to use saparate form. I would like to see the results in one grid/form. I will appreciate if anybody can assist me in achiving this goal.

Thank you.
View profile  Send private message
Erik Dekker
Posted: 02/01/2004, 3:26 PM

In SQL200 I managed this with a view.
I haven't tested this, but I would make a query in Access totalling each category of service requests and the total of service request. In CC I would use this query as a DB table.

Hope this helps
Erik Dekker
navcan

Posts: 61
Posted: 02/02/2004, 5:51 AM

Dear Erik,

Thank you for your response. Your solution is perfect., I used the same concept in my project to at least make my client happy.

I was just wondering if there is an alternate solution built-in in CC. Anyhow, appreciate your response.

Best regards,
navcan
View profile  Send private message
Erik Dekker
Posted: 02/03/2004, 2:53 AM

Hi navcan,

As I see it, CodeCharge is based on getting data record-group per record-group to and fro a database. However, you can take the SQL statement made by access and paste in the query builder, but I found this approach more pragmatic. I lost track of what happens where in CCS !

Erik Dekker

Add new topic Subscribe to topic   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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