报告 [英] Reporting

问题描述

我有一个用于消防栓检查的数据库。每个消防栓大约有15种不同的物品需要检查。大约2000个消防栓。我将每个需要检查的项目作为主表中的单独字段进行检查。我的问题是，我需要为每个消防栓编制一份报告。我想要一些类型的列表视图，每页有20个消防栓，但这是不可能的，有多少不同的字段。如果出现问题，我真的只需要显示一个字段。我有点迷失在如何处理这个问题，如果有人有任何建议，我很好奇。我有一个想法是，如果一个字段有问题，它可以发送一些自定义文本到文本框说明问题。然后在我的报告中，我只需要显示该文本框。但是有太多的领域和更多，有一件事可能是错误的同一消防栓，我不是一个足够先进的用户正确编码...对不起，如果这是令人困惑的，如果我需要澄清什么，只是问问我will。

I have a database that i use for hydrant inspections. There are about 15 different items per hydrant that need to be inspected. About 2000 total hydrants. I have every item that needs to be inspected as a separate field in my master table. My problem is, i need to compile a report for every hydrant. I would like some type of list view with like 20 hydrants per page but that is impossible with how many different fields there are. I really only need to show a field if there is a problem. Im kind of lost on how to handle this and was curious if anyone had any suggestions. One thought i had was if a field had a problem, it could send some custom text to a text box stating the problem. Then on my report i would only have to display that text box. But there are so many fields and more that one thing can be wrong with the same hydrant and i am not an advanced enough user to code that properly... sorry if this is confusing and if i need to clarify anything, just ask and i will.

推荐答案

对我来说是一个很棒的镜头;但是，您是否尝试过交叉表查询/报告？您可以将列作为标题和消防栓作为行进行拟合吗？或者您正在寻找不同的格式？

A long shot for me; however, have you tried a cross tab query/report? You might be able to fit the columns as the headers and the hydrants as the rows? Or are you looking for a different format?

这将使我们更容易提供帮助，并且您应该从相同的上下文中说出帮助。你能告诉我们你的表格布局（字段名称和类型）以及一些示例记录吗？

It would make it alot easier for us to present help and for you to undersaid said help it we speak from the same context. Could you please show us your table layout (Field names and types) as well as a few example records?

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