↓
 

The Intransigent Data Blog

Getting data to toe the line

The Intransigent Data Blog
The Intransigent Data Blog
  • Home
  • About this Blog
  • Links
  • Toolset
Home→Categories SSRS 1 2 >>

Category Archives: SSRS

Post navigation

← Older posts

Script to Configure SSRS 2017 Reporting Services

The Intransigent Data Blog Posted on 25/11/2018 by Andrew Ing28/12/2018

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 →

Posted in SSRS

Colours

The Intransigent Data Blog Posted on 03/08/2018 by Andrew Ing03/08/2018

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 →

Posted in SSRS

Mobile Reports in SSRS 2016

The Intransigent Data Blog Posted on 10/09/2016 by adminUsr11/09/2016

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 →

Posted in SSRS

SSRS Date Range Parameter

The Intransigent Data Blog Posted on 06/05/2016 by Andrew Ing23/04/2017

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 →

Posted in SSRS

Parse SSRS Subscriptions Table

The Intransigent Data Blog Posted on 26/02/2016 by Andrew Ing26/02/2016

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 →

Posted in SSRS

SSRS tips and techniques

The Intransigent Data Blog Posted on 03/12/2015 by Andrew Ing16/01/2022

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 →

Posted in SSRS | Tagged SSRS

Configure SSRS Datasources to use Execution Account

The Intransigent Data Blog Posted on 29/10/2015 by Andrew Ing29/10/2015

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 →

Posted in SSRS

SSRS Formatting Choices

The Intransigent Data Blog Posted on 14/04/2015 by Andrew Ing05/05/2015

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 →

Posted in SSRS

Report Parameter Defaults (SSRS)

The Intransigent Data Blog Posted on 12/08/2014 by Andrew Ing04/07/2016

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 →

Posted in SSRS, T-SQL

Monitoring SSRS Reports and Subscriptions

The Intransigent Data Blog Posted on 15/07/2014 by Andrew Ing29/12/2015

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 →

Posted in SSRS | Tagged SSRS

Post navigation

← Older posts

Recent Posts

  • Alternatives to the (slow) FORMAT function
  • Disable non-clustered indexes during data load
  • Script the creation of ODBC DSNs
  • DAX: partitioned conditional aggregations
  • Referential integrity checks
  • Understanding errors from Tabular Analysis Services
  • Error flows in Azure Data Factory
  • The effect of RAID cache backup battery failure

Pages

  • About this Blog
  • Links
  • Toolset

Categories

  • ASP.Net
  • Automation
  • Azure Data Factory
  • Data Warehouse
  • DAX
  • DBA
  • IIS
  • MDS
  • MDX
  • Permissions
  • SSAS
  • SSIS
  • SSRS
  • T-SQL
  • Uncategorized
  • VBA

Archives

  • January 2022 (1)
  • June 2021 (1)
  • May 2021 (1)
  • August 2020 (2)
  • June 2020 (1)
  • December 2019 (1)
  • March 2019 (1)
  • February 2019 (1)
  • December 2018 (1)
  • November 2018 (1)
  • August 2018 (1)
  • April 2018 (1)
  • October 2017 (1)
  • April 2017 (1)
  • January 2017 (2)
  • November 2016 (1)
  • September 2016 (1)
  • May 2016 (2)
  • April 2016 (1)
  • March 2016 (1)
  • February 2016 (2)
  • December 2015 (3)
  • October 2015 (1)
  • July 2015 (1)
  • May 2015 (1)
  • April 2015 (2)
  • February 2015 (1)
  • January 2015 (1)
  • December 2014 (1)
  • October 2014 (2)
  • September 2014 (2)
  • August 2014 (2)
  • July 2014 (3)
  • June 2014 (2)
  • May 2014 (2)
  • April 2014 (1)
  • March 2014 (1)
  • January 2014 (1)
  • December 2013 (5)

Tags

Blog Convention SQL-Pattern SSAS SSIS SSRS T-SQL Validation

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2022 - The Intransigent Data Blog - Weaver Xtreme Theme
↑