As above image is from the report. Where I am getting the data from the data base but while taking the need to convert the Number to test VIA SQL Query
I have 3 sets of data
0 = not started
1 = InProgress
2 = Completed
How do I convert this above mentioned Number in to the text.
You do it in the SQL query. Which SQL database server are you using?
Oracle SQL data base Sever I am using. can I know how I do can execute in the query?
Use the CASE ... WHEN ... syntax. It should be something like this if the number value is in column3:
WHEN 2 THEN 'Completed'
WHEN 1 THEN 'In Progress'
ELSE 'Not started'
You will find plenty of examples on the web.
The way I handle this is to create a new table for status and then connect them via the ID columns. I find it easier to maintain the SQL queries long term this way. However if creating a new table is not an option, then the solution given by @Transistor is your best bet.