Search found 7 matches

by brandon.ritchie
Tue Mar 12, 2024 11:35 am
Forum: Crystal Report Development
Topic: Other Contact Types
Replies: 2
Views: 18

Re: Other Contact Types

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
by brandon.ritchie
Wed Feb 28, 2024 7:47 am
Forum: Crystal Report Development
Topic: Buisness Day Calculation
Replies: 2
Views: 23

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...
by brandon.ritchie
Mon Feb 26, 2024 7:40 am
Forum: Crystal Report Development
Topic: Ledger Transfer
Replies: 2
Views: 25

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...
by brandon.ritchie
Wed Apr 06, 2022 1:16 pm
Forum: Crystal Report Development
Topic: Stored Procedure Questions
Replies: 1
Views: 1713

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 &...
by brandon.ritchie
Mon Jun 15, 2020 11:59 am
Forum: ReadyDoc Development
Topic: Web Fonts in HTML Docs
Replies: 1
Views: 896

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...
by brandon.ritchie
Thu Jan 30, 2020 4:11 pm
Forum: Crystal Report Development
Topic: Crystal Report - SQL SP Parameter Dynamic Values
Replies: 1
Views: 3202

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...
by brandon.ritchie
Tue Aug 06, 2019 10:54 am
Forum: ReadyDoc Development
Topic: HTML ReadyDoc loop index
Replies: 1
Views: 1419

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...