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…
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.
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
ProTrust PTWIN-130 Error window
Today’s fun call of the day was related to ProTrust having a Ledger locked for editing. The Error (PTWIN-130) is displayed when someone attempts to add a transaction to the ledger. No one knew who or why, but it’s been like that for days. There’s a right way and a wrong way to fix this particular problem. We’ll talk about the wrong way first.
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.
SoftPro Conference 2013
The 2013 SoftPro Conference just ended. This year attendance showed the return trend to the levels that we’re accustom to seeing is moving along nicely. The general sessions filled a large room near it’s capacity. There were the usual Select and Classic courses tracks, with what I thought was a pretty even attendance to both tracks.
SoftPro ProForm Standard MDB to SQL upgrade
There are things that need checked after converting a database from Access to SQL with SoftPro Standard. I’ve been through a couple of these, there are things to watch out for. Once the data is converted and with each database showing no unfixed issued during the conversion process, there are some additional items that need done, or checked.