Hi All
i have sqlreport based on table
select id,comp,ser_ind,id_comments from table_1
now if the ser_ind = 1 then id_comments contains comments
otherwise the id_comments is null
now when i'm showing my report i want to do a conditional display for the id_commnets column to
display this column only if ser_ind = 1
solution like this :
case when ser_ind = 1 then id_comments else null END comm,
not good for me cause the column in the database is already null
besides
i dont want that the column will appers at all in the report.
can someone help ?
thanks