Hi

i am developing birt reports from mysql database wen i am retriving data from the table SELECT advid , country , state, city

FROM T1

some of my column values of state and country are giving null values now i want to change these null values with string values i have replaced ur code but it is giving the same null values result.

Thanx