在报告中将字段设为不可见/将数据添加到“交叉”选项卡报告中 [英] Making Fields Invisible in Reports / Adding data to Cross tab Report

问题描述

Alrighty Guys和Gals，我还有一个问题，希望大家都能帮到我。


我有一个报告，它使用交叉表查询作为记录源。此交叉表查询从另一个查询获取其所有信息。该查询qryRpt正在从几个不同的表中提取信息。其中一个表是tblDistributions，一个表保存特定投资的月度分配，第二个是tblDeduction，一个表格，其中包含一个十进制值乘以投资金额以返回投资者将获得的减税额。这些不是唯一的两个表，但它们是给我带来问题的表。


我在tblDeductions和tblDistributions之间有一个内部联接，所以所有的分发记录都将即使没有扣除也会显示，因为并非所有投资都有税收优惠。


我想解决的两个问题如下：


1.在报告中，它有一个文本框，txtDeduction和标签，lblDeduction，用于减税。由于并非所有投资都具有税收优惠，因此我希望此列仅在存在扣减记录时可见。

我在报告的On Open事件中试过这个

展开 | 选择 | Wrap | 行号

解决方案

我在tblDeductions和tblDistributions之间有一个内部联接，这样即使没有扣减，也会显示所有的分配记录，因为并非所有投资都有税效益。

这将是一个正确的加入，即

展开 | 选择 | Wrap | 行号

你好玛丽，

对于非常延迟的回复很抱歉。我患有流感最坏的情况，很可怕。我今天回到了办公室，并对我的报告进行了格式化的更改。它就像一个魅力！


我仍​​然要面对的一个问题是如何在当年没有分配时显示减税。那里有什么建议吗？


谢谢，

Allen

你好玛丽，

对于非常延迟的回复很抱歉。我患有流感最坏的情况，很可怕。我今天回到了办公室，并对我的报告进行了格式化的更改。它就像一个魅力！


我仍​​然要面对的一个问题是如何在当年没有分配时显示减税。那里有什么建议吗？


谢谢，

Allen

你好Allen


看看我的帖子的第一部分关于将连接更改为右连接（或视情况而定）。


Mary

Alrighty Guys and Gals, I have another question that I hope you all can help me with.

I have a report that uses a cross-tab query as its record source. This cross-tab query is getting all of its information from another query. That query, qryRpt, is pulling information from several different tables. One of these table is tblDistributions, a table that holds monthly distributions for a particular investment, and the second is tblDeduction, a table that holds a decimal value that is multiplied by the amount invested to return the amount of tax deduction that the investor will receive. These are not the only 2 tables, but they''re the ones that are giving me problems.

I have an inner join between the tblDeductions and tblDistributions so that all the distribution records will be shown even if no deductions are present, because not all investments have a tax benefit.

The two problems I would like to solve are as follows:

1. On the report, it has a text box, txtDeduction, and label, lblDeduction, for the tax deductions. Since not all investments have a tax benefit I would like this column to only be visible when a deduction record is present.
I''ve tried this in the On Open event of the report

Expand|Select|Wrap|Line Numbers

解决方案

I have an inner join between the tblDeductions and tblDistributions so that all the distribution records will be shown even if no deductions are present, because not all investments have a tax benefit.

This would be a Right Join i.e.

Expand|Select|Wrap|Line Numbers

Hello Mary,
Sorry for the terribly delayed reply. I had the worst case of the flu, it was awful. I''m back in the office today though and made the changes to my reports for the ''on format''. It worked like a charm!

The one problem that I''m still having to confront is how to get the tax deduction to display when there''s no distributions for that year. Any suggestions there?

Thank you,
Allen

Hello Mary,
Sorry for the terribly delayed reply. I had the worst case of the flu, it was awful. I''m back in the office today though and made the changes to my reports for the ''on format''. It worked like a charm!

The one problem that I''m still having to confront is how to get the tax deduction to display when there''s no distributions for that year. Any suggestions there?

Thank you,
Allen

Hi Allen

Have a look at the first part of my post about changing the join to a right join (or left as the case may be).

Mary

这篇关于在报告中将字段设为不可见/将数据添加到“交叉”选项卡报告中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！