title: Home.md
date: 2020-11-16 00:00:00+02:00
draft: false

Remove headers in Excel exports to fix column alignment

Reports with headers in Reporting Services works great as long as you are just rendering the reports in HTML. If you would try to export the report to Excel you might stumble into some problems. As long as the header design follows the rest of the design when it comes to columns you could be fine. However, often headers contain very different information and design than the actual content of the report and column alignment might in these cases become a problem.

Using ExecutionLog2 for statistics and monitoring

When developing reports its often nice to be able to see how the reports are doing when deployed into production. The fact that the reports are displaying the correct data is one thing. Are they performing as expected six months later? Do they scale well after the amount of data has increased? Which are the most common reports the users execute? Are there reports no one is using? I wanted to write some simple examples of how to use the internal log to get this kind of information about reports.