Hi Synapse
Thanks for your response!
I am trying to modify the sql in the subreport.
The record selection formula looks like this:
{EMPLOYEES.ID} = {?Pm-EMPLOYEES.ID}and
{CLASSES.ID} = {?Pm-CLASSES.ID}
The sql looks like this under "Show SQL Query"
SELECT
EMPLOYEES."ID",
CLASSES."ID",
QUESTION."NAME"
FROM
CLASSES,
EMPLOYEE,
QUESTION
WHERE
(QUESTION."NAME" = 'Choice 10' OR
QUESTION."NAME" = 'Choice 14' OR
QUESTION."NAME" = 'Choice 16')
ORDER BY
TPV_PUB_SMP_EMPLOYEES."ID" ASC,
TPV_PUB_BASE_CLASSES."ID" ASC
What I am trying to do is to insert "QUESTION."NAME" = 'Choice 12' OR" in the WHERE part. After saving it, it still had the change but the formatting got messed up like this:
SELECT
EMPLOYEES."ID",
CLASSES."ID",
QUESTION."NAME"
FROM
CLASSES,
EMPLOYEE,
QUESTION
WHERE
QUESTION."NAME" = 'Choice 10' OR QUESTION."NAME" = 'Choice 12' OR QUESTION."NAME" = 'Choice 14' OR QUESTION."NAME" = 'Choice 16' OR
ORDER BY
TPV_PUB_SMP_EMPLOYEES."ID" ASC,
TPV_PUB_BASE_CLASSES."ID" ASC
However, the change did not get reflected to the data shown on the report..
I removed the entire code in the WHERE clause and put it in the record selection formula. The weird thing is that QUESTION."NAME" for choice10,14, and 16 showed up but NOT choice12..