Character values not retrieved/displayed in Report Designer
We have a scenario where we need to get out hard-coded character values as an extra column.
Select 'Sales Volume' as metric_name, sales_qnty from sales_table;
The problem we face is that, this hard-coded value is not retrieved when we preview the data and the entire column appears empty. But the problem does not arise when we are giving non-character values (like Select 1,sales_qnty from sales_table). We checked and found out that the data from varchar columns defined in the table are also not retrived/displayed.
Any idea why the above happens? Does it have to do anything with the character set? What is the solution to it?
FYI, Our database is Oracle 11g and the characterset is WE8MSWIN1252 and when we run the same report pointing to SQL Server, the output is as expected.
Your help is appreciated.