TimFred
asked on
In Crystal Reports II I need a footnote formula field that returns a list of data that was returned in the detail section.
In Crystal Reports II I need a footnote formula field that returns a list of data that was returned in the detail section.
My detail section will return something like this:
Fund I
Fund II
Fund II
I need a footnote at the bottom of the page that will take the detail data and put it into a string so it shows up in the footnote like this:
Fund I, FundII, Fund III
My detail section will return something like this:
Fund I
Fund II
Fund II
I need a footnote at the bottom of the page that will take the detail data and put it into a string so it shows up in the footnote like this:
Fund I, FundII, Fund III
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Where did you put the first formula? That is the one that does the reset.
Make sure it is in the Page Header section and not the Report Header.
Make sure it is in the Page Header section and not the Report Header.
ASKER
Yes, it is in the page header.
Hmm...I just recreated the scenario and everything worked fine for me.
Do you have the Init Vars formula exactly the same as this:
whileprintingrecords;
global stringvar detail_data := "";
Do you have the Init Vars formula exactly the same as this:
whileprintingrecords;
global stringvar detail_data := "";
ASKER
Works, didn't have the variable as a global before ... now it works.
Many thanks!!!!
Many thanks!!!!
ASKER
It is not resetting the data on a page by page basis. the string keeps growing. The footnote needs to just show what is in the detail section on that page. I am surprised it is not working. What are we missing?