IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact

Connect New SSRS Server to Old SQL Server with TLS

This was posted just to share an experience of tackling a problem we encountered when we needed to connect an SSRS Server 2016 to an older SQL Server database (Windows Server 2008 R2) and what steps we took to troubleshoot the issue. After all the reports were migrated to the new SSRS server, upon creating a new Data Source, I got an error message something along the line to enter the user id … [Read more...]

January 17, 2022 Filed Under: Use Case Tagged With: Information Security, Microsoft, Microsoft SQL Server, SQL Server, SSRS

SSRS Doesn’t Render Reports in Chrome and Safari

Just earlier today I encountered an issue where SSRS reports that works fine in IE and FireFox were showing blank in Chrome and Safari and interestingly enough the common denominator for these two browsers are that they are based on WebKit. Fortunately this is a known issue and someone already came up with a working solution by adding a javascript snippet in ReportingServices.js file under this … [Read more...]

July 30, 2013 Filed Under: How To Tagged With: SSRS

A Quick Way to Hide TopBar Navigation Link in SSRS

This is just a quick hack to hide the breadcrumb and navigation links in SSRS. Under default installation, locate ReportingServices.css file under the following path: C:\Program Files\Microsoft SQL Server\MSRS10_50\Reporting Services\ReportManager\Styles This path is for SSRS version 2008 R2. If you use a different version of SSRS, then you need to replace the path MSRS10_50 to … [Read more...]

July 29, 2013 Filed Under: How To Tagged With: SSRS

How to Create SSRS Report with Dynamic Query and Multi-Value Parameters

Continuing from the last SSRS tutorial on creating a SQL Server Reporting Services report with dynamic query and parameters, one caveat about the report is that it only works for one record search at a time. While this may be fine for a customer who needs to search a particular record specific to the person, this is not generally useful for office use, where one person may need to search … [Read more...]

July 22, 2013 Filed Under: How To Tagged With: SQL, SSRS

How to Create SSRS Report with Dynamic Query and Parameters

Requirement: Produce an SSRS report the is searchable by the values of any fields in the report as shown below: This type of report can be created using parameters input into a dynamic query in a stored procedure. We'll use employee records from AdventureWorks database to demonstrate the report setup so it can be searchable by a search key and a search string as its value. Create Stored … [Read more...]

June 14, 2013 Filed Under: How To Tagged With: SQL, SSRS

Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Delay Shutdown or Restart on a Mac
  • How to Activate Built-in Web Server
  • SSIS Best Practice with Naming Conventions
  • How to Delay Shutdown or Restart on a Windows Server
  • How to Type Emoji Using Keyboard Shortcuts in Windows and macOS

Recent Posts

  • How to Delay Shutdown or Restart on a Mac
  • How to Activate Built-in Web Server
  • SSIS Best Practice with Naming Conventions
  • How to Delay Shutdown or Restart on a Windows Server
  • How to Type Emoji Using Keyboard Shortcuts in Windows and macOS

Tags

.NET ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack JavaScript Linux macOS Microsoft Microsoft SQL Server MVC PHP PowerShell Python Simple Mail Transfer Protocol Smtp Server SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Web Server Windows Windows 8 Windows 10 Windows 2012 Windows Server

Copyright © 2011-2023 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure