Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Closing Counter Web based Report

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

image

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.

Continue reading

Data Collector Mass Update

Today I needed to add 25 fields to Data Collector.  Where as it's totally doable using the correct application, it is the slow way. And since we work on development servers, the same changes need made on the production servers, so the time is duplicated.  There is a quick and safe (mostly safe) way to update ProForm Data Collector, from SQL Server Management Studio

Continue reading

css.php