Hi All,
I have created an interactive form based report and need some help on this. In report I want to display a column with label CANDIDATE FULL NAME by concatenating existing columns from same table.
Am mentioning the details and questions below:
Table Name: CANDIDATE_DETAILS
Column 1: CANDIDATE_FNAME (First Name) Datatype: CHAR(50)
Column 2: CANDIDATE_LNAME (Last Name) Datatype: CHAR(50)
Column 3: CANDIDATE_FULLNAME (Full Name) Datatype: CHAR(100)
If in case Column 3 i.e., CANDIDATE_FULLNAME is not created in database, I could have written below query to create one with concatenating Column 1 and Column 2
ALTER TABLE CANDIDATE_DETAILS ADD CANDIDATE_FULLNAME CHAR(100 CHAR)
AS (CANDIDATE_FNAME || ' ' || CANDIDATE_LNAME)
Since, I have already created CANDIDATE_FULLNAME column, I just have to modify it or simply want to store concatenation of column1 and column2. I tried using below query but its not working:
ALTER TABLE CANDIDATE_DETAILS
MODIFY CANDIDATE_FULLNAME AS (CANDIDATE_FNAME || ' ' || CANDIDATE_LNAME)
Also am trying to verify the code under SQL Workshop --> SQL Commands by entering below query and its working fine.
Select CANDIDATE_FNAME || ' ' || CANDIDATE_LNAME
from "CANDIDATE_DETAILS"
but don't know where to enter this code in "Page Designer" so that without creating additional column in Database my requirement can be fulfilled.
Please let me know if You need further details and really appreciate any help provided.
Thanks,
Vasanth