Transferring Neighborhood to Extra Field

 

Open up the report type to which you wish to add a common response

1)      Click in the cell Neighborhood or Project cell at the top of the report,

2)      Go to Cell at the top of the screen, and select Common Responses.

3)      Click on the Add button, title the response: Copy to Extra and click on OK.

4)      Click in the white text box below. 

a.       For UAR type: cell("offscrn",26,1)=cell("UA2",9,1)

 

b.      For Condo type:           cell("offscrn",26,1)=cell("CN2",7,1)

 

c.       For 2055 DUQ type:    cell("offscrn",26,1)=cell("DUQ",10,1)

5)      When you have typed the text in the white box, select a Hot Key you want to assign the response to and Macro and click on OK.