Solved

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

Posted on 2000-05-17
5
399 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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