Solved

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

Posted on 2000-05-17
5
404 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

689 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