Search found 84 matches
- Thu May 02, 2019 10:33 am
- Forum: Crystal Report Development
- Topic: How to eliminate blue text and hyperlink from documents?
- Replies: 3
- Views: 3521
Re: How to eliminate blue text and hyperlink from documents?
This is available as a public option in version 4.4.0 and above. This was not a public option in earlier versions.
- Tue Apr 30, 2019 4:40 pm
- Forum: Crystal Report Development
- Topic: How to eliminate blue text and hyperlink from documents?
- Replies: 3
- Views: 3521
Re: How to eliminate blue text and hyperlink from documents?
There is a Boolean property you need to set called RemoveHotspots in the ExportSettings class. This needs to be set to True. If you are on an older version of Select, and the RemoveHotspots property is not on the ExportSettings class, the IRenderer interface has a DisableHotspots Boolean property th...
- Fri Sep 01, 2017 8:19 am
- Forum: Crystal Report Development
- Topic: Crystal Report Ready Document pulling data set from a Stored Procedure
- Replies: 3
- Views: 3136
Re: Crystal Report Ready Document pulling data set from a Stored Procedure
That would be really hard for me to try and troubleshoot what your issue may be. It could be a permissions issue. Make sure you grant permission in your report's stored procedure. Please contact SoftPro Support for assistance with the error message.
- Wed Aug 30, 2017 9:41 am
- Forum: Crystal Report Development
- Topic: Crystal Report Ready Document pulling data set from a Stored Procedure
- Replies: 3
- Views: 3136
Re: Crystal Report Ready Document pulling data set from a Stored Procedure
The Select program will set the database for you when running the report from the program. To do so, this requires connecting to the database using the OLE DB(ADO) database type and SQLOLEDB provider in Crystal. Parameters passed from the program to the report/stored procedure without being prompted...
- Tue Apr 04, 2017 10:29 am
- Forum: Crystal Report Development
- Topic: Payor Code for a Transation
- Replies: 2
- Views: 2722
Re: Payor Code for a Transation
Below are the joins for many of the ProTrust (pt schema) tables. You would need to join to pt.ContactDetail, then to zref.ContactType. Hope this helps! SELECT * FROM pt.[Transaction] AS T INNER JOIN pt.TransactionExtended AS TE ON T.[GUID]=TE.ID INNER JOIN [pt].[TransactionDetail] AS TD ON TD.ID = T...
- Mon Feb 20, 2017 5:44 pm
- Forum: Crystal Report Development
- Topic: split to in additional title charges screen
- Replies: 2
- Views: 2524
Re: split to in additional title charges screen
That data can be found in the pfm.SplitCalculation and pfm.Split tables. Refer to the rptdoc.PolicyRegister stored procedure for examples of how we extract that data for policy register reporting.
- Tue Feb 14, 2017 6:38 pm
- Forum: General
- Topic: CDFDisbursment and CDFReciept relation to CDFLine
- Replies: 1
- Views: 745
Re: CDFDisbursment and CDFReciept relation to CDFLine
Hope these will help. These are the joins for receipts: pfm.CDFReceipt AS R INNER JOIN pfm.CDF AS CDF ON R.RootId#=CDF.RootId# AND R.CDFId$=CDF.Id# LEFT OUTER JOIN pfm.CDFPayor AS PR ON R.RootId#=PR.RootId# AND R.Id#=PR.CDFAmountId$ LEFT OUTER JOIN pfm.CDFLine AS CL ON R.RootId#=CL.RootId# AND PR.Id...
- Tue Feb 14, 2017 11:05 am
- Forum: Crystal Report Development
- Topic: Accessing custom fields in order information screen
- Replies: 1
- Views: 2575
Re: Accessing custom fields in order information screen
The order information screen has lots of business objects (Order, Loan, Property, Contacts), so they may be on a different object than Order. In your custom field manager, double check which object they were added to. Also, you will only see the tags in the XML if there is data actually entered in t...
- Mon Feb 13, 2017 11:45 am
- Forum: Integration Development
- Topic: SQL CDFLines and Disbursment checks
- Replies: 1
- Views: 576
Re: SQL CDFLines and Disbursment checks
I recommend looking at the stored procedures rptdoc.DisbursementSummaryByCDFId, and/or the rptdoc.RevenueFeeDetails. These are good starting places for getting information related to the Disbursements and related CDF lines. These are the stored procedures used for readydoc reports and will show the ...
- Mon Oct 31, 2016 10:56 am
- Forum: Crystal Report Development
- Topic: Ordering Requirements the same way as within the file
- Replies: 8
- Views: 4394
Re: Ordering Requirements the same way as within the file
The Existing Lien position field is not persisted to the database. Please submit a request through SoftPro's Support Team that the field be added to the database.