IT Nota

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

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

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • WordPress
  • Writing

Recent Posts

  • F#: Seq, List, Array, Map, Set. Which One to Use?
  • How to Get Table Definition in SQL Server
  • Why You Need to Use a VPN
  • How to Use Custom Color in SSMS Using Redgate SQL Prompt
  • How to Install Python on Windows Server
Web Hosting

Recent Posts

  • F#: Seq, List, Array, Map, Set. Which One to Use?
  • How to Get Table Definition in SQL Server
  • Why You Need to Use a VPN
  • How to Use Custom Color in SSMS Using Redgate SQL Prompt
  • How to Install Python on Windows Server
  • RSS

Tags

.NET Core Access Adobe AdSense Amazon ASP.NET Cdonts Dll Classic ASP Code Editor Connect-It Copywriting ETL FSharp Genesis Framework Git Google HP Asset Manager HTML HTML5 Hugo IIS Information Security Internet Internet Information Services iOS Linux macOS Microsoft Microsoft SQL Server MVC PHP Simple Mail Transfer Protocol Smtp Server Social Media SQL SQL Server SSIS SSMS SSRS VPN Windows Windows 8 Windows 10 Windows 2012 Windows Server

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