dzero
dzero

Reputation: 11

how to pass formula which is in group of main report to sub report (crystal report)

This question about crystal report. I have crystal report, which has a formula in Group Section. I want to show all the generated group names in bottom of the crystal report. So I have insert subreport to Main report footer. Then created a formula and link it to main report formula. But When running, in sub report, only show last generated group name only. How to print all the generated group names in bottom of the report.

Thank you.

Upvotes: 0

Views: 1472

Answers (1)

craig
craig

Reputation: 26262

If I understand what you intend to do, you have a few options:

  • add a Cross-tab to the Report-Footer section - this will summarized the report's data without a second trip to the database
  • add a sub-report to the Report-Footer section - you will have more control of the formatting, but it will require a second trip to the database
  • create a formula that executes at print time (WhileReadingRecords) to store the group names in an array (note: arrays hold a maximum of 1000 entries), then create a second formula (also print time), that joins the array, adding it to the Report-Footer section.

Upvotes: 0

Related Questions