SQL Server Reporting Services is a great tool that comes with SQL Server, and it is the tool I prefer to use when a report is needed. I have built and continue to maintain many such reports, and once the reports are built, they don’t often need updating, unless the database schema changes or the … Read more
I had a need to be able to report on data inside a set of Lotus Notes 7.0 databases, and I wanted to use SQL Server Reporting Services (SSRS) to do this. There is no direct interface between SSRS and Notes, but I found that IBM provided an ODBC connection from Notes using their NotesSQL … Read more
Programmatically setting the connection string for a Crystal Reports ReportDocument will allow you to have the report automatically use the active connection string for the rest of the application (as in previous posts). In this case, the report is created using a method that is triggered by clicking a button on a form. The log … Read more