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 →
Can you install tools to export/deploy DacPac files without requiring a Visual Studio installation? Prerequisites. Install following from Microsoft SQL Server 2014 Feature Pack https://www.microsoft.com/en-us/download/details.aspx?id=42295 ENU\x64\SqlDom.msi ENU\x64\SQLSysClrTypes.msi Install Data-Tier Application Framework. (May 2015 version is here: https://www.microsoft.com/en-us/download/details.aspx?id=46898. This took some finding: there was … Continue reading →
Notes from a first brush with MDS. Installation (2102) The ApplicationPool credential should be a member of MDS_Services (?) local user group. (not convinced that setup does this for you). The installation is not complete until you get the chance … 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 →
For measuring short durations, such as telephone calls or handling times. Q1 Linear Grain? The question I haven’t answered is whether the dimension should be at the finest grain for all durations. The grain I am using is seconds but … Continue reading →
Is it worth the effort? Advantages Can encapsulate a set of defaults. Pre-configurations of a very general report, for example. Disadvantages Links between reports take users to the master source folder. (!) Dynamic parameter defaults don’t survive linking. Instead the … 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 →
SSSB Endpoint Authentication Certificate Don’t forget to give this a long lifetime (if security policy allows) by using EXPIRY_DATE, otherwise the certificate expires after a year. CREATE CERTIFICATE [BrokerCertificateDec15] WITH SUBJECT = N’certificate_subject’, EXPIRY_DATE = N’2025-12-31′; Expiry of the certificate … 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 →
Some functions for obfuscating data to protect personally identifiable data. Aims: fast enough to process a large table resulting data is “sufficiently” obfuscated resulting data retains enough characteristics that it makes some sense in context. transformations are repeatable so that … Continue reading →