Search found 84 matches
- Mon Jul 20, 2015 2:41 pm
- Forum: Crystal Report Development
- Topic: OpenOrders report question
- Replies: 1
- Views: 941
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...
- Wed Jul 08, 2015 4:48 pm
- Forum: Crystal Report Development
- Topic: 2.6 to 3.0 Data (Endorsement) Conversion issue?
- Replies: 2
- Views: 1060
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...
- Wed Jul 01, 2015 9:33 am
- Forum: Crystal Report Development
- Topic: Enterprise to Cameron Report Conversion
- Replies: 1
- Views: 775
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 ...
- Fri Jun 26, 2015 5:34 pm
- Forum: Crystal Report Development
- Topic: Cameron custom report missing Greoup Tree.
- Replies: 1
- Views: 805
Re: Cameron custom report missing Greoup Tree.
That functionality is no longer available.
- Wed Jun 03, 2015 2:03 pm
- Forum: Crystal Report Development
- Topic: Transaciton History
- Replies: 4
- Views: 1228
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...
- Wed Jun 03, 2015 9:18 am
- Forum: Crystal Report Development
- Topic: Transaciton History
- Replies: 4
- Views: 1228
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 ...
- Mon May 11, 2015 3:08 pm
- Forum: Crystal Report Development
- Topic: Cameron Custom Report using Custom Fields
- Replies: 1
- Views: 691
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 ...
- Thu Apr 30, 2015 12:26 pm
- Forum: Crystal Report Development
- Topic: Cameron Custom Closed Order Report
- Replies: 2
- Views: 828
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...
- 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...
- Fri Mar 06, 2015 12:27 pm
- Forum: Crystal Report Development
- Topic: Phrase Group
- Replies: 4
- Views: 871
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...