Vertically Aligning Fields in a Sub-Report
in [Reports]
|
Prev: Order Details in horizontal list instead of vertical list
Next: Converting from MS-Access 2003 to 2007
From: RichKorea on 5 Jul 2008 10:08 I'm putting together a report for a service database where each service ticket can have multiple call reports, and each call report can have multiple engineers associated with the report. While all the data's getting on to the form, the vertical alignment shifts if there's more then one service engineer. What I would like to have is: Data Eng #1 Task Data 1 Memo Eng #2 Task Data 2 Memo Task Data 3 Memo What I'm getting is: Data Eng #1 Task Data 1 Memo Eng #2 Memo Task Data 2 Memo Task Data 3 The textboxes for Task Data 2 & 3 are shifting down to align with the bottom of the last engineer, but I don't want them to shift. My data's setup as follows: The service ticket data comes from the main table The Task Data fields 1, 2 & 3 come from a task table, which references the service ticket's key. The service engineers come from a table that tracks which engineers worked on which task (can be one or more then one), referencing the task key. My report's setup as follows: The service engineers are in a sub-report that has a field for the engineer's name and is connected to the task key. The tasks are in another sub-report that has the engineer sub-report on the left, linked to the task sub-report's task key, three textboxes stacked vertically for three dates in the middle, and a textbox on the right that's connected to the task description, which is a memo field. The service ticket data's in the top level report, with the task report as a sub-report. Thanks, Rich
From: Duane Hookom on 7 Jul 2008 10:01 I am confused by your description. I don't know is you have 3 Task Data fields or 3 Task Data records. You mention 3 dates and memo field linked to task description but don't provide information on which table or where task description is located. -- Duane Hookom Microsoft Access MVP "RichKorea" wrote: > I'm putting together a report for a service database where each service > ticket can have multiple call reports, and each call report can have multiple > engineers associated with the report. While all the data's getting on to the > form, the vertical alignment shifts if there's more then one service engineer. > > What I would like to have is: > Data Eng #1 Task Data 1 Memo > Eng #2 Task Data 2 Memo > Task Data 3 Memo > > What I'm getting is: > Data Eng #1 Task Data 1 Memo > Eng #2 Memo > Task Data 2 Memo > Task Data 3 > > The textboxes for Task Data 2 & 3 are shifting down to align with the bottom > of the last engineer, but I don't want them to shift. > > My data's setup as follows: > The service ticket data comes from the main table > The Task Data fields 1, 2 & 3 come from a task table, which references the > service ticket's key. > The service engineers come from a table that tracks which engineers worked > on which task (can be one or more then one), referencing the task key. > > My report's setup as follows: > The service engineers are in a sub-report that has a field for the > engineer's name and is connected to the task key. > The tasks are in another sub-report that has the engineer sub-report on the > left, linked to the task sub-report's task key, three textboxes stacked > vertically for three dates in the middle, and a textbox on the right that's > connected to the task description, which is a memo field. > The service ticket data's in the top level report, with the task report as a > sub-report. > > Thanks, > Rich >
From: RichKorea on 7 Jul 2008 18:02 Sorry for the confusion. In my sample illustration, it was 3 fields. It's possible to have multiple task records, but I left that out of my first illustration to keep it simple. A better sample with three task records of what I'm getting might be: Task1 Eng #1 Task Field 1 Memo Eng #2 UNWANTED SPACE Memo Task Field 2 Memo Task Field 3 Task2 Eng #1 Task Field 1 Memo Task Field 2 Memo Task Field 3 Memo Task3 Eng #2 Task Field 1 Memo Eng #3 UNWANTED SPACE Memo Eng #5 UNWANTED SPACE Memo Task Field 2 Task Field 3 Depending on the number of engineers, fields 2 & 3 are moving down on the page, creating an unwanted space. The memo field, which is a single field, expands to the size of the input data, without any blank lines, so it's displayed nicely. It's just fields 2 & 3 that will move down if there's more then one engineer (the engineer comes from a separate table, so right now I've got the engineer as a subform with just the single field in it). Thanks for your help. "Duane Hookom" wrote: > I am confused by your description. I don't know is you have 3 Task Data > fields or 3 Task Data records. You mention 3 dates and memo field linked to > task description but don't provide information on which table or where task > description is located. > > -- > Duane Hookom > Microsoft Access MVP > > > "RichKorea" wrote: > > > I'm putting together a report for a service database where each service > > ticket can have multiple call reports, and each call report can have multiple > > engineers associated with the report. While all the data's getting on to the > > form, the vertical alignment shifts if there's more then one service engineer. > > > > What I would like to have is: > > Data Eng #1 Task Data 1 Memo > > Eng #2 Task Data 2 Memo > > Task Data 3 Memo > > > > What I'm getting is: > > Data Eng #1 Task Data 1 Memo > > Eng #2 Memo > > Task Data 2 Memo > > Task Data 3 > > > > The textboxes for Task Data 2 & 3 are shifting down to align with the bottom > > of the last engineer, but I don't want them to shift. > > > > My data's setup as follows: > > The service ticket data comes from the main table > > The Task Data fields 1, 2 & 3 come from a task table, which references the > > service ticket's key. > > The service engineers come from a table that tracks which engineers worked > > on which task (can be one or more then one), referencing the task key. > > > > My report's setup as follows: > > The service engineers are in a sub-report that has a field for the > > engineer's name and is connected to the task key. > > The tasks are in another sub-report that has the engineer sub-report on the > > left, linked to the task sub-report's task key, three textboxes stacked > > vertically for three dates in the middle, and a textbox on the right that's > > connected to the task description, which is a memo field. > > The service ticket data's in the top level report, with the task report as a > > sub-report. > > > > Thanks, > > Rich > >
From: Duane Hookom on 7 Jul 2008 21:48
Sorry if this is a repeat... Can you provide your actual table and field names with their relationships? -- Duane Hookom Microsoft Access MVP "RichKorea" wrote: > Sorry for the confusion. In my sample illustration, it was 3 fields. It's > possible to have multiple task records, but I left that out of my first > illustration to keep it simple. A better sample with three task records of > what I'm getting might be: > > Task1 Eng #1 Task Field 1 Memo > Eng #2 UNWANTED SPACE Memo > Task Field 2 Memo > Task Field 3 > > Task2 Eng #1 Task Field 1 Memo > Task Field 2 Memo > Task Field 3 Memo > > Task3 Eng #2 Task Field 1 Memo > Eng #3 UNWANTED SPACE Memo > Eng #5 UNWANTED SPACE Memo > Task Field 2 > Task Field 3 > > Depending on the number of engineers, fields 2 & 3 are moving down on the > page, creating an unwanted space. The memo field, which is a single field, > expands to the size of the input data, without any blank lines, so it's > displayed nicely. It's just fields 2 & 3 that will move down if there's more > then one engineer (the engineer comes from a separate table, so right now > I've got the engineer as a subform with just the single field in it). > > Thanks for your help. > > > "Duane Hookom" wrote: > > > I am confused by your description. I don't know is you have 3 Task Data > > fields or 3 Task Data records. You mention 3 dates and memo field linked to > > task description but don't provide information on which table or where task > > description is located. > > > > -- > > Duane Hookom > > Microsoft Access MVP > > > > > > "RichKorea" wrote: > > > > > I'm putting together a report for a service database where each service > > > ticket can have multiple call reports, and each call report can have multiple > > > engineers associated with the report. While all the data's getting on to the > > > form, the vertical alignment shifts if there's more then one service engineer. > > > > > > What I would like to have is: > > > Data Eng #1 Task Data 1 Memo > > > Eng #2 Task Data 2 Memo > > > Task Data 3 Memo > > > > > > What I'm getting is: > > > Data Eng #1 Task Data 1 Memo > > > Eng #2 Memo > > > Task Data 2 Memo > > > Task Data 3 > > > > > > The textboxes for Task Data 2 & 3 are shifting down to align with the bottom > > > of the last engineer, but I don't want them to shift. > > > > > > My data's setup as follows: > > > The service ticket data comes from the main table > > > The Task Data fields 1, 2 & 3 come from a task table, which references the > > > service ticket's key. > > > The service engineers come from a table that tracks which engineers worked > > > on which task (can be one or more then one), referencing the task key. > > > > > > My report's setup as follows: > > > The service engineers are in a sub-report that has a field for the > > > engineer's name and is connected to the task key. > > > The tasks are in another sub-report that has the engineer sub-report on the > > > left, linked to the task sub-report's task key, three textboxes stacked > > > vertically for three dates in the middle, and a textbox on the right that's > > > connected to the task description, which is a memo field. > > > The service ticket data's in the top level report, with the task report as a > > > sub-report. > > > > > > Thanks, > > > Rich > > > |