Subreports Do Not Show In Landscape View

[Matty]

Hi,

I have a report that shows a list of referrals, organized by the type of doctor referring. This report has two subreports, each showing a further breakdown for a different type of doctor (one for respirologist, one for sleep specialist). The problem is that these subreports don't show up when the main report is previewed in landscape orientation. Also, when the subreports don't show up, it seems like there is no "last page" to the report. I keep clicking next page, and it keeps going...I click the last page button, and it works endlessly to get to the last page, eventually freezing up.

The subreports show up when I preview it in portrait, but since the whole report is so wide, it goes over 2 pages that way. The even weirder thing is that this report works wonderfully on the copy of the database I have in my office. The problematic one is on a completely independent copy of the database being used in Calgary (i'm in Winnipeg).

If anyone has any suggestions, I'd love to hear them...

 

[Rob.Mills]

Most likely the detail section of your report is too long for landscape view.

You might try shrinking the length of your subreport so that you can shrink the detail section.

 

[suepowell]

Regarding the report being different on databases in different locations, check the margins and paper size in the page setup on both databases.

I have found that whenever you do anything to the design of a report, sometimes even just look at it, the page setup reverts to the default. This could be the problem if the paper size is set very small.

I also have a copy of a customers database on my system, on his site the font shows correctly, but on my site the font name is correct, but doesnt' display correctly although the same font is installed on both PC's.

Odd but true.

Sue

 

[Matty]

I actually had made up a static group (i don't know if that's the correct terminology), and put the two subreports in that group footer. They WERE too long, top to bottom, and that's why they didn't show up. I just made a second static group, and put a subreport in each footer. I think it should work.

Thanx for your help.