I’m currently in the process of building out an ODS (Operational Data Store) that will integrate data from multiple systems and make that data available for reporting using Spotfire and other BI tools. Both the ODS DBMS and the first system that will be used as a source for the data in the ODS run … Read more
Update to this post: I have found a bug in the CrystalReportViewer that I address here. In creating a ASP.NET Web Forms site for viewing Crystal Reports, I needed to open multiple dates for the same report to compare values. The previous setup I used would not allow this; only one report could be open … Read more
In adding functionality to an ancient Excel VBA reporting app for an Oracle database, I decided to set up a temporary worksheet to use as a place to store data before copying it to multiple other worksheets rather than copying directly from the recordset multiple times. Basically, this VBA procedure takes an ADODB recordset and … Read more