SoftPro Developer Forum

We have created a custom report for both Fee Ledger Disbursements and Fee Ledger Pending (Have not been Disbursed). The Fee Ledger Disbursements seems to be working. Therefore, I attempted to get what was Pending by removing all of the Fee Ledger Disbursements using Reference Number as it was indica...

Lisa, We did try and go the Number route and then the problem became they could not type in the decimal places in Prompt/Parameter input? For example, if they wanted to type in 500.34, it would not allow the '.' to be typed. I have noticed in other Reports/Forms that String has been used for Currenc...

I even tried to change the Parameter to a String Type and the Default Value is still not showing for Form? I again did put Default in the Description next to the value of 0.00.

We have a Parameter that is Currency Type and want a Default Value to be 0.00. This is not working even if we use the SoftPro method of putting Default in the Description to the right? We have also tried using the Crystal Reports Default Value to no avail.

Please advise.

Thanks,

MJA

From what I can see, it appears this is the table where this information resides although there are some WHERE requirements that need to be added in addition to GROUP requirements used in conjunction with ClearedDate and TransactionDate (ClearedDate is used as TransactionDate if Amount < 0) in order...

Presently, this is the SELECT Statement used to determine whether the Policy Type is Simultaneous, Loan, or Owners: SELECT TOP 1 PT.ID AS PolicyTypeID FROM dbo.[Order] AS O INNER JOIN dbo.Title AS TI ON O.ID = TI.OrderID INNER JOIN dbo.Loan AS LN ON O.ID = LN.OrderID LEFT OUTER JOIN dbo.TitleInsuran...

Where is the value for a particular Order stored in SoftPro Database for the Additional Fee GET amount that would appear on a Letter Recording Instructions printout? Client has created a custom Letter Recording Instructions and would like to add the Additional Fee GET (HudLine 1100 per Client) amoun...

In writing custom Escrow Fee related reports, is there an existing built-in Stored Procedure, View, or Table Valued Function that would include any Seller Credits (Hud Line 410's) or similar types of issues that would affect 1102 or ESC records? Here is a description from TG as to what is happening:...

Lisa, Kurt at TG has tried everything as far as the steps you provided and he still cannot get the image to show in N-288 at the quality level he wants it. I am just doing an Insert -> Picture in Crystal Reports using the various .bmp's he sends to me. Are there any options in Crystal Reports that c...

We have governement and state tax forms that have barcodes in the Crystal Reports image serving as background for each printed page. We are trying to replace the 2011 image for each page with 2012 image yet the barcode is fuzzy when printed for replaced background. Questions: 1. Is it best to try an...