Search found 81 matches
- Tue May 24, 2011 11:22 am
- Forum: Crystal Report Development
- Topic: Anticipated Incoming Wire Report
- Replies: 2
- Views: 347
Re: Anticipated Incoming Wire Report
The transaction type has to be "Incoming Wire". If the user has worked up an order, then the expected incoming funds will be generated as a receipt. The user has to go to the register tab and change the transaction type to "Incoming Wire", and the status has to be pending. If a user is not seeing a ...
- Wed May 11, 2011 9:36 am
- Forum: Crystal Report Development
- Topic: Trust Accounts By Profile Detail
- Replies: 2
- Views: 541
Re: Trust Accounts By Profile Detail
You are correct in going back to the Order table to get the owning profile id (see my reply to your previous post on this topic). All of our standard reports are written by trust account, specifically for reconciliation purposes. To change those reports to be able to run those for multiple trust acc...
- Wed May 11, 2011 9:07 am
- Forum: Crystal Report Development
- Topic: Pro Trust Reports and Adding Branch Grouping
- Replies: 3
- Views: 458
Re: Pro Trust Reports and Adding Branch Grouping
We do not have documentation regarding the database objects used in the ProTrust reports. SoftPro provides two different sets of standard reports, one by trust accounting date, the other by transaction date. By trust accounting date you are using the actual timestamp of the transaction and any adjus...
- Mon May 09, 2011 7:52 am
- Forum: Crystal Report Development
- Topic: Print Preview Versus Printed
- Replies: 2
- Views: 401
Re: Print Preview Versus Printed
Try inserting another detail section in your report, make it narror and move the line into the new section with it set to move to the bottom of the section when printing. You can also set the width of the line to be hairline, then it may be narrow enough that the underscore text would be more visible.
- Wed May 04, 2011 9:35 am
- Forum: Crystal Report Development
- Topic: Custom Field Issue
- Replies: 3
- Views: 496
Re: Custom Field Issue
Michael, can you post your view.
When you add the view to your report, are you changing the join to be a left outer join?
I have experienced linking issues when trying to join a view to a stored procedure, but have not had any issues with linking a view to a view.
When you add the view to your report, are you changing the join to be a left outer join?
I have experienced linking issues when trying to join a view to a stored procedure, but have not had any issues with linking a view to a view.
- Tue Apr 26, 2011 10:25 am
- Forum: Crystal Report Development
- Topic: Parameter Issue (Linked Combo Boxes)
- Replies: 1
- Views: 339
Re: Parameter Issue (Linked Combo Boxes)
When we initially started developing reports, we needed a way to set the parameter order. At some point, the order that you set the parameters in Crystal works , and we no longer user that. Use Crystal to set your order of the parameters. There is a standard report, "Current Queue" (SPMGT_CurrentQue...
- Mon Apr 25, 2011 6:50 pm
- Forum: ReadyDoc Development
- Topic: ContextID
- Replies: 2
- Views: 444
Re: ContextID
There are several parameters that are passed from our program to the Crystal Report that are coded from our program to not display the parameter when it is rendered. ContextID and UserID are two of those parameters. I believe you can accomplish what you are wanting to in your custom readydoc report ...
- Thu Apr 21, 2011 10:49 am
- Forum: Crystal Report Development
- Topic: Escrow Officers Report - Actual Fee Per Order
- Replies: 4
- Views: 545
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: 545
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.IncludeOnR...
- Wed Mar 04, 2009 12:29 pm
- Forum: Crystal Report Development
- Topic: change databases from dev to prod
- Replies: 1
- Views: 443
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...