This is an attempt to create a script that will configure an instance of SSRS that has been left at the “installed but not configured” stage by the installer. The script is required to run during the spin-up of a … Continue reading →
Colour Choices for Graphs and Tables Heatmap Colouring for SSRS Sample colours for a range of 10 levels with mid-point roughly yellow. Code for BackgroundColor property of cell: = IIF(Fields!FieldName.Value >= .98, “#63be7b”, IIF(Fields!FieldName.Value >= .95, “#86c87d”, IIF(Fields!FieldName.Value >= .92, … Continue reading →
A tiled, dashboard style data presentation derived from DataZen and presentable from SQL Server Reporting Services (traditional rdl reports are differentiated as “Paginated Reports”). Verdict: it looks very nice, scales to different displays well, and can be presented in a … Continue reading →
Summary A method for providing a selection of pre-set date ranges plus the ability to enter a custom range of dates. Until the SSRS improvements in 2016, this will require Nullable date parameter boxes to be used. (Why could not … Continue reading →
Information about Report subscriptions is held in ReportServer.dbo.Subscriptions table. ExtensionSettings XML Fragment with root node <ParameterValues> Contains information about the format and destination of the report. Each <ParameterValue> element has child <Name> and <Value> nodes : named according to classical … Continue reading →
Display All Values on a Graph’s Axis Set Interval in Axis Options section to 1. Auto is normally too sparse for my liking on date axes. Setting an Interval expression disables auto-settings although the layout will still be adjusted automatically (staggered … Continue reading →
The SSRS Execution Account is a default Windows credential used by SSRS when running a report to access resources (e.g. file shares for image files) or databases for report datasources that do not require credentials and where Integrated Security is specified. … Continue reading →
Hiding Objects for Export CSV Titles and headings (other than column headings) are typically not required in CSV export. Text and column objects can be individually hidden from csv output: set the DataElementOutput property of the object to NoOutput PDF, Excel, etc Show … Continue reading →
Snippets of code to create date-range parameter defaults for SSRS reports. PrecedingWeek The seven days up to and including yesterday. /* Yesterday = Yesterday’s date. SevenDaysAgo = Seven days before today: i.e. a week up to and including yesterday. 12/08/2014 … Continue reading →
Interpreting data in ReportServer database Observations from SSRS 2008 R2 Subscriptions table dbo.Subscriptions. InactiveFlags There’s no way to disable a subscription from SSRS UI though articles suggest setting InactiveFlags to 1 will achieve this. 0 : schedule is active. 8 … Continue reading →