Footnote formula 1

[Scroller52]

Hi, using CR XI on a SQL database

I've got an investor statement type report, grouped by investor, fund type and fund.

In the details section, I have deal level detail. I'm pulling 2 amounts in there. So for each deal if those 2 amounts are 0, I have an asterisk to indicate there is a footnote.

So the suppression formula i have in the asterisk is:

if {@GP Cost}=0 and {@GP %}=0 then false else true

I can't use that same formula for the actual footnote I placed in group footer 1 because the footnote is suppressing based on the grand totals of @gp cost and @ gp%.

I need the footnote to show up whenever any deal needs a footnote from the details section. Any help would be greatly appreciated. If you need any other info on the report, please let me know.

thanks!

 

[lbass]

I can't tell whether you want the footnote in the group footer or the page footer. If it is in the group footer, why would it be suppressing based on the grand totals for your fields? What is the suppression formula? Or are you saying it is doing this in error? Actually, it would be reading the value of the last record in the group, not a summary of the fields.

-LB

 

[Scroller52]

I need to footnote to appear in the group footer of group 1 (by investor). I thought it was suppressing based on the grand total, but yes you're right, it looks like it is the value of the last record in the group.

I need the footnote to appear whenever any of the details meet the formula:

if {@GP Cost}=0 and {@GP %}=0 then false else true

i need the footnote to be suppressed when either of the fields are not 0.

 

[lbass]

Create a formula like this:

if {@GP Cost} <> 0 or
{@GP %} <> 0 then 1

Then suppress the footnote with:

sum({@thisformula},{table.groupfield}) <> 0

This will suppress the footnote if any records in the group have amounts <> 0.

-LB

 

[lbass]

Actually, maybe I have that backwards. I guess I'm not clear when you want the footnote to appear. If you want it to appear if any records have two zero values, then you would do this:

if {@GP Cost} = 0 and
{@GP %} = 0 then 1

Then suppress with:

sum({@thisformula},{table.groupfield}) = 0

If all records have non-zero values in one of the two fields, then the footnote would not appear.

-LB

 

[Scroller52]

thanks LB!
once again you come to my rescue.