Search found 84 matches

by Lisa Ennis
Mon Jul 20, 2015 2:41 pm
Forum: Crystal Report Development
Topic: OpenOrders report question
Replies: 1
Views: 901

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 pro...
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: 1041

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

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

Re: Cameron custom report missing Greoup Tree.

That functionality is no longer available.
by Lisa Ennis
Wed Jun 03, 2015 2:03 pm
Forum: Crystal Report Development
Topic: Transaciton History
Replies: 4
Views: 1211

Re: Transaciton History

Data for May may be different since you recently upgraded. In 2.6, the revenue data was capture when the transaction was posted in the TransactionHUDLineAndAmount table. Once the transaction was posted, if revisions were made on the HUD, or the transaction was changed that affected the posted transa...
by Lisa Ennis
Wed Jun 03, 2015 9:18 am
Forum: Crystal Report Development
Topic: Transaciton History
Replies: 4
Views: 1211

Re: Transaciton History

Hi Colin, I hope to help but I think I need more information. The IsCurrent flag on the transaction indicates that it is the transaction as it currently sits. All other records for the transaction other than the one with the is current flag are adjustments. You mention Bill Codes. Are you trying to ...
by Lisa Ennis
Mon May 11, 2015 3:08 pm
Forum: Crystal Report Development
Topic: Cameron Custom Report using Custom Fields
Replies: 1
Views: 679

Re: Cameron Custom Report using Custom Fields

There are not views or other tables that will display the custom fields, however you can create them. You do have to use the pfm.Entity table and join to the pf.OrderItemType table to retrieve the custom fields. Below is sample code for retrieving custom fields from the XML. Hope this helps. SELECT ...
by Lisa Ennis
Thu Apr 30, 2015 12:26 pm
Forum: Crystal Report Development
Topic: Cameron Custom Closed Order Report
Replies: 2
Views: 826

Re: Cameron Custom Closed Order Report

Additional join criteria is needed when joining to the pfm.Person table. When joining to tables in an object's heirachy, you will need to use a BETWEEN statement where the Id# is between the Id# and LastId# of the table it inherits from. Hope this helps. SELECT t3.Number, t3.RootID, pfm.Contact.Cont...
by Lisa Ennis
Fri Mar 27, 2015 8:44 am
Forum: Crystal Report Development
Topic: Logon Error when loading report - Cameron
Replies: 2
Views: 937

Re: Logon Error when loading report - Cameron

Most reports have a parameter for the ProfileId in the stored procedure. The Select program does a verify database on the report the first time it is run in the user's session. When that verify happens, it has to be passed a guid for the verify to work correctly. If your stored procedure has the par...
by Lisa Ennis
Fri Mar 06, 2015 12:27 pm
Forum: Crystal Report Development
Topic: Phrase Group
Replies: 4
Views: 867

Re: Phrase Group

The code below should get you what you need. Please let me know if you have any other questions. SELECT P.Code, P.[Text], IG.NameID AS GroupNameID, zPG.Code AS GroupCode, zPG.[Description] AS GroupDescription FROM pfm.Phrase AS P LEFT OUTER JOIN pfm.InstructionGroup AS IG ON p.RootId#=IG.RootId# AND...