Displaying all footnotes 1

[wesleycrusher]

I am using a simple formula to display a complete list of custom footnotes in the group footer. If a unit has 5 different footnotes (stored in 5 separate rows in the same table with unique "footnote_nbr&quot, how would I go about checking for and printing all of the footnotes? A loop of some sort?

 

[wesleycrusher]

Here's my formula:

numberVar custfoot := 1;

while (custfoot = {form_custom_footnote.footnote_nbr})
do
(
custfoot:=custfoot+1;
{form_custom_footnote.footnote_txt};
);

 

[lbass]

The simplest way would be to insert a crosstab in the group footer, using {table.footnotenumber} for the row, and {table.footnotetext} for the summary field (no column). You would use a summary like "Maximum" to print text as the summary. Then format the crosstab to eliminate column totals and grid lines, and then suppress the total column label by using format field.

You could also use the three formula method to accumulate and display values, but you would likely run into a problem with the 254 character limit for strings unless you are using v.9.0.

-LB

 

[wesleycrusher]

Thanks! That brings me closer to my goal. It is working and once I get the formatting correct, it will work out perfectly. Thanks again.

 

[lbass]

For the formatting, go into format crosstab->customize style and in the bottom left there is a tab for formatting grid lines. Click on that and then uncheck show grid lines. To eliminate the column total, in the same screen, choose suppress column totals. Then exit the crosstab and select the column label field and right click on it->format field->common->suppress. You can also format the row label field to right justification and the summary to left justification so that the footnote number is closer to the text.

-LB