Search found 84 matches
- Thu Apr 21, 2011 10:49 am
- Forum: Crystal Report Development
- Topic: Escrow Officers Report - Actual Fee Per Order
- Replies: 4
- Views: 1052
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...
- Tue Apr 19, 2011 9:54 am
- Forum: Crystal Report Development
- Topic: Escrow Officers Report - Actual Fee Per Order
- Replies: 4
- Views: 1052
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....
- Wed Mar 04, 2009 12:29 pm
- Forum: Crystal Report Development
- Topic: change databases from dev to prod
- Replies: 1
- Views: 896
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...
- Fri Oct 03, 2008 2:31 pm
- Forum: Crystal Report Development
- Topic: Welcome to the Crystal Reports Development forum
- Replies: 1
- Views: 3138
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...