Unwanted Field

[oseimuduame]

Good Afternoon,

Is it possible to Exclude a particular field from the Database, i tried doing it with WHERE NOT but it only excludes the name of the Field but showing other attributes of the field.

Thank You.

[awhitfield]

If its SQl, then you may need something like

select * from (yourtable) where (yourfield) not like '%butane%'

Andy

[oseimuduame]

ORACLE

[vinieme12]

please post your script!

[oseimuduame]

I think its working now but below is my script.

//items

SQL SELECT

  TO_CHAR(n.ITEM_SID) AS "ITEM_SID",

  n.ITEM_NO AS "ITEM_NO",

  n.SBS_NO AS "SBS_NO",

    n.ACTIVE AS "ITEM_ACTIVE",

  n.VEND_CODE AS "VEND_CODE",

  n.DCS_CODE AS "DCS_CODE",

  n.DESCRIPTION1 AS "ITEM_DESCRIPTION1",

  n.DESCRIPTION2 AS "ITEM_DESCRIPTION2",

  n.DESCRIPTION3 AS "ITEM_DESCRIPTION3",

  n.DESCRIPTION4 AS "ITEM_DESCRIPTION4",

  n.ATTR AS "ITEM_ATTR",

  n.SIZ AS "ITEM_SIZ",

  n.ALU AS "ITEM_ALU",

  u.UPC AS "ITEM_UPC",

  n.UDF1_DATE AS "UDF1_DATE",

  n.UDF2_VALUE AS "UDF2_VALUE",

  v.VEND_NAME AS "VEND_NAME",

  v.FIRST_NAME AS "VEND_FIRST_NAME",

  v.LAST_NAME AS "VEND_LAST_NAME",

  SUBSTR(d.DCS_CODE,1,3) AS "D_CODE",

  SUBSTR(d.DCS_CODE,4,3) AS "C_CODE",

  SUBSTR(d.DCS_CODE,7,3) AS "S_CODE",

  d.D_NAME AS "D_NAME",

  d.C_NAME AS "C_NAME",

  d.S_NAME AS "S_NAME",

  d.D_LONG_NAME AS "D_LONG_NAME",

  d.C_LONG_NAME AS "C_LONG_NAME",

  d.S_LONG_NAME AS "S_LONG_NAME",

  d.ACTIVE AS "DCS_ACTIVE",

  n.COST AS "ITEM_COST"

FROM INVN_SBS n

LEFT JOIN INVENTORY u ON n.ITEM_SID = u.ITEM_SID

LEFT JOIN VENDOR v ON v.VEND_CODE = n.VEND_CODE AND v.SBS_NO = n.SBS_NO

LEFT JOIN DCS d ON d.DCS_CODE = n.DCS_CODE AND d.SBS_NO = n.SBS_NO

WHERE n.SBS_NO in $(subsidiaries) AND NOT n.DESCRIPTION1 = 'LPG BUTANE';

i used the above and in my expression sum(invc_ext_price) then under dimension i mark "Suppress Value when Null" and it worked fine.