Search found 80 matches

by Lisa Ennis
Wed Feb 17, 2016 11:57 am
Forum: General
Topic: Settlement Agent/SellingAgentBrokers
Replies: 3
Views: 444

Re: Settlement Agent/SellingAgentBrokers

This gets the data based on the contact types. SELECT Name, C.Address#Address1 AS Address1, C.Address#Address2 AS Address2, C.Address#City AS City, C.Address#StateID, zS.Code AS [State], C.Address#Zip, C.LicenseNumber, P.FirstName AS MainPersonFirstName, P.LastName AS MainPersonLastName, P.LicenseNu...
by Lisa Ennis
Tue Nov 03, 2015 5:26 pm
Forum: Crystal Report Development
Topic: TaxAndGovernmentDetailChargeFee
Replies: 3
Views: 583

Re: TaxAndGovernmentDetailChargeFee

Email me directly at lisa.ennis@softprocorp.com and I will get it to you.
by Lisa Ennis
Tue Nov 03, 2015 10:51 am
Forum: Crystal Report Development
Topic: TaxAndGovernmentDetailChargeFee
Replies: 3
Views: 583

Re: TaxAndGovernmentDetailChargeFee

You do not need the join to the pfm.TaxAndGovernmentDetailSection table. The code below is the correct join. SELECT TAGDCF.* FROM pf.[Order] AS O INNER JOIN pfm.[Order] AS ORD ON ORD.RootId# = O.RootID INNER JOIN pfm.CDF AS C ON C.RootId# = ORD.RootId# AND C.Id# BETWEEN ORD.Id# AND ORD.LastId# INNER...
by Lisa Ennis
Thu Sep 24, 2015 5:37 pm
Forum: Crystal Report Development
Topic: Invalid analyzer handle
Replies: 3
Views: 761

Re: Invalid analyzer handle

That specific stored procedure had been troublesome on a customer's site due to how a join was being handled by SQL and rendered unexpected results, causing it to break the document. We split the sub report that was returning both buyers and sellers side by side into separate sub reports. The new su...
by Lisa Ennis
Thu Sep 24, 2015 9:22 am
Forum: Crystal Report Development
Topic: Invalid analyzer handle
Replies: 3
Views: 761

Re: Invalid analyzer handle

The first step I would do in troubleshooting this issue would be to open the report in Crystal Reports and verify the database. This can assist with identifying issues with fields being returned by your query. Also, if your report is using a stored procedure, does the stored procedure execute on the...
by Lisa Ennis
Thu Jul 30, 2015 11:39 am
Forum: Crystal Report Development
Topic: Different Date in Database As Compared to Application
Replies: 1
Views: 440

Re: Different Date in Database As Compared to Application

Any dates in the database that have the time indicated (not 00:00:00.000) are stored as UTC. When you view those dates in the program they are being converted to the time zone of the client machine. You can use the function dbo.ConvertTimeFromUTC in your queries to convert the UTC datetime stored in...
by Lisa Ennis
Mon Jul 20, 2015 2:41 pm
Forum: Crystal Report Development
Topic: OpenOrders report question
Replies: 1
Views: 456

Re: OpenOrders report question

All of the database objects for the canned reports are in the rptdoc schema. Any custom stored procedures would be in the spc schema. The "rptdoc.OrdersByOrderStatus" stored procedure may give you what you need. The "csp_150079_OpenOrder" that you reference is a custom stored procedure. That stored ...
by Lisa Ennis
Wed Jul 08, 2015 4:48 pm
Forum: Crystal Report Development
Topic: 2.6 to 3.0 Data (Endorsement) Conversion issue?
Replies: 2
Views: 558

Re: 2.6 to 3.0 Data (Endorsement) Conversion issue?

I believe the data Colin is looking at data stored in the pt.TitleCharge. Data writes to this table when a transaction is initially posted. If that table does not have what you need, you may need to join back to the Title and Endorsement tables in the pfm schema using the ChargeSource in the pt.Reve...
by Lisa Ennis
Wed Jul 01, 2015 9:33 am
Forum: Crystal Report Development
Topic: Enterprise to Cameron Report Conversion
Replies: 1
Views: 417

Re: Enterprise to Cameron Report Conversion

The codes indicate policy, endorsement, or additional title charges and for which policy they are applicable to. Those specifically are endorsement codes for the different policies. The closest field that you will find to this in Select is in the pfm.TitleProduct table. The Type field in that table ...
by Lisa Ennis
Fri Jun 26, 2015 5:34 pm
Forum: Crystal Report Development
Topic: Cameron custom report missing Greoup Tree.
Replies: 1
Views: 447

Re: Cameron custom report missing Greoup Tree.

That functionality is no longer available.