1 Reply Latest reply: Sep 2, 2011 10:06 PM by 757297 RSS

    hi all I have a doubt in report

    883038
      I have written the below querry in report builder
      select case when deptno=10 then empno else null end from emp 
      then
      I got c/d symbol in data model diagram .
      and when i modified the query as
      select * from emp then i didnt got any symbol in data model diagram.
      why am getting this symbol is this because of case in select statement ?

      please help me to clear this doubt .
      thanks for all in advance
        • 1. Re: hi all I have a doubt in report
          757297
          Hi,

          This means that your Query is not linkable. You can not rely on Reports builder to build a link between this query and an other one (on the same data model). Instead, you have to manage your link by code in the where clause.

          The case is the cause of the C/D symbol. Thers are other reasons why Reports builder will put a C/D (to make your query not linkable), like writing a subquery in your select clause.

          Hope this helps

          Mohamed Dadi