如何基于具有正确分组的3个表创建报告？ [英] How to create a report based upon 3 tables with correct grouping?
问题描述
我正在尝试在考古遗址上创建一份报告，其中包含来自三个不同表格的数据： [网站]，[地图]和[相片]。 每个网站可以有多个照片和多个地图。 我已经创建了适当的关系，并且
工作得非常好。 我已经成功为带地图的网站以及带照片的网站创建了报告，但无法弄清楚带有照片和地图的网站....
I’m trying to create a report on archaeological sites which contains data from three different tables: [Sites], [Maps], and [Photos]. Each Site can have multiple Photos and multiple Maps. I’ve created the appropriate relationships and everything's working great. I've successfully created reports for Sites with Maps, as well as for Sites with Photos, but can't figure out Sites with Photos AND Maps....
我想要报告打印一页包含父记录的信息，然后是地图所需的页数，然后是照片所需的页数，然后再移动到下一条记录并以相同的模式打印。 我需要每页顶部的[Sites] Site_Name
字段，以及"带有照片和地图的网站列表"等标题。
I’d like the report to print one page with the parent record’s information, followed by as many pages needed for the maps, and then as many pages needed for the photos, before moving to the next record and printing in the same pattern. I need the [Sites]Site_Name field at the top of each page, along with a title like "Site Listing With Photos and Maps."
我曾经在分组和不同的部分工作，但最终得到了一些有趣的结果，哈哈。
I've worked with grouping and different sections, but have ended up with some funny results, lol.
对于ASCII艺术感到抱歉，但是我一直在试图发布我精心准备的布局图形时出错。 ：（
Sorry about the ASCII art, but I kept getting an error trying to post my carefully-prepared graphic of the layout. :(
设计视图：
Design View:
............... ...............
..............................
。 来自[网站]的信息 。
. info from [Sites] .
。 （text等） 。
。 ---------------- 。
. (text, etc.) .
. ---------------- .
。 Maps 。
. Maps .
。 -----------------
. ----------------- .
         照片         &NBSP ;。
.............................
. Photos .
.............................
因此，如果一个网站有1张地图和3张照片，该报告将长达5页：
So if a Site had 1 map and 3 photos, the report would be 5 pages long:
Page 1： ;来自网站表格的信息，主要是文字。
Page 1: information from the Sites table, mostly text.
;  第2页： 一张地图，有几个相关字段，如描述等。
Page 2: one map, with a couple associated fields like description, etc.
第3-5页： 每个页面都会有一张照片及其描述（文本）字段。
Pages 3-5: each page would have one photo, together with its description (text) field.
预先感谢您提供给我的任何帮助。 我花了一些时间谷歌/ youtube这个，但没有找到任何想法。 （在相关的说明中，有谁知道为什么我不能在这个论坛上发布图片？）
Thanks in advance for any help you can give me. I've spent some time googling/youtube this, but have failed to find any ideas. (On a related note, does anyone know why I can't post pics to this forum?)
问候， RC
Regards, RC
推荐答案
使用包含两个子报告（地图和照片）的报告。 子报表将使用tblSites主键及其匹配的外键字段与主报表相关。
Use a report with two subreports (maps & photos). The subreports would be related to the main report using the tblSites primary key and their matching foreign key fields.
这篇关于如何基于具有正确分组的3个表创建报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
