开发者

How do I show all group headers in Access 2007 reports?

开发者 https://www.devze.com 2022-12-29 04:11 出处:网络
This is a question about Reports in Access 2007. I\'m unsure whether the solution will involve any programming, but hopefully someone will be able to help me.

This is a question about Reports in Access 2007. I'm unsure whether the solution will involve any programming, but hopefully someone will be able to help me.

I have a report which lists all records from a particular table (call it A), and groups them by their associated record in a related table (call it B). I use the 'group headers' to add the information from table-B into the report.

The problem occurs when I filter the records from table-A that are shown in the report. If I filter out all table-A records that relate to a particular record (call it X) in table-B, the report no longer shows the record-X group header.

As a possible workaround, I have tried to ensure that I have one empty record in table-A for each of the records in table-B. That way I can specify NOT to filter out these empty records. However, the outcome is ugly one-record-开发者_高级运维high blank spaces at the start of each group in the report.

Does anyone know of an alternative solution?

EDIT:

For clarity, I should highlight what I hope to achieve. For records in table-B that are not linked to any records in the filtered table-A, the group header (and footer) for these records will not appear in the report. I am trying to change this, so that the group header and footer appears immeiately after each other (since there are obviously no records to put in the group body).

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号