Leading Grand Summary On Report - Not Shown In Preview Mode
I have two tables, Surveys and Trees, it a 1 to many relationship, ie one survey record can have any number of tree records.
I am trying to produce a report which consists of a first page with some summary into, This is fine i use the TITLE HEADER section for this.
After that I Want a page detailing the data from the Survey file, and then a seperate page for Each Tree record linked to that survey
I am using the LEADING GRAND SUMMARY section for the Survey info, and the BODY section for Tree info.
However when i first look at the report my LEADING GRAND SUMMARY page is show, when i switch to preview mode, this section is not shown
I think it might be to do with the length of the LEADING GRAND SUMMARY, But not sure -
If there is a better way of doing this, please let me know, I am after
First Page that holds the title info about the report
Second page - survery data
Other pages - one page per tree record that is linked to the survey