Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2000-05-17
5
Medium Priority
?
415 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 100 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

618 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