The ongoing conversation
An empty attendance list can mean that nobody came or that nobody entered the attendance. A report that displays zero has chosen one of those explanations; it needs a reason. That distinction comes up in the reporting work for the Dayton Hash website. The pilot’s test cases distinguish confirmed empty attendance from unknown rosters and […]
You click Save, the server records your changes, but the response never reaches your browser. The screen can’t confirm the save. Clicking Save again seems reasonable, but that’s awkward if it creates a second copy of what you just saved. In reliability work I did for an existing community application, recovery had to account for […]
In an orienteering mapping project, I wanted to review a GPS track and geotagged photographs against an existing map. No surprise: they didn’t line up neatly. I could move the track, but would the new position mean I had corrected a location, or just changed where I drew it? The mismatch alone couldn’t answer that. […]
I recently had to transform a set of data from typical date & measurement to a more compact date range & measurement format. The data in this case was very static: as the date incremented, the measurement was much more likely to be remain the same than it was to change. So storing the starting […]
I came across a SQL function I was not familiar with: decode. I looked it up and immediately replaced it with a CASE statement (in addition to other code cleanup). I’m afraid I don’t understand the existence of Oracle SQL’s decode() function: decode(expression, search, result [, search , result]… [, default] ) seems functionally equivalent […]
So you have data you’re tracking every day. Maybe a lot of data. Maybe tracking it a lot of ways. You might even have graphs of the data over time, so that you can spot trends and anomalies. And then you find that you’ve got too many graphs… It’s time to let the data tell […]
The short answer: use Globals!ReportFolder in the middle drillthrough reports to fully qualify the target ReportName in any Action. The tech involved in this problem, although probably you know this if you reached this page: SSRS is a database reporting solution for Microsoft SQL Server—you can turn data into graphs! Mobi Reports Pro is an iOS […]