如何从表中报告计划格式 [英] How to report schedule format from table

问题描述

我有一张生产表。在表tblJobAdress中，我有名为JobNumber，Address，RoughDate，TopoutDate和TrimDate的字段。


我想要一个包含星期几（周一至周六）列的报告粗糙，隆起和修剪的行标题。细节是地址。


我目前有一份报告，但每行只有一个地址。周一的第一个地址有一个级联效应，周二到周六有空单元格。下一行星期一是空的，星期二的地址和星期三到星期六的小区是空的。这是报告的全部内容。


我想要实现的是第1行的第一个地址是星期一，第一个地址是星期二，第一个地址是星期三，第一个地址星期四，星期五的第一个地址，星期六的第一个地址。而不是层叠下来。


表中的样本数据为当前报告做好准备

附加图像

Schedule.jpg （66.5 KB，227 views）

解决方案

让我们看看我是否理解正确

取你图像中的前十行[Phase] ="粗糙"

星期一第一个条目在第10行，你希望从第一行开始。与星期二等相同......

展开 | 选择 | Wrap | 行号

是的，这是我想要的效果。


我使用MS Access进行表和查询。从查询将计划日期更改为星期几开始。然后我使用Crosstab Pivot查询使用星期几作为列标题和地址作为值。然后我将数据附加到我报告的临时表中，以获得本周和下周计划的永久性。


这是以逗号分隔的起始数据：

展开 | 选择 | Wrap | 行号

好的，

关于你的数据集的问题，是一个表中的所有，或者你有吗？标准化？


重置这将需要我们一点点才能通过。 ：）

I have a production table. In the Table tblJobAdress, I have fields named JobNumber, Address, RoughDate, TopoutDate, and TrimDate.

I want a report that has columns with the Day of the Week (Mon-Sat) Row Headers of Rough, Topout, and Trim. And the details being the address.

I currently have a report that does that, but only one address is in each row. There is a cascading effect with first address on Monday having empty cells for Tuesday through Sat. Next row Monday is empty, Address on Tuesday and cells for Wednesday through Sat are empty. this is all the way through the report.

What I am trying to achieve is to Row 1 have the first address for Monday, first address for Tuesday, first address for Wednesday, first address for Thursday, first address for Friday, first address for Saturday. Instead of Cascading down.

Sample data from table ready for current report

Attached Images

Schedule.jpg (66.5 KB, 227 views)

解决方案

Let''s see if I understand correctly
Take the first ten rows in your image [Phase]="Rough"
In Monday the first entry is on row 10, you would like that to start in row one. Same with Tuesday, etc...

Expand|Select|Wrap|Line Numbers

Yes this is the Effect I am trying to get.

I use MS Access for the Tables and Queries. Starts off with query changing the schedule date into Day of Week. Then I use a Crosstab Pivot Query using the Day of Week as Column Header and Address as Value. Then I Append the Data to a Temp Table from which I Report from to get a perpetual this week and next weeks schedule.

Here is the beginning data in comma delimited:

Expand|Select|Wrap|Line Numbers

OK,
Question about your dataset, is that all in one table, or do you have that normalized?

The reset of that will take us a little-bit to wade thru. :)

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