Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.
This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.
Calyx Software Message Board
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



CREDIT SCORE REPORTExpand / Collapse
Author
Message
Posted 3/5/2007 8:08:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 3/5/2007 9:11:49 AM
Posts: 2, Visits: 4
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?

Jennifer
Ada Mortgage
Post #4470
Posted 3/5/2007 8:30:25 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261
If you don't mind post the field ides that you are currently using.  I think it can be done i'll see if i can't make a condition for you.

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.
Post #4473
Posted 3/5/2007 8:32:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 3/5/2007 9:11:49 AM
Posts: 2, Visits: 4
I am using fields 5032, 5034 and 5036.

Thanks for your help!

Jennifer
Ada Mortgage

Post #4474
Posted 3/5/2007 8:43:45 AM


Sepal

Sepal

Group: Moderators
Last Login: Today @ 4:06:35 PM
Posts: 1,183, Visits: 9,261
Thanks.

You can past the following into your reports condition column (any row that has a fieldid)

ADV:[5032] >= 600 OR [5034] >= 600 OR [5036] >= 600

please note the [5032] refers to the Field Name column so if you named it different then the field id you should change this condition to match.

Some day I should probably teach everyone how to do ADV:

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.

Post #4475
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Emmanuel Huna, Bryan Telford, Jason Beck, Mike Thompson, BetaFisch

PermissionsExpand / Collapse

All times are GMT -8:00, Time now is 7:56pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.031. 11 queries. Compression Enabled.
© 2005 Calyx Software. All rights reserved.