Search found 81 matches
- Fri Jun 26, 2015 5:34 pm
- Forum: Crystal Report Development
- Topic: Cameron custom report missing Greoup Tree.
- Replies: 1
- Views: 499
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: 745
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: 745
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: 330
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: 436
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: 595
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: 469
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...
- Thu Mar 05, 2015 5:38 pm
- Forum: Crystal Report Development
- Topic: Phrase Group
- Replies: 4
- Views: 469
Re: Phrase Group
You can get the phrase type by joining from the pfm.Phrase table to the pf.OrderItemType table. pfm.Phrase.Type#=pf.OrderItemType.ID pf.OrderItemType.Name=’DeedEasement’ pf.OrderItemType.Name=’DeedException’ pf.OrderItemType.Name=’DeedRestriction’ pf.OrderItemType.Name=’Instruction' If you need to u...
- Mon Feb 09, 2015 9:22 am
- Forum: Integration Development
- Topic: Order Ledger Notes
- Replies: 3
- Views: 477
Re: Order Ledger Notes
You can join the pt.Ledger table to the core.Notes table on core.Notes.ParentMoniker=pt.Ledger.ID
Code: Select all
SELECT
N.ParentMoniker,
L.Name,
N.Content
FROM core.Notes AS N
INNER JOIN pt.Ledger AS L ON N.ParentMoniker=L.ID
- Fri Feb 06, 2015 5:13 pm
- Forum: Integration Development
- Topic: dbo.AddressCityStateZip vs Address#CityStateZip
- Replies: 3
- Views: 414
Re: dbo.AddressCityStateZip vs Address#CityStateZip
You no longer need to use the dbo.AddressCityStatZip function, you can use the Address#CityStateZip field that concatenates those values for you. All of the Address# fields store the data based on the UseForeignAddress value.