By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Subreport: layout differs in main report

BlindSeer
P: 2
Hi, I'm stumped and need help. I'm working on a complex Access report, with several subreports many levels deep. The trouble started when adding a new subreport to the main one.

In the (subreport) print preview, it shows all fields same as the design view, just as it should. When the subreport is added to the main one, the layout changes. It shows the first field, no problem, but only one of the others, and not where it should be.

It just occurred to me (while writing this) that the subreport query is comprised of subquerys, and these are the fields that don't layout right. I'll try saving the results of the query into a table, then use that in the subreport, and hope this resolves things.

I thought I was getting the hang of Access, now I have my doubts.


Help please! Thx, BlindSeer
Apr 14 '08 #1
Share this Question
Share on Google+
1 Reply


BlindSeer
P: 2
False alarm. My bad! I was looking at one thing, thinking I was seeing something else.

Nice was to start off here on the wrong foot! I guess my name was chosen better than I knew -- lol

-- BlindSeer


Hi, I'm stumped and need help. I'm working on a complex Access report, with several subreports many levels deep. The trouble started when adding a new subreport to the main one.

In the (subreport) print preview, it shows all fields same as the design view, just as it should. When the subreport is added to the main one, the layout changes. It shows the first field, no problem, but only one of the others, and not where it should be.

It just occurred to me (while writing this) that the subreport query is comprised of subquerys, and these are the fields that don't layout right. I'll try saving the results of the query into a table, then use that in the subreport, and hope this resolves things.

I thought I was getting the hang of Access, now I have my doubts.


Help please! Thx, BlindSeer
Apr 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.