What do you do when you need to resend items to your underwriter when using the SoftPro ProForm tool eProRemit? Do you create the file manually in Excel? Manual no more, ReProRemit takes a comma delimited list of ProForm Files, resetting the system so eProRemit will pickup the files and create the transmission file for the records you need.
Tag Archives: Reports
Closing Counter Web based Report
Does your Closing Counter look like this?
Here is a screen shot of a Closing Counter report for SoftPro ProForm viewed through a web browser. Normal reports use a Crystal Reports engine and are old time stuff compared to a web page that runs on a local IIS server.
This report tallies Purchases, Refinances and Equity deals over different time frames. The previous Month, the previous week, yesterday, today, tomorrow, the rest of this week and what's coming up next week are the time frames this report uses. Click on the image to see a larger size. Once your site is in place, this report is a few hours time. If you'd like to start saving money by running web based reports, let me know, I'd be happy to help.
SQL convert "yyyyMMdd" integer or string to a Date that works in SoftPro
The last few weeks I've been working with Web based Reporting for SoftPro ProForm. It's been fun creating management review pages with dials and lights.
I've enjoyed combining multiple report outputs on one concise easy to ready web page. Along the way, it's been necessary to display SoftPro Database formatted date fields in a grid. They come through in 20130524 or "yyyyMMdd" format. It was easy enough to format that in a grid as "yyyy-MM-dd" format which worked until I started exporting the grids to Excel, when the formatting failed. So I began a search to fix it, at the SQL level.
ProForm Crystal Report, Print if No Tracking item
Today I needed a digression to give my brain a rest. So I went looking for a decent blog post, and ran across this note, from something I was doing in March 2011. The question that needs answered is how do I print only files that don't have a specific tracking item.
Crystal Reports Space Every 5
Do you remember green bar paper? 5 rows of information would typically be on a white background, then 5 rows on green. When that went away, I missed the alignment for my eye. Being told it was better, I got used to not having it, but I still miss it.
SoftPro ProForm Reports Buttons disappear
A client mentioned that he didn't have any buttons when attempting to print a SoftPro ProForm Enterprise 6.2 report. I've seen those buttons move around before and never much cared at the time. Today it mattered, here's what I found
Crystal Reports, State Letter to State Name
From time to time I need a formula to convert a database stored state letter into a state name. Replace Search.StateLet with your database column. This formula is setup to work with a SoftPro ProForm Report.
