title: if we use CTE in sql Query will it work when we use the query in Crystal report?
body: <p>I'm wondering if i used CTE in a query will i be able to create a crystal report ? 
  also can i use the CTE with case when function ?</p>