Operating System

Subreport in a Sub Folder – working in Visual Studio and SSRS

Subreport in a Sub Folder – working in Visual Studio and SSRS

Subreports provide a great way to re-use SSRS content, however the implementation is a bit clumsy: SSRS 2016 doesn’t let you effectively hide reports (only folders) Visual Studio doesn’t let you have folders for SSRS projects (despite an 8 year old connect request with 290 up votes) Folders sort of work in Report Builder, but there’s no version control My design is for a user facing report with embedded parts that the user can’t see. This approach works in both Visual Studio and SSRS, and minimises maintenance. In SSDT, link to the full path of the Subreport This will work in SSRS once the Report is published, and the Subreport is published to ‘/Sales/ReportParts/’, however, we’ve broken the master report in Visual Studio Note the path referred to in the error – it’s ‘your project folder’ + ‘\bin\Debug’ + ‘your subreport path’ + ‘your subreport’. The challenge here is Visual Studio creates this content in \bin\Debug, and looks for it in \bin\Debug\Sales\ReportParts. We could create this path and copy content into it, but this would be a maintenance headache as we have to copy the subreport, data sources, and any shared data sets, and need to re-copy it when any of these change. Enter the Symbolic Link To get around this I’ve created a symbolic link to trick Visual Studio into thinking the content is at this path, when it’s really just a pointer to the live content in ‘\bin\Debug’. Here’s a guide on creating symbolic links in Windows, and here are the steps I ran in a command prompt (as adminsitrator) to create a link to ‘\Sales\ReportParts’:

read more

Event Viewer Filters Part 2

Event Viewer Filters Part 2

Still playing with the Event Viewer, I’ve written a bunch of custom filters that give a great insight into how Cognos is behaving, especially around monthly patching. I’ve saved these queries on my local machine and use them against all our servers by right-clicking on the event viewer root and ‘Connect to another computer’. Cognos Service This query shows activity of the ‘IBM Cognos’ service Server Restarts USER32 events appear to show all restarts against the server Windows Updates (Patches) This event shows me all Patches being applied to the server

read more

Cognos Services Manager

Cognos Services Manager

Here’s a batch file I’ve written over the past few years that automates the starting, stopping, testing and restarting of distributed Cognos services across three environments. This particular script has been anonymised, but is hopefully still in working order. It’s been in use for ~3 years on Windows 2008 R2 Server.

read more