WhiteKnight2K
Technical User
I know I said I wouldnt post another question today but I've got this project to finish and I cant figure out for the life of me why my report setup wont generate the subreport results. Heres the layout of my report
Main Report (contains Year parameter field)
Group By Municipality
Group Header
.
.
Details (displays records (Trees) based on Year parameter)
.
.
Group Footer 1a (contains a summary of data from Details section)
Group Footer 1b (contains a Subreport which is linked on the Year parameter field from the Main Report and displays Firewood records based on Year)
Here's the dilemma, for some reason, if the Main Report displays no records (trees) based on the Year selected, then the Subreport also is blank. However, the subreport should be displaying data (Firewood) on the chosen year. It seems that the Subreport will only display records (Firewood) if the Main Report Details has records (Trees) for the chosen year. This should not be the case, as not all areas will have Trees and Firewood for the chosen year...(i.e. some will only have Firewood).
Any ideas? Could this be a problem with linking? I've tried various linking combinations to no avail.
Thanks in advance for your help!
Main Report (contains Year parameter field)
Group By Municipality
Group Header
.
.
Details (displays records (Trees) based on Year parameter)
.
.
Group Footer 1a (contains a summary of data from Details section)
Group Footer 1b (contains a Subreport which is linked on the Year parameter field from the Main Report and displays Firewood records based on Year)
Here's the dilemma, for some reason, if the Main Report displays no records (trees) based on the Year selected, then the Subreport also is blank. However, the subreport should be displaying data (Firewood) on the chosen year. It seems that the Subreport will only display records (Firewood) if the Main Report Details has records (Trees) for the chosen year. This should not be the case, as not all areas will have Trees and Firewood for the chosen year...(i.e. some will only have Firewood).
Any ideas? Could this be a problem with linking? I've tried various linking combinations to no avail.
Thanks in advance for your help!