Luis Cazares (8/13/2014)

---

I was referring to the view.

I didn't notice that you have it in your SELECT column list. Do you need it? If so, what should you show when...

if you are talking about Group by in crystal reports, I have not used brvPRInsJob.InsCode it to Group BY.

if...

Luis Cazares (8/11/2014)

---

Using a CTE is basically the same but in different order. I prefer this approach but it's just personal preference.

ALTER VIEW [dbo].[crvKCLPRInsJob]

AS

WITH CTE AS(

SELECT...

thank you guys for your quick response.

If I create the CTE, Do you guys know if the CTE will work in SAP Crystal reports?