Search found 80 matches

by Lisa Ennis
Wed May 11, 2011 9:36 am
Forum: Crystal Report Development
Topic: Trust Accounts By Profile Detail
Replies: 2
Views: 485

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...
by Lisa Ennis
Wed May 11, 2011 9:07 am
Forum: Crystal Report Development
Topic: Pro Trust Reports and Adding Branch Grouping
Replies: 3
Views: 426

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...
by Lisa Ennis
Mon May 09, 2011 7:52 am
Forum: Crystal Report Development
Topic: Print Preview Versus Printed
Replies: 2
Views: 375

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.
by Lisa Ennis
Wed May 04, 2011 9:35 am
Forum: Crystal Report Development
Topic: Custom Field Issue
Replies: 3
Views: 458

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.
by Lisa Ennis
Tue Apr 26, 2011 10:25 am
Forum: Crystal Report Development
Topic: Parameter Issue (Linked Combo Boxes)
Replies: 1
Views: 322

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...
by Lisa Ennis
Mon Apr 25, 2011 6:50 pm
Forum: ReadyDoc Development
Topic: ContextID
Replies: 2
Views: 419

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 ...
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: 510

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: 510

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...
by Lisa Ennis
Wed Mar 04, 2009 12:29 pm
Forum: Crystal Report Development
Topic: change databases from dev to prod
Replies: 1
Views: 401

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: 662

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