Would this even be possible to trap?

Altair Forum User

I am trying to trap the lab sites. Each new set starts with the number 1, however the header cuts the page off to soon, and this list will keep going throwing everything off. Is there a work around for this? will this be possible to trap?

 

 

 

 

Altair Forum User

Hello Vaughn,

 

Define the Page Header template as a six line sample from the PAGE NN numbers. In the Detail template, edit the Lab Sites field in the Advanced tab of the field properties to end on "none of the above". You'll need to make that a memo field, call it SiteBlob, not a character field as otherwise it will exceed the 254 character field length maximum.

 

Now you have one row of data in the table for each User entry, but I guess what you are looking for is to have one for each Lab Site for each User? You'll need to use the Multi-Column Region. In the Detail template, toggle MCR to be active, starting in column 150, column width 1, number of columns 100.

 

In the Table window, define a character calculated field LabSite with the formula Textline(SiteBlob;Column()). Filter out the rows where LabSite=""; and you should have your data.

 

Best wishes,

 

Olly

Altair Forum User

You should be able to set up a detail template and set the trap to capture each line, using a trap similar to capture a number, space, and character for the lab site and name.  Are you looking to copy previous user, user name, access, etc to be associated with following lab sites with no information?  If so, you can edit these fields and select the option to copy previous values.  I will try and upload a picture later to demonstrate what I am referring to.   Hope this gets you headed in the right direction.

Altair Forum User

Altair Forum User said:

Hello Vaughn,

 

Define the Page Header template as a six line sample from the PAGE NN numbers. In the Detail template, edit the Lab Sites field in the Advanced tab of the field properties to end on "none of the above". You'll need to make that a memo field, call it SiteBlob, not a character field as otherwise it will exceed the 254 character field length maximum.

 

Now you have one row of data in the table for each User entry, but I guess what you are looking for is to have one for each Lab Site for each User? You'll need to use the Multi-Column Region. In the Detail template, toggle MCR to be active, starting in column 150, column width 1, number of columns 100.

 

In the Table window, define a character calculated field LabSite with the formula Textline(SiteBlob;Column()). Filter out the rows where LabSite=""; and you should have your data.

 

Best wishes,

 

Olly

First off thank you for your help. I really do appricate the help.I will take a better look at this tomorrow. so anyways the lab sites that are on pages 13 and 14 would all be under one user. 1-64 and then the next user would have 2 and then the next several would have 1 on these pages but it varies.

Altair Forum User

Altair Forum User said:

You should be able to set up a detail template and set the trap to capture each line, using a trap similar to capture a number, space, and character for the lab site and name.  Are you looking to copy previous user, user name, access, etc to be associated with following lab sites with no information?  If so, you can edit these fields and select the option to copy previous values.  I will try and upload a picture later to demonstrate what I am referring to.   Hope this gets you headed in the right direction.

I took the simpler approach here. I did not need MCR or Memo lines. I simply made the site labs my detail line and did an amend on the user, name, description, etc. Finally I did a 6 line header. I was making it a lot harder than it had to be.

 

Thank You!