Solved

Display "count" of Sql query in Crystal Report.....

Posted on 2000-05-17
5
397 Views
Last Modified: 2012-06-27
I wrote below mentioned sql statement and run it from sql-server and got below mentioned o/p:

select x_service_type_categor,count(*)
from table_subcase,table_site
where table_subcase.subc2cont_svc_site = table_site.objid
and creation_time > "05/01/2000 8:00:00 AM" and creation_time < "05/15/2000 8:00:00 PM" and x_suite_number = 100
group by x_service_type_categor


Output:
x_service_type_categor     Count
----------------------     -----
Electrical                    3

I want to display above count in Crystal Report.

How do i do that and where should i wrote that query in crystal report.

I only use crystal report.Please let me know as soon as you can.

Thanks for your time in advance.

Thanks,
buddyp
0
Comment
Question by:buddyp
  • 4
5 Comments
 

Author Comment

by:buddyp
ID: 2818890
In short, i want to count Duplicate Records and display particular record's count in the same row.

I mean suppose same record is available as 10 times than i want to display "10" at the end of that row:

Record in Crystal Looks like:
HVAC      Noise   Engineering - UC   10

How do i do that ?

Thanks,
buddyp
0
 

Author Comment

by:buddyp
ID: 2821115
I am still waiting for your answer.

Thanks,
buddyp
0
 

Accepted Solution

by:
nealjd earned 50 total points
ID: 2822827
In crystal, can't you make a group, hiding/deleting the details and for the totals field use count instead of sum. Pretty much the same as Acccess just a little more work to get to it.
0
 

Author Comment

by:buddyp
ID: 2826073
nealjd
Let me know step by step how do i do that ?

Thanks
buddyp
0
 

Author Comment

by:buddyp
ID: 2834936
I solved the problem myself.But thanks for your time and help.

I will give you points.

Thanks,
buddyp
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question