The pfm.Contact table has a field "OtherType" which has this value for other contact types (ContactType=16).
SELECT OtherType, [Name] FROM pfm.Contact WHERE ContactType = 16
Search found 7 matches
- Tue Mar 12, 2024 11:35 am
- Forum: Crystal Report Development
- Topic: Other Contact Types
- Replies: 2
- Views: 2038
- Wed Feb 28, 2024 7:47 am
- Forum: Crystal Report Development
- Topic: Buisness Day Calculation
- Replies: 2
- Views: 1142
Re: Buisness Day Calculation
There are 3 business days functions with the default bundle that might help get what you need. rptdoc.BusinessDaysInDateRange rptdoc.BusinessDaysInDateRangeByDateManagerID rptdoc.BusinessDaysInDateRangeNoTimeDateManagerID Some of these were added recently so if they are unavailable in the SelectDb y...
- Mon Feb 26, 2024 7:40 am
- Forum: Crystal Report Development
- Topic: Ledger Transfer
- Replies: 2
- Views: 1069
Re: Ledger Transfer
The ledger transfers To/From (FTO / FTI) are linked by the related transaction ID. For the current transaction you can find the related transaction ID in the pt.TransactionExtened table (RelatedTransactionID). This will join back to the corresponding transaction/ledger to get the other side of the t...
- Wed Apr 06, 2022 1:16 pm
- Forum: Crystal Report Development
- Topic: Stored Procedure Questions
- Replies: 1
- Views: 2909
Re: Stored Procedure Questions
The best option is to create a new version of this stored procedure to add the new column and point your report to the new version. Due to installing any bundle update for custom reports would overwrite/revert any changes you make. To add the IsCommercial column, the easiest way would be to add an &...
- Mon Jun 15, 2020 11:59 am
- Forum: ReadyDoc Development
- Topic: Web Fonts in HTML Docs
- Replies: 1
- Views: 1252
Re: Web Fonts in HTML Docs
You can add the font as a resource and include the css for it. See example below. example: In this example I used the Google "MetalMania-Regular.ttf" font as it was not loaded on my computer. 1) add the font file (ttf) as a resource in the spdoc. (FontAddedAsResource.jpg) FontAddedAsResour...
- Thu Jan 30, 2020 4:11 pm
- Forum: Crystal Report Development
- Topic: Crystal Report - SQL SP Parameter Dynamic Values
- Replies: 1
- Views: 4569
Re: Crystal Report - SQL SP Parameter Dynamic Values
Yes, you can use PARAMETER_VALUES to populate a combo list from a stored procedure parameter. It needs to be string/varchar but it works the same way as if it was a crystal parameter. Make sure to include the @ in the name in the parm. values parameter. They need to be the exact name as shown in the...
- Tue Aug 06, 2019 10:54 am
- Forum: ReadyDoc Development
- Topic: HTML ReadyDoc loop index
- Replies: 1
- Views: 1780
Re: HTML ReadyDoc loop index
{{# .Buyers.Count}} will give you how many buyers are on an order. Also for buyer or any contacts you can use the {{.Code}} to know which one it is. For buyers the 1st code is B, then B2, B3 and so one. It would depend on what you are trying to do with this index to know if you need to track that in...