Need a subreport to ....

[Indigo]

Help with subreport and Images....

I need some help in Access 2010. I am creating a report with a subreport. I need the subreport to do two things and I can't seem to get them to work together. First of all, I need a page header to repeat which I got working creating a header based on an expression (=1) and changed "Repeat Section" to Yes.

Secondly, I need to show only two records per page. I found the solution to that here: http://www.databasedev.co.uk/report_printing.html

The problem I am having is that if I remove the header the "show only two records" works fine. But when I add the header, I get all the records instead of two at a time.

Can anyone offer a solution? Thanks in Advance.:banghead:

 

[llkhoutx]

I don't quite understand what your doing, but you can count records and that unhide a (hidden) page break in your report.

 

[Indigo]

I have worked out a solution for the header, so that is a non-issue. However I cannot get the other issue working properly.

I have a main report with a subreport. I need to force a new page on the main report after 2 records are displayed on the subreport.

 

[Indigo]

Help with subreport and images

I am hoping that I can better explain myself after playing around in a test database I created. Working in Access 2010 I have two tables: Type and SubType. I am creating a main report with the table Type as the record source. The TypeID field is a foreign key in the SubType table and the SubType table is the record source for the subreport. I have set up the subreport to print only two records per page, using the solution I found here: http://www.databasedev.co.uk/report_printing.html

Now, here is where it gets tricky. I want to place a second subreport in the the page footer of the main report. In the SubType table, there is a picture file field with the location of a corresponding picture for each SubType record. I want this subreport to populate with the corresponding pictures from each record displayed in the subreport from the detail section.

I have attached an image of what I am trying to create.

Any suggestions / advice would be appreciated. Thank you!