Search found 84 matches

by Lisa Ennis
Thu Apr 21, 2011 10:49 am
Forum: Crystal Report Development
Topic: Escrow Officers Report - Actual Fee Per Order
Replies: 4
Views: 1047

Re: Escrow Officers Report - Actual Fee Per Order

There are a couple of different ways to get only one record per order. You could do the following: SELECT O.ID AS OrderID, O.ReceivedDate, ---All other fields that you want that return only one record per order ESC.DateEscrowFeesFirstPaid, ISNULL(ESC.EscrowFees,0) AS EscrowFees FROM dbo.[Order] AS O...
by Lisa Ennis
Tue Apr 19, 2011 9:54 am
Forum: Crystal Report Development
Topic: Escrow Officers Report - Actual Fee Per Order
Replies: 4
Views: 1047

Re: Escrow Officers Report - Actual Fee Per Order

The dbo.TransactionHudLineAndAmountFull view has the information that you need. Most of our customers count their revenue when fees to a revenue order contact are disbursed. A revenue order contact is an order contact that the "Include on revenue reports" flag is checked (dbo.OrderContact....
by Lisa Ennis
Wed Mar 04, 2009 12:29 pm
Forum: Crystal Report Development
Topic: change databases from dev to prod
Replies: 1
Views: 895

Re: change databases from dev to prod

If you are not currently connected to the new database, open a report and then select Database, Database Expert. Create a new connection using OLE DB(ADO). Once you are connected to the database, right click the connection and add it to your favorites, it will make it easier to change multiple repor...
by Lisa Ennis
Fri Oct 03, 2008 2:31 pm
Forum: Crystal Report Development
Topic: Welcome to the Crystal Reports Development forum
Replies: 1
Views: 3068

Welcome to the Crystal Reports Development forum

Just wanted to say hello to everyone and welcome you to the Crystal Reports Development forum. We hope to see SoftPro Select users post questions and answers related to the functionality of the standard report and readydoc reports that are distributed with the program, and your custom development qu...