| | | Junior Member
       
Group: Forum Members Last Login: 5/8/2008 10:41:52 AM Posts: 17, Visits: 91 |
| I'm trying to make a simple report with one of the fields being Subject Property County (Field ID 35). However, when I generate the report, maybe half or more of the entries have a blank field. The other fields populate just fine.
Since the Subject Property County field on the Prospect Information page can be auto-populated, I tried the following:
I chose a file where the county field was empty in the report. I opened the file, clicked on the Zip code field and then tabbed off it, so as to cause the program to auto-populate the county field again (even though it's already populated). I ran the report again, and lo and behold the county field was populated.
Couple questions:
1) Why are some of the county fields populating in the report while others are not?
2) Is there anything that can be done to fill these fields without going into each individual file to "re-auto-populate" them?
Thanks...
(btw, I'm using version 6.0b.) |
| | | | 
Sepal

Group: Moderators Last Login: Today @ 2:47:53 PM Posts: 1,178, Visits: 9,204 |
| What if you just open the Point file and save it? do you see the zipcode in the report? Its possible its not in the file until you open it in Point.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| | | | Junior Member
       
Group: Forum Members Last Login: 5/8/2008 10:41:52 AM Posts: 17, Visits: 91 |
| All the information in all the files is complete (they're closed loan files). The problem is that the report is not pulling the county field for some of them.
That's the thing--I'm trying to avoid having to open several hundred files one by one.
I've attached the report in an Excel file. I've deleted all the columns except for Zip and county. As you can see, the Zip (and everything else for that matter) is present for all entries but the county only populates for some.
|
| | | | Junior Member
       
Group: Forum Members Last Login: 5/8/2008 10:41:52 AM Posts: 17, Visits: 91 |
| Update: I'm finding a similar problem with Field ID 560 - the checkbox for ARM on page 1 of the 1003. If I add it to the report, the "X" doesn't show up for a lot of ARM loans, even though the box is checked in the file.
|
| | | | Junior Member
       
Group: Forum Members Last Login: 2 days ago @ 1:05:39 PM Posts: 23, Visits: 58 |
| | I'm finding a similar issue with a couple of fields actually. It seems any fields that are "additional" supported fields do not work correctly within the report. The work around is to go in and take out your data, paste it back, then hit save and it will finally show up on the report. This is NOT a good solution though when we are running a report of around a hundred loans. Is there anway to get this to sync up automatically? |
| | | | 
Sepal

Group: Moderators Last Login: Today @ 2:47:53 PM Posts: 1,178, Visits: 9,204 |
| Are you using pds?
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| | | | 
Supreme Being

Group: Moderators Last Login: 11/15/2008 10:00:24 PM Posts: 835, Visits: 1,899 |
| What version of Point and PDS do you have?
Have you asked the PDS Administrator to resynchronize all the additional fields in the PDS Admin site?
Bryan
Point Product Manager |
| | | | Junior Member
       
Group: Forum Members Last Login: 2 days ago @ 1:05:39 PM Posts: 23, Visits: 58 |
| | | | | 
Sepal

Group: Moderators Last Login: Today @ 2:47:53 PM Posts: 1,178, Visits: 9,204 |
| Its probable that a forced sync was not done after adding the additional fields to pds. This will leave blanks in the new fields until they are edited in Point. If this is the case you would want to take Bryan's advice a perform a foced file sync over the weekend.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post. |
| | | | |
|