I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'

Question Posted / brahmaiah508

2 Answers
5290 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the ..

Answer / naresh

Create one new Derived Column ,In derived column Expression use case statement as ---->

case when column_Name =0 then 'NULL'
when column_name<>0 then cast(column_name,varchar(20))
end

after this hide the original column by checking properties of column

Is This Answer Correct ?

9 Yes

0 No

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the ..

Answer / krishna

case when column_Name =0 then 'NULL'
else 'column_Name'
end

Is This Answer Correct ?

8 Yes

0 No

Post New Answer