?
Solved

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

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

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

864 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