Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: jaspaul
- Order by date
-
Group By Query Summary Problem
Understood the problem 70%, but without seeing the actual data, can't help you much. As Pattycake245 said, post relevant data from the tables - "Job" & "JobItems". & If you post your query, it would be even better. Jas.- jaspaul
- Post #3
- Forum: Microsoft SQL Server: Programming
-
group by second letter of last name
Well...I'm using crystal 8.5 The problem is that I want to display the result of the sql query as it is, on the report. I can get to group the records as you mentioned but I don't want the actual records showing. Just want the name & the count. But the report is showing me the result of the...- jaspaul
- Post #7
- Forum: Business Objects: Crystal Reports 1 Formulas
-
group by second letter of last name
Hi, Sorry to bother you, but I've been going through all the posted forums as I myself am facing a similar problem of grouping. I'm trying to integrate the following sql in crystal report: select count(*), name from calls_done group by name; I don't know how to create a formula to group on...- jaspaul
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
