i want to display one detail column in the report footer, for that i wrote formula which return just 'false' only... is it possible to have detail column in the report footer. I mean, i have to display set of rows in the report footer.

My formula:
stringvar text := "";
IF {Sp_Get_DailyReport;1.Job_Status} = "Workshop"
THEN text = {Sp_Get_DailyReport;1.Department_Name}

& tried this also

stringvar text := "";
IF {Sp_Get_DailyReport;1.Job_Status} = "Workshop"
THEN SELECT {Sp_Get_DailyReport;1.Department_Name}

can anyone plz help me to solve this ...


Thanks

you could try inserting a cross tab into the report footer...or a subreport, otherwise the answer is no.

the report footer would only have access to the last record of the dataset of the main report.

You could use a subreport in the report footer?