报告重复记录 [英] Report repeating records

问题描述

我正在为实验室开发一个数据库，在一天结束时我需要生成报告并通过电子邮件发送给主管，我有七个不同的报告开始，我通过创建关系将其降低到3但唯一的问题是现在是表格，例如每日砂实验室数据，脆弱性，Loi Molding Sand。比如说，每日沙实验室数据表有一天的7条记录和脆弱性，Loi只有1-2条记录，现在当我创建一个联合报告时，它再次重复数据n为脆弱性和LOI而不是一页有报告中有3-6页，有人可以建议我采用更简单的方法。


谢谢，

Tulika

I am developing a DB for a lab and at the end of the day i need to generate reports and send by email to supervisors, i had seven different reports to begin with, which i have brought down to 3, by creating relationships but the only problem is right now is that the tables for e.g. daily sand lab data, friability, Loi Molding Sand. Say, Daily sand lab data table has 7 records for one day and friability and Loi have only 1-2 records, now when i create a joined report, it repeats data again n again for the friability and LOI and instead of one page there are 3-6 pages in report, can someone please suggest me a simpler way of doing the same.

Thanks,
Tulika

推荐答案

帮助我们了解你的情况重新尝试报告，表格中有什么，表格是如何相关的。

To help we need to know what you''re trying to report, what''s in the tables, and how the tables are related.

帮助我们需要知道什么你试图报告，表格中有什么，以及表格是如何相关的。

To help we need to know what you''re trying to report, what''s in the tables, and how the tables are related.

表格中包含Daily Sand Lab的日期，时间，单位，运营商，mois，comp，GS，Perm等值，并且它具有值date，时间，单位，操作员，wt。在平底锅，绿色沙子的脆性，然后日期，时间，单位，操作员，重量的脆弱性。在加热之前，wt。加热后和Loi造型砂中的％loi。


现在我想将所有表格相关联，以便在一天结束时生成报告，这样我就不需要将它们放入三个不同的报告和电子邮件，所以我在查询中建立关系，通过主键和日期连接所有表，所以现在我得到报告中的所有值，但因为我有7个值为每日砂实验室和2每个因为绿沙和loi沙子的可见性，报告看起来完全混乱并不断重复loi和脆弱性数据。


任何帮助将不胜感激。

The tables have the values for date, time , unit, operator, mois, comp, GS, Perm etc for the Daily Sand Lab and it had the values date, time, unit, operator, wt. in pan, % friability for the friabilty of green sand and then date, time, unit, operator, wt. before heating, wt. after heating and % loi in Loi molding sand.

Now i want to related all the tables together to generate the report at the end of the day such that i dont need to put them in three different reports and email them, so i made relationships in a query to connect all the tables via primary key and then Date, so now i get all the values in the report but then since i have 7 values for daily sand lab and 2 each for fraibility of green sand and loi sand hence the report looks messed up completely and keeps repeating the loi and friability data.

Any help will be appreciated.

这些表格包含Daily Sand Lab的日期，时间，单位，运营商，mois，comp，GS，Perm等值，它具有日期，时间的值，单位，操作员，wt。在平底锅，绿色沙子的脆性，然后日期，时间，单位，操作员，重量的脆弱性。在加热之前，wt。加热后和Loi造型砂中的％loi。


现在我想将所有表格相关联，以便在一天结束时生成报告，这样我就不需要将它们放入三个不同的报告和电子邮件，所以我在查询中建立关系，通过主键和日期连接所有表，所以现在我得到报告中的所有值，但因为我有7个值为每日砂实验室和2每个因为绿沙和loi沙子的可见性因此报告看起来完全混乱并且不断重复loi和脆弱性数据。


任何帮助将不胜感激。

The tables have the values for date, time , unit, operator, mois, comp, GS, Perm etc for the Daily Sand Lab and it had the values date, time, unit, operator, wt. in pan, % friability for the friabilty of green sand and then date, time, unit, operator, wt. before heating, wt. after heating and % loi in Loi molding sand.

Now i want to related all the tables together to generate the report at the end of the day such that i dont need to put them in three different reports and email them, so i made relationships in a query to connect all the tables via primary key and then Date, so now i get all the values in the report but then since i have 7 values for daily sand lab and 2 each for fraibility of green sand and loi sand hence the report looks messed up completely and keeps repeating the loi and friability data.

Any help will be appreciated.

什么是主键？

你能发布查询的SQL吗？

可以你提供了一些虚构的数据来证明你正在寻找的结果吗？

What''s the primary keys?
Can you post the SQL of your query?
Can you provide some fictitious data to demonstrate the results you''re looking for?

这篇关于报告重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！