Print Page | Close Window

crystal report formula

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21069
Printed Date: 17 Apr 2024 at 11:18pm


Topic: crystal report formula
Posted By: subhani.029
Subject: crystal report formula
Date Posted: 24 Sep 2014 at 8:21pm
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

-------------
abdul subhan


Replies:
Posted By: z9962
Date Posted: 24 Sep 2014 at 10:15pm
You could use a subreport in the report footer? else
 
Formula 1 (placed in details section)
SHARED stringvar text := "";
IF {Sp_Get_DailyReport;1.Job_Status} = "Workshop"
THEN text := text & "," & {Sp_Get_DailyReport;1.Department_Name} 
 
Formula 2 in Footer
SHARED stringvar text;

Posted By: lockwelle
Date Posted: 03 Oct 2014 at 5:54am
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.

Posted By: Vimal Nair
Date Posted: 28 Jan 2015 at 12:07am
Try inserting a cross tab in the report footer.

-------------
Born To Live

Posted By: niha
Date Posted: 07 Jun 2015 at 11:06pm

You could use a subreport in the report footer?


Print Page | Close Window