We help IT Professionals succeed at work.
Get Started

return select data

410 Views
Last Modified: 2012-06-27
I have the following query which allows me to produce a table within iReport
I only want to print certain fields - iReport is not letting me distinguish which fields.
I can do this in sqlServer - not sure how - probably a case or select within select -
if query returns counts of application 1, application 2, application 3 -but I only want to see results of application 2 how would I do so -
SELECT  Count(CLE_TYPE) AS [CallCount],CLT_DESC AS [EventType], CLX_DESC AS [Application], UTILITY_NAME as [Utility]
		FROM CL_EVENTS_IDX WITH (NOLOCK) 
		INNER JOIN CL_EVENTS WITH (NOLOCK) ON CLE_ID = CLE_IDX_KEY
		INNER JOIN UTILITY_INFO WITH (NOLOCK) ON CLE_IDX_UCODE = UTILITY_KEY
		INNER JOIN CL_APPID_XREF WITH (NOLOCK) ON CLE_EVID = CLX_APPID
		INNER JOIN CL_TYPES WITH (NOLOCK) ON CLE_TYPE = CLT_ID    		
		GROUP BY UTILITY_NAME, CLX_DESC, CLT_DESC

Open in new window

Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE