Calyx Software Message Board / Calyx Point / Reports

PointReport.exe - Error

malatex — Thu, 31 Jul 2008 00:49:40 GMT

I have Point 6.0b Build 888.68 installed on a Terminal Server. When my users try to run reports they get the following error:

PointReport.exe - Common Language Runtime Debugging Service
Application has generated an exception that could not be handled
Process id=0x1954 (6484), Thread id=0x1da8 (7592)
Click OK to terminate the application.
Click CANCEL to debug the application.

I have my Winpoint.ini file configured like this in their home directory:
Application=H:\WINPOINT
Templates=C:\PNTTEMPL
User=H:\WINPOINT\user
work=H:\winpoint\work

If I change the Applicatoin line like this: Application=C:\WINPOINT the report will work just fine. This isn't a workable solution for me however because when my users pull credit they use different information (stored in the H:\WINPOINT\EMDBInterface folder).

When I try to open the file C:\WINPOINT\PointReport.exe it will open. But when I try to open it from my home directory H:\WINPOINT\PointReport.exe I get the same error as above.

It looks like the PointReport.exe will not run from any other location than its default folder. Anyone have any ideas?

CCS Reports

keystone — Thu, 26 Jun 2008 12:35:08 GMT

Is there a way to pull a report on all our CCS files? We currently have 123 CCS files setup. Through out the year we do an audit on the fees in these files and compare them against three different systems. Is their a way that I can export a report from Point that will list all my files with their fees?

My current way to do it is such a pain and doesn't work well.

I change the name of my Prospoect folder to _Prospect to preserve my prospect files.

I then make a copy of my CCS folder and name the copy Prospect which I place in the PNTDATA folder

I refresh list and use a custom report which I created to pull the report.

The sheet that is generated is to big to export to a XLS sheet so I export to TXT and then break it up with tab deleimitations and import on to two different XLS sheets.

It works, but its a bad work around.

Any ideas?

Field 1247 Arm Index Type Code

jsimms — Mon, 14 Jul 2008 14:24:50 GMT

Hi - does anyone know where Field Code 1247 (the Arm Index Type Code) is generated from? I've looked through all of the screens and am coming up empty. I see a numerical field when I export the data, but don't know where it is coming from. Can anyone help?

Thanks in advance,

J

Pointreport.exe Causing Error Since 6.1A

todrescher — Wed, 02 Jul 2008 13:22:05 GMT

This is the event that appears in the application log. This has only happened since upgrading from 6.0 to 6.1A

Any ideas?

Event Type:Error
Event Source:.NET Runtime 2.0 Error Reporting
Event Category:None
Event ID:1000
Date:7/2/2008
Time:1:13:12 PM
User:N/A
Computer: (deleted)
Description:
Faulting application pointreport.exe, version 6.1.971.422, stamp 480e3d81, faulting module kernel32.dll, version 5.2.3790.4062, stamp 46264680, debug? 0, fault address 0x0000bee7.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 00 70 00 70 00 6c 00 A.p.p.l.
0008: 69 00 63 00 61 00 74 00 i.c.a.t.
0010: 69 00 6f 00 6e 00 20 00 i.o.n. .
0018: 46 00 61 00 69 00 6c 00 F.a.i.l.
0020: 75 00 72 00 65 00 20 00 u.r.e. .
0028: 20 00 70 00 6f 00 69 00 .p.o.i.
0030: 6e 00 74 00 72 00 65 00 n.t.r.e.
0038: 70 00 6f 00 72 00 74 00 p.o.r.t.
0040: 2e 00 65 00 78 00 65 00 ..e.x.e.
0048: 20 00 36 00 2e 00 31 00 .6...1.
0050: 2e 00 39 00 37 00 31 00 ..9.7.1.
0058: 2e 00 34 00 32 00 32 00 ..4.2.2.
0060: 20 00 34 00 38 00 30 00 .4.8.0.
0068: 65 00 33 00 64 00 38 00 e.3.d.8.
0070: 31 00 20 00 69 00 6e 00 1. .i.n.
0078: 20 00 6b 00 65 00 72 00 .k.e.r.
0080: 6e 00 65 00 6c 00 33 00 n.e.l.3.
0088: 32 00 2e 00 64 00 6c 00 2...d.l.
0090: 6c 00 20 00 35 00 2e 00 l. .5...
0098: 32 00 2e 00 33 00 37 00 2...3.7.
00a0: 39 00 30 00 2e 00 34 00 9.0...4.
00a8: 30 00 36 00 32 00 20 00 0.6.2. .
00b0: 34 00 36 00 32 00 36 00 4.6.2.6.
00b8: 34 00 36 00 38 00 30 00 4.6.8.0.
00c0: 20 00 66 00 44 00 65 00 .f.D.e.
00c8: 62 00 75 00 67 00 20 00 b.u.g. .
00d0: 30 00 20 00 61 00 74 00 0. .a.t.
00d8: 20 00 6f 00 66 00 66 00 .o.f.f.
00e0: 73 00 65 00 74 00 20 00 s.e.t. .
00e8: 30 00 30 00 30 00 30 00 0.0.0.0.
00f0: 62 00 65 00 65 00 37 00 b.e.e.7.
00f8: 0d 00 0a 00 ....

Pulling reports based on Information Bar

ChrisSauerwein — Wed, 02 Jul 2008 09:35:46 GMT

I am interested in running reports based on information on the Information Bar. Specifically, the Last Updated and Last User fields. I can't seem to get a field ID for either of these.

Please help.

Data problem - intermittently populating in report output

FOBL14 — Thu, 08 May 2008 07:02:39 GMT

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.)

credit score report

dburk — Sat, 23 Feb 2008 08:14:46 GMT

Where are the fields for the credit scores? I know the numbers such as 5032 but my reports are blank for this field. Do we need to manually complete those fields and if so where are they in Point?

Crystal Reports on Point 6.0b

Hula — Tue, 25 Mar 2008 12:16:07 GMT

We have just converted over to Point 6.0b, and all my reports that used the SQL field MACRO_f30000 have suddenly stopped working. Under investigation, it appears that this field no longer exists.:w00t:

Since this macro identified the file Status, I assume it is linked to the changes in Reports section within Point.

Is there an alternate field that has the file status?

Custom Reports Can not be Saved if Changed

jack5083 — Wed, 12 Mar 2008 11:28:36 GMT

Is there anyway I can create a report that I can change and save. Everytime I want to change a report and save that report if have to create a new name for that report. This has been happening in all the versions of point I have used (currently using 6.0). The boxes are check to allow editing and allow saving but my disc icon is grayed out. Any help would be greatly appreciated

Calyx 6 Reports

bekki — Fri, 10 Aug 2007 09:43:33 GMT

I run a report several times a month using the option of "est. close", the new Calyx 6 does not allow me to pick that as an option, its either opened, submitted, ect...I have tried to condition the report internally but that doesn't seem to help with pulling files that are closing during a specific time. I need some help! i use this report ALOT and i'm not sure what to do?? Any suggestions would be GREAT!

APR Field Calculation

mnappraisals — Wed, 05 Mar 2008 12:49:32 GMT

The apr field on the TIL form shows the note rate APR. How do I get it to display the correct APR (all fee, interest, etc.)

Thanks

Reports Point 6.0

jack5083 — Wed, 27 Feb 2008 06:34:13 GMT

Several Years ago I created a custom report for my GA loans indicating closed loans for a specific period. Now when I try to pull the report and check the box for closed loans I get no data. The only reason I can think that it will not pull closed loan data is because the date in the sold loan box is after the closed loan date. However the data I need to capture is the number of loans that were closed during a specific period not loans that were sold. Any Help would be greatly appreciated.

Credit Score Report

HeatherW — Thu, 26 Apr 2007 10:49:33 GMT

I am trying to pull a Credit score report on closed loans. I have the correct field ID's and I have went into each file to make sure the information is there but nothing is pulling. Has anyone else had this problem?

Do I have Equal Rights to the home as a live in Co-borrower

dj — Mon, 18 Feb 2008 11:37:28 GMT

I am not married to the Borrower of our home and there is no marriage plan for the future I would like to know my rights as a Co-borrower,and how do we resolve this issue, things are getting pretty bad. Help I need answers court date soon. :angry:

Field List

jbruett — Tue, 14 Aug 2007 09:20:22 GMT

Hey all, is there a field list for custom reporting? Somthing that will list all of the default fields in point and what forms they are on, so that I don't have to sift through the "Display Fields".

What is the PMI field ID?

b1a54 — Fri, 18 Jan 2008 07:49:36 GMT

I'm trying to run a 1098 report. However, I need the PMI field ID. Can someone please help me? Thank you.

Need list of Custom Forms

keystone — Thu, 27 Dec 2007 07:35:05 GMT

What I need is an excel sheet listing all of our Custom Forms, we have over 300. Is there a way I can generate this list from Point?

Thank you,
Eric Lilly

Reports - Version 6.0b

JWean — Mon, 03 Dec 2007 10:21:39 GMT

Issue with Reports

We are using Calyx Version 6.0b

The custom reports that we have created do not show any of the Field Names, so you cannot change any of the conditions; however, the Calyx Reports that come pre-built you can see the field names, and thus change the Conditions.

Is there a fix? Do you have to re-create the entire report every time you want to run it so you can modify one condition?

Thanks for your help.

Report that we created:

Report created by Calyx:

Unsuported Fields When Running Custom Reports

heather — Fri, 13 Apr 2007 13:32:19 GMT

I am trying to run a custom report for our loan log, and some of the fields that I try to draw information from is returned to me with an error message that reads "Warning: one or more requested fields are not currently supported by the Point Data Server (PDS)" and then it lists the fields. How can I fix this so that I can have the fields required to complete my loan log.

Heather

Data field with a checkmark in a report

Gigi@OMC — Tue, 30 Oct 2007 13:45:36 GMT

Is there a way to put a conditon in a report as to whether a data field has a checkmark, such as the self-employed (141) data field?

Post Closing letter

rglorios — Fri, 19 Oct 2007 09:08:29 GMT

Missing the sample post closing letter used with the Marketing function. Anyone know how to find or reinstall them

Editing Reports

Tami — Mon, 23 Jul 2007 09:17:32 GMT

As an administrator, I do not give my Loan Officers access to the secured areas because this enables them to change the masters.

However it seems that reports are also part of the secured area so the Loan Officers can’t edit the conditions in a report to do things like a rate watch.

Can this be changed?

Pulling reports by Funded date in 6.0

ChrisSauerwein — Thu, 23 Aug 2007 11:03:59 GMT

I just spent about 45 minutes on the phone with tech support regarding this issue, but I was curious if anyone else is having difficulty generating reports in 6.0 using the Funded date as the key generator?

I have literally TONS of reports that I generate based on the funded date and when I do this in 6.0, I get nothing. No returned data. If I pull it based on other fields (Closed, Opened, etc.) I get data, but nothing with Funded.

Unfortunately, Funded is probably my number one most important field for 95% of the reporting that I do. Has anyone else had this problem and figured out a fix for it? Tech support and I did everything under the sun to get it to work and nothing.

Field 6022 (Loan Status) Codes

c_king@acerefi.com — Tue, 18 Sep 2007 07:29:36 GMT

I have set up a table in my SQL database and purchased software that will convert my Point files to SQL for me. However, field 6022 which is supposed to be loan status, has codes that don't appear to always mean the same thing.

Does anyone have a list of the values for this field and their meaning?

Thanks,

Clayton :w00t:

Why, Oh Why??? Where is my Active files only box??

ChrisSauerwein — Thu, 23 Aug 2007 10:59:19 GMT

It seems that in 6.0, the "active files only" box on the Reports tab has been removed (although the reference to it is still in the help data).

While the rep at the 800 number gave me a nice work around (de-select Closed, Cancelled, and Denied), I am having a difficult time determining why 1 check box would be removed and 3 check boxes be used as the intended replacement. Was this intended? or an accidental deletion?

I have a 2nd issue that I'll use a new post for as it is totally different. This post was more of a venting on making things more difficult than easier to use.

Error Line 22 Position 3

Dan G — Thu, 05 Jul 2007 12:54:18 GMT

That's all the more information I got when trying to run a new credit report. I contacted CBC Innovis (the agency I pull from) and they said the report ordered fine. They gave me the ID number and I tried to reissue and still got the same error.

What does the error mean?

Accessing Non-Married Co-Borrower Information

tobin — Thu, 29 Sep 2005 08:24:41 GMT

I am trying to run a report for birthdays. It shows all borrowers and co-borrowers as long as they are in the same screen (married). I have several co-borrowers that are non-married and are in the system under the co-borrower1 file from the borrower/co-borrower menu. How do I get these co-borrowers to show up in my report?

Any help would be greatly appreciated. Thank you in advance.

;)

Reports not pulling the most accurate data

jesse — Thu, 24 May 2007 03:54:05 GMT

I'm wondering if anyone else has experienced this. It happened when we used 5.3 and it continues to happen using 5.4.

I run a report. I cross reference the data with our accounting software. I adjust data within point such as correct loan amount. I re-run the report. The data I just corrected still comes over incorrectly. Funny thing is that sometimes the data will pull the old loan amt and sometimes it will display some off the wall amt like $63 (for a loan amt). I go back into the point file because naturally I think that I haven't saved and exited properly. when i go back into the point file the data is how i changed it.

Any ideas?

Merging Liabilities with 2 Seperate Reports?

Dan G — Fri, 11 May 2007 14:21:10 GMT

I'm trying to process a loan in a very interesting way...

I have 2 borrowers, Jack and Kim, both married. I need to run their credit reports seperately, although I can't use Multi-Individual files in Calyx. So, I figured to use the "Bor/Co-Bor" option and place Kim's information seperately to get the seperate report without overwriting Jack's info.

However, I need a way to be able to merge all their information to process the loan as if they were originally a Joint report. (Basically, have all of Kim's information populate onto the same liability page as Jack's.)

Is there any way to go about doing this or would another method be more reasonable?

I'm using Calyx Point 5.3 and my credit provider is CBC Innovis.

Median Credit Score

HelpMe! — Fri, 23 Mar 2007 13:49:51 GMT

Is it possible for a Report to show Only the Median Credit Score for the Buyer and CO Buyer so that we only have 2 fields vs 6 on our report?

Automated Reports

mmccaugh — Tue, 27 Mar 2007 12:17:06 GMT

I am looking for a way to automate running reports in Point, I saw a post from 2005 where it looked pretty complicated, but I am curious if anything has changed? I have a set of reports that I run daily and export to excel, but if there is a way to simply have them run automatically this would be fantastic.

Disabling Ordering Credit Reports Unless Credit Card is Checked

Dan G — Fri, 20 Apr 2007 11:57:16 GMT

Is this possible? I want to have it set up so the Loan Officers are responseable for their own payment (they operate seperately from the company, however, they are still under the name of the company). Is there a way to change the option in Calyx (see screenshot) so that way it will not let the LO order a credit report without having the "Pay By Credit Card" checked?

Currently, the setup is that all of their logins are associated and billed to the company directly.

Report fields with multiple dates

PSchrader — Fri, 23 Mar 2007 12:43:54 GMT

I am trying to create a report with multiple fields; Closed; Denied and Cancelled all from a specific date or date range (example- Greater than or equal to 3/16/07). I am using the Condition Builder to specify the dates and all the dates are the same for each field. When I generate the report, all fields are blank.

I can run each report (closed; denied; cancelled) separately and they run fine. It's like a loop has somehow been created with the dates.

This is probably a really brainless question and I am sure that there is a very easy fix, but I cannot find it and it is driving me crazy.

Any help would be appreciated.

Point 5.3 Not Completing Order Request

Dan G — Thu, 12 Apr 2007 12:11:29 GMT

As of today, any credit reports I try to order in Calyx Point 5.3 do not completely process. On the "Credit Report Retrieval" part where the progress bar shows, it continues to go until it's just about done... maybe about 90-95% complete, and then it just stops. I've left it set for awhile as I went off to do other things, come back, and it didn't move at all.

I contacted CBC Innovis (my provider), and they have specific settings for Calyx Point to operate effectively. They too said they've been getting many calls about people unable to order through Calyx all of a sudden.

I have checked things like my virus scanner and firewall, both of which I disabled for the time being. I verified my network connections and my login info as I logged into and ordered a test file through CBC Innovis' website.

Any ideas?

Reports - Exclude Null Records & Set Column Conditions

tholroyd — Thu, 12 Apr 2007 09:43:19 GMT

1) I'm generating a custom report in the current version. I would like to make it part of the report conditions that it excludes records containing null values for a specified (key) field.
2) I also want to have have information for certain columns pulled from more than one field. For example: consider a listing of Borrower Names. I'd like to have Co Borrower names within the file populate a separate record in the same column, so a complete list of names including Borrower and CoBorrower can be accessed. What I am currently doing is using two reports which gather the separate information, exporting both, editing out CoBorrower nulls manually, and then manually combining the two exported files.
If you have any ideas, I'd appreciate it. Thanks!

Problems pulling credit

dnsadmin — Tue, 03 Apr 2007 11:23:29 GMT

Error message:

The transaction could not be registered with Calyx for some reason.

here are some possible causes:

Your network connection is no longer available.

Your DNS server cannot resolve HTTPS calls on port 443

Your firewall has blocked outgoing HTTPS calls on port 443

I can get to my webmail site which is https

All outgoing traffic http and https is allowed on our network firewall.

Any ideas on what is causing this?

"System Error" in version 5.3b

Dan G — Wed, 28 Mar 2007 11:37:41 GMT

While running a credit report, I get a message that simply states "System Error, please try your request again later". I tried again later, and still the same error.

I go through the Borrower screen and input all the borrower's main information, then select "Sevices" > "Credit Reports" > "Request Credit". I verify the information, have "Order New Report" selected, hit "Submit", input my information, and submit that. Almost instantly I get the error, and there's no additional details besides what's stated above.

Any ideas?

Obtaining Multi-Individual / Multi-Borrower Reports

Dan G — Thu, 08 Mar 2007 12:01:27 GMT

In the past (back in version 4.2 days), I have been able to order credit reports through a vendor and obtain a Multi-Individual / Multi-Borrower report, not a Joint report. I use the Multi- reports when the borrowers are not married or related, but rather, just co-signing on a loan. Recently, though, whenever I input the information in Calyx Point 4.2 or 5.3, even if I select "unmarried" on the Credit Request screen, I get a Joint report back.

At first I thought it was the vendor doing this to my reports, but when I run the exact same report through any of their software, I am able to get a Multi- report back no problem, plus, I used to be able to do this on an older version of Calyx Point.

I assume that it was due to all the updates that were made for Point recently, but is there any way to go about getting a Multi- report in Calyx? If not, will that feature return sometime?

Paid Off Check Box Not Showing On Report

PTerrell — Wed, 14 Mar 2007 14:00:38 GMT

I contructed a report that has all the fields for liabilities. (I know that's a mess of fields: my goal is to create a normalized database of all the past liabilities for every client we've had.)

When I run the report, all the fields with the paid off check boxes are returning as blank. The report window shows the fields as empty and when I import the CSV into Access, all fields are null.

The board is full of tips on reports with pay offs. So what is going on with my report...

CREDIT SCORE REPORT

jjohnson — Mon, 05 Mar 2007 08:08:41 GMT

I am trying to run a report for closed loans that have credit scores greater than 600. I input the field id's for all three credit agencies and then run the report. The report generates, but not like I want. It only pulls the files that have all three of the credit scores filled in. How do I get all files to pull up whether I pulled a single, dual or tri-merged report?