Setting up SQL Auth for Azure SQL DB via SSRS
I am referring the below MSFT doc :
https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-azure-connection-type-ssrs?view=sql-server-ver16
Comparing values in a matrix
Output table
I have the attached table. The data is produced as a matrix. I want to colour code the values under TP1, TP2, TP3 against the Baseline Value but can’t for the life of me work out how to do it. Basically one colour for greater, one for the same and one for less.
SSRS adding number of vertical rows based on specific value and product
Trying to add a number of rows with specific value based on a number value. instead of having users circle the item. I want to have it automatically insert the product going down based on the qty field.
SSRS 2019 Connection Opening Issue
We just moved our SSRS from version 2012 to version 2019 and have been getting complaints of slow report loads. I compared report runs from 2012 and 2019 via ExecutionLog3 and noticed in the Connection Open Times field the 2012 version appeared to open the connection once or twice and then all subsequent calls were listed a 0ms ConnectionOpenTime as if the connection remained open for each call. This report seems to have a lot of calls back to its SQL Server Database. When I compare the same report called on our 2019 SSRS it looks like each ConnectionOpenTime is around 200-400ms each. It has never ran one where the ConnectionOpenTime was 0ms. There are sometimes hundreds of these calls in this report so it starts taking over a few minutes to run.
getting this error in Sql Reportng Services 2019 : Error while loading code module: RtfToHTML, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’
Error while loading code module: RtfToHTML, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’. Details: Could not load file or assembly ‘RtfToHTML, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. The system cannot find the file specified.
exclude values from a sum total when not within parameter selection in SSRS
I have a report that shows each row with a sum broken out by line item. I.E.:
Category & Field & Total Count
Cat A | A | 50
Cat A | B | 100
Cat B | C | 50
Cat B | D | 25
==========================
Cat A Total: 150
Cat B Total: 75
All Total: 225
Microsoft Consulting
Microsoft Consulting Services (MCS) offers professional guidance and implementation support for organizations leveraging Microsoft technologies. Services include cloud migration, data analytics, AI, cybersecurity, modern workplace solutions, business applications, and managed services. With deep expertise in Microsoft products, MCS helps clients achieve their business objectives efficiently and effectively.
SSRS – Subreport could not be shown
I have this error and no idea why it happends :
Error: Subreport could not be shown.