REPORT DISPLAY

[Guest]

I have a Report with a Sub Report . I have Put the Sub Report in the Detail
section of the Report , and hav other information in the Page Header where I
have put some Banking Details etc.... When I View the Report there is a Blank
Space where the Detail section should be and the Sub Report is Displaying on
the Other Page. with the detail of the Group Footer now on both pages I have
tried the margins on my Page Setup. My whole page is definitely big enough
for all to fit in. ) I have done 100's similar reports and I have never
ezperienced this. I have played around with the Property settings on both
Reports " Keep Together etc... " I suspect it may have something to do with
the fact that Both Reports has a grouping option of " Customer Number" , but
I can not change this because when I take the Grouping option out of the Sub
form it refuses to Total my Currency fields. How do I get this Report to
display on one page only

 

[Scott McDaniel]

I have a Report with a Sub Report . I have Put the Sub Report in the Detail
section of the Report , and hav other information in the Page Header where I
have put some Banking Details etc.... When I View the Report there is a Blank
Space where the Detail section should be and the Sub Report is Displaying on
the Other Page. with the detail of the Group Footer now on both pages I have
tried the margins on my Page Setup. My whole page is definitely big enough
for all to fit in. ) I have done 100's similar reports and I have never
ezperienced this. I have played around with the Property settings on both
Reports " Keep Together etc... " I suspect it may have something to do with
the fact that Both Reports has a grouping option of " Customer Number" , but
I can not change this because when I take the Grouping option out of the Sub
form it refuses to Total my Currency fields. How do I get this Report to
display on one page only

Often this is caused by a combination of various settings (like the Keep Together setting you mention). Since you've
done 100's of others, review some of those and compare the settings on those reports to this one, see what's changed.
Also review the Recordsource of your subreport and make sure you're not getting blank values and that you're getting
only the data you want.

Don't forget to look into the Sorting and Grouping section to make sure those settings are correct.


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com