Search found 84 matches
- Wed Oct 26, 2016 2:29 pm
- Forum: Crystal Report Development
- Topic: dbo.ConvertTimeFromUtc not working
- Replies: 9
- Views: 4239
Re: dbo.ConvertTimeFromUtc not working
In your previous post, you had noted that restarting your server corrected the issue. This is likely a setup/environmental issue that is beyond the scope of these forums. Please discuss this with your SoftPro customer support contact.
- Wed Oct 26, 2016 2:24 pm
- Forum: Crystal Report Development
- Topic: Crystal Reports Flavor & Version
- Replies: 2
- Views: 2572
Re: Crystal Reports Flavor & Version
SoftPro develops reports using Crystal Reports Developer version, production version 11.5.8.826.
- Mon Aug 22, 2016 10:48 am
- Forum: Crystal Report Development
- Topic: pfm.Entity Table - XML
- Replies: 1
- Views: 2431
Re: pfm.Entity Table - XML
I would suggest trying an indexed view to see if that may be faster for you. Also, if you can limit the records from the pf.OrderInfo table by some means prior to joining to the pfm.Entity table that could help as well. And join on to the pf.OrderInfo table on the rootId's. Is it an option to use th...
- Tue Aug 09, 2016 2:08 pm
- Forum: Integration Development
- Topic: Disbursing on Issued Policies
- Replies: 5
- Views: 946
Re: Disbursing on Issued Policies
When you deleted the transaction, the records are correct in that you would see the positive amount when it was posted, and then the negative amount when it was deleted. When the transaction is deleted, a new, pending transaction is generated on the ledger. From that point, you have to pick up the n...
- Mon Jun 27, 2016 2:53 pm
- Forum: Crystal Report Development
- Topic: Ordering Requirements the same way as within the file
- Replies: 8
- Views: 4281
Re: Ordering Requirements the same way as within the file
Unfortunately, you need the position field and that is not in the database. Please submit a request through SoftPro's Support Team that the field be added to the database.
- Mon Jun 20, 2016 10:07 am
- Forum: Crystal Report Development
- Topic: Ordering Requirements the same way as within the file
- Replies: 8
- Views: 4281
Re: Ordering Requirements the same way as within the file
The Id# field in the table is an incremented number, so using that as your sort instead of the number may work, or a combination of the two.
- Thu Jun 02, 2016 3:01 pm
- Forum: Integration Development
- Topic: Joins on RequestedTask, SecurityIdentity, and Task table
- Replies: 4
- Views: 820
Re: Joins on RequestedTask, SecurityIdentity, and Task table
To display the information you want, you would need to change your query. Instead of using MAX on the date and grouping by the completed by full name, you would need to do sub queries or temp tables to get the ID of the max task record for each task description for the order . Then you would need to...
Re: CDF Fees
With additional joins, you can get to the information you need. To get contact information, join to the pfm.Contact table using the field names ending with "$". (LEFT JOIN pfm.Contact AS CT ON PE.RootId#=CT.RootId# AND PE. ContactId $=CT.Id#). SELECT * FROM pfm.[Order] AS O INNER JOIN pfm....
- Fri Apr 22, 2016 10:19 am
- Forum: Crystal Report Development
- Topic: dbo.ConvertTimeFromUtc not working
- Replies: 9
- Views: 4239
Re: dbo.ConvertTimeFromUtc not working
Yes, thank you for posting an update. Very much appreciated.
- Wed Apr 20, 2016 9:03 am
- Forum: Crystal Report Development
- Topic: dbo.ConvertTimeFromUtc not working
- Replies: 9
- Views: 4239
Re: dbo.ConvertTimeFromUtc not working
I copied your select query above and it returns '2016-04-19 14:08:04.000' for me. Is it failing in every query, or just specific ones? Double check how your time zone is typed in the query as I believe it is case sensitive.