单个数据库中的多个报告问题 [英] Multiple Report Issues within single Database

问题描述

我最近获得了更新我的Access dB（2000版本）的工作，我在这里有点过头了（我对Access的工作仅限于将信息输入表单或运行所请求的报告 - 现在他们问我更新/修复/设计这些东西!!）。该数据库是多年前由其他一些方设计的，并且每年都被复制以创建新的数据库。这个数据库如果用于运送圣诞树，那么它可以保存装载日期，发货日期，装货地点，承运人，多个客户（滴）和产品。现场工作人员有各种各样的报告，以便他们总是在需要削减的东西，这些将来自哪些领域等等。我遇到的问题是今年他们增加了新产品（我知道如何进入应该将其放入表中的表格 - 反过来，它应该使所有报告都可以访问它，对吗？）。我遇到的问题有几个：


在我们的收获/产品摘要报告中（我知道这些名称对你没有任何意义，但希望它有助于区分报告），我能够看到并链接（在设计视图的属性窗口中）与现有的产品，但我更改了名称。但是，我输入的新产品不会出现。它们以我们用于输入负载信息的形式显示，但它们不会显示在属性窗口中 - 因此我无法链接这些字段。当我查看相应的表格时，他们的产品都按照应有的方式存在。但是，在我的xTab文件中列出了曾经存在于任何数据库中的所有产品。我不能改变它们中的任何一个，因为它们是链接表，因此修改它们不会起作用。


在我们的每日承运人负载表报告中，负载按发货日期提取，显示负载编号，运营商，并且应该显示该负载上的总产品。它按总产品列出（即如果有8滴，每个有2个D6P托盘，它将显示16个D6P）。整个领域都是空白的。所有其他信息都应该填充。在设计视图中，所示的全部是加载概要。在现场 - 但我似乎无法找到生成Load Sysnopsis的地方。


我相信你会需要一些例子，我会努力把这些上传到这里......但任何想法或建议都会很棒！


谢谢大家！

解决方案

他们添加了新产品（我知道如何进入表单应该把它放在表格中 - 反过来，它应该让所有报告都能访问它，对吗？）。

如果数据库设计正确，那么它应该是！


我正在审视你的帖子的其余部分......更多评论来

这里有几个问题，让我们一次拿一个，你可以在我们去的时候找到其余的解决方案。


在您的收获/产品摘要报告中，您提到的有几件事需要进行验证。

我能够查看和链接（在设计视图的属性窗口中）到现有产品

我想你的意思是设计视图报告但属性窗口是什么？

但是我改名为

使用更多细节进行充实，我只是猜测你改名为什么???

但是，我输入的新产品不会出现

出现在什么???我不确定他们应该出现什么，我在报告中知道，但报告中有什么？


在解释你的问题时，你需要简洁明了并且尽可能地但你必须记住，我们看不到你的数据库，报告，表格等。


所以，要完整但也要完整。

可能对你有用的东西。

如果我在你的位置，这就是我接近它的方式。

从报告。

它绑定的是什么？一个查询，一个表，什么？
如果报告绑定到查询

查询哪些表？
关于报告

它上面有什么控件？

这些控件绑定了什么？


映射所有这些在一张纸上，它可以帮助你理解数据库的设计方式，并为你提供一些参考资料来帮助你了解为什么某些东西不起作用。

I have recently acquired the job of updating our Access dB (2000 version) and I am a bit over my head here (my work with Access was limited to entering information into forms or running the reports requested - now they are asking me to update/fix/DESIGN these things!!). The database was designed by some other party many years ago, and has been copied to create new databases every year. This data base if for shipping of Christmas trees, so it hold load date, ship date, loading site, carrier, multiple customers (drops) and products. There are various reports that are run for the field crews so that they are always on top of what needs to be cut, what fields those will come from, etc. The problem I have is that this year they have added new product (which I know how to enter into the form that should be putting it in the table - which, in turn, should make it accessable by all reports, right?). The problem I am having are several:

In our Harvest/Product Summary Reports (I realize these names don''t mean anything to you, but hopefully it will help in differentiating between the reports), I am able to see and link (in the properties window in design view) to the products that were existing, but I altered the name. However, the new products that I entered DO NOT show up. They show up in the form we use to enter the load information, but they do not show in the properties window - so I can''t link these fields. When I look in the appropriate table, they products all exist as they should. However, in my xTab file ALL products that have ever been in any of the databases are listed. I can''t change any of them because they are linked tables, so modifying them won''t work.

In our Daily Carrier Load Sheet Report, Loads are pulled by Ship Date, show the load number, carrier, and is supposed to show what total product is supposed to be on that load. It is listed out by total product (i.e. if there are 8 drops and each has 2 pallets of D6P, it would show 16 D6P). This whole field is blank. All other information populates like it should. In design view, all that is shown is "Load Synopsis" in the field - but I can''t seem to find WHERE the Load Sysnopsis is generated.

I am sure you will need examples, and I will work on getting those uploaded here ... but any thoughts or suggestions would be wonderful!

Thanks everyone!

解决方案

they have added new product (which I know how to enter into the form that should be putting it in the table - which, in turn, should make it accessable by all reports, right?).

If the database was designed correctly then YES it should!

I am getting my head around the rest of your post......more comments to come

You have several issues here, lets take then one at a time and you may discover the solution to the rest as we go.

On your Harvest/Product Summary report there are several things that you mention that needs clatification.

I am able to see and link (in the properties window in design view) to the products that were existing

I guess you mean design view of the report but the properties window of what?

but I altered the name

Flesh this out with more detail, I am just guessing as to what you changed the name of???

However, the new products that I entered DO NOT show up

Show up in what??? I am not sure exactly what they are supposed to be showing up in, I know on the report, but what in the report?

When explaining your issues you do need to be as concise and to the point as possible but you must remember, we can''t see your database, reports, forms etc.

So, be concice but also be complete.

Just something that might help you.
If I was in your place this is how I might approach it.

Start at the report.
What is it bound to? a query, a table, what?
If the report is bound to a query
What tables is it querying?
On the report
What controls are on it?
What are those controls bound to?

Map all of these things, and anything else that might be usefull, out on a piece of paper, it will help you get an understanding of how the database has been designed and give you a reference for tracing through why something isn''t working.

这篇关于单个数据库中的多个报告问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！