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

SubReport on Main Report Page Footer - Didnt think it would be so hard.

P: n/a
Hi everyone,
I have been searching 3 days stright for an answer, with no luck, so I
decided to ask it out loud myself.

Here is my problem.
I am using a report as a catalog for my company. The main report holds
our products with details (each detail is a product based on our
products table). Some of the products show up twice on the main report
(as they have diffrent specifications per line). I thought that instead
of putting the products picture on each line, save space on the page
and put all pictures of all products on the page, as a subreport on the
main reports Footer.
This way I can put only one picture of every product, even if it shows
twice on the main report.
I have wrote some code, that adds the productID to a temp table (code
using the Details Format event of the main report), and then based my
subreport grouping on that table.
I have thought the subreport requeries its recordsource on every page,
and by that will always take the products from the temp table, that
changes on every page.
I cannot get this to print out correctly, and trying to understand if I
am even thinking in the right direction at all.
Is there another way to print pictures of items on the bottom of the
page , which takes the picture name from the all the details on the
report??

Will update if I find anything new, hope someone can help.

Thanks in advance
Eli

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"cityrock" wrote
... report as a catalog for my company. The main
report holds our products with details (each detail
is a product based on our products table). Some
of the products show up twice on the main report
(as they have diffrent specifications per line). I
thought that instead of putting the products picture
on each line, save space on the page and put all
pictures of all products on the page, as a subreport
on the main reports Footer. This way I can put only
one picture of every product, even if it shows twice
on the main report. I have wrote some code, that
adds the productID to a temp table (code using the
Details Format event of the main report), and then
based my subreport grouping on that table. I have
thought the subreport requeries its recordsource on
every page, and by that will always take the products
from the temp table, that changes on every page.
I cannot get this to print out correctly, and trying to
understand if I am even thinking in the right direction
at all. Is there another way to print pictures of items
on the bottom of the page , which takes the picture
name from the all the details on the report??


Page Footers work very well for displaying page numbers, date/time, and
title. They do not work all that well for things like subreports -- for
example, they do not have the very useful Can Grow and Can Shrink. Also, how
would you know how many pictures you'd need in a Subreport in each page.

I'd suggest you group on Product, and put the picture for the product in
either the Group Header and Group Footer, instead. I suspect that will work
a lot better for you.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.