Hi all,
I used this script couple of years ago to do bulk upload, but now in 2026 could not make it work.
This is a source I used from EitanBlumin/Deploy SSRS Reports.ps1

Was able to verify $TargetReportServerUri link, it displays On in the browser.

[string] $TargetReportServerUri = "http://myssrsreport/ReportServer",
[string] $ApiVersion =2010,

It fails on main Upload command

Write-RsCatalogItem -Proxy $Proxy -Destination $currTargetFolder -Verbose -Overwrite -Path $currRdl -ErrorAction Stop | Out-Null

with this message:

Have  this message:
… roperties = New-Object System.Collections.Generic.List[$propertyDataT …
|                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Cannot find type [System.Collections.Generic.List[System.Management.Automation.Property]]: verify that the
| assembly containing this type is loaded.

Tried all suggestion and still can't make it work. Appreciate if you have hints how to solve it.
Best
VA

I have an SSRS report which utilizes a few different datasets, all of which have multiple values to return. The report is filtered to one specific user ID, and each dataset has a "WHERE" clause to filter by that ID.

I need to change this report for only showing the result for entity to multiple entities.

My understanding is that I can not use a literal SSRS list based on a dataset of all the IDs to show because the list would not evaluate each dataset for every row.

Therefore, I thought of using a subreport.

I was told by a colleague that this is unmaintainable, since now you have two different reports to maintain. He said that instead, I should do a cartesian join of every possible combination of my data, and use groups to filter it down. (The result would be one single dataset for the entire report.)

This seems FAR less maintainable to me. Now you have this giant query which does so many things and this cartesian join does not sound performant at all (although I don't think it matters given the scale of data for this particular report).

How would the experts of r/ssrs approach this problem?

We tested a new SSRS product this week and I genuinely can’t tell if this is actually viable long term or if we just had a really good lab run.

We had 50+ separate SSRS environments running on one VM at the same time for testing and training purposes.

Everything stayed responsive, startup times were quick, and resource usage was way lower than I expected.

I’ve spent enough time dealing with SSRS environments to know this normally becomes a mess pretty fast, so I’m curious if anyone else has seen setups like this actually hold up outside of demos. apparently the company works with Novartis and American Family insurance which sounds promising.

Would LOVE someone to help me out and figure out this product.

Hi all,

SSRS 2019.. reports are lightening quick for everyone, except for one single AD Group which just happens to be the DEVs. (So they complain). We are using a service account… the service account has SPN registered.. for the local FQDN.. we access the server via CNAME which is not registered though..

Also when trying to resolve this issue.. looking into rsreportserver.config The VIRTUALDIRECTORY (reports) seems to point to a different account (NT Service\SQLServerReportingServices) than the one used for the service (a domain account).

With types are:
Negotiate
Kerberos
NTLM

Using REPORTSERVER.. vs the Report Portal… REPORTServer shows the report faster than the report portal.

I have a feeling it has something to do with the authentication or service account being different from the config.

SELECT -SUM(ISNULL(LD.regAmtProjectCurrency, 0) +

ISNULL(LD.ovtAmtProjectCurrency, 0) +

ISNULL(LD.specialOvtAmtProjectCurrency, 0))

FROM LD

INNER JOIN PR ON PR.WBS1 = LD.WBS1 AND PR.WBS2 = ' ' AND PR.WBS3 = ' '

WHERE LD.WBS1 = '@activeproject' AND LD.ProjectCost = 'Y'

AND LD.Period <= '@period' AND (LD.Period >= 202500 OR PR.ChargeType <> 'H')

This is a piece of code I am trying to attach into my SSRS ( sql report service) . In the dataset I have entered this as a text type , but both my parameters are been replaced to '?' , which should not happen as how else will ssrs differentiate the two ?

I have tried other methods , pasting this as a text , but then i receive the issue , " declare scalar variable '@project' . I have both decalred the parameter in my Report Data -> Parameters and in the dataset , but still the issue persists .

In my Report data I have declared it as project in both name and prompt and in the dataset , have declared it as '@project' and the value is been mapped to .

Help is appreciated on this , as I have been sitting on this for a very long time .

Thanks in advance

FYI : i have not set ' ' between my parameter . My db connection is OLE DB and provider is OLE DB provider of SQL

We have a report that has multiple tables that list the top 15 performers in certain key metrics. The datasets are returned for each with a ranking and we filter the table for the top 15. Could we, in turn, initially display the top 15 but allow a user to expand to show all rows? Never done this and appreciate any guidance with this.

Thanks in advance

Marty

I’m trying to divide one amount by another if it meets the conditions.

=Switch(     Fields!AcctNo.Value = 81100, Fields!SrcCol1.Value / Fields!AcctNo.Value, Fields!AcctNo.Value = 40050, Fields!SrcCol1.Value,     True, 0 )

I would like to convert several ACORD insurance forms to RDL. It's not as if you can just dump a file into the hopper and turn the crank. What I'm finding is that you have to print an existing form to a local PDF printer to remove permissions protections (not password protection), and then, export that result to HTML. And not all HTML exports are created equal--simpler is better. I found an export format that is table-based, rather than SVG-based (I would not know how to convert the latter to RDL). I then ran this exported HTML through a pretty-printer so that I could make it human-readable. Once I did that, I was able to clearly see how inline CSS was being applied to fairly complicated forms. The attributes of text boxes (size, alignment, borders, etc.) can be obtained from this generated HTML. My next goal is to automate the process of parsing the HTML and generating RDL.

Before I embark on this...has anybody already done this? I don't mind doing the work but I don't want to reinvent the wheel. Was wondering if there is an existing Python library that will do the parsing...?

TIA,

KryptonSurvivor

We have an SSRS 2012 server, and we are migrating our reports to 2022. As a part of this, we are upping our security game - going to HTTPS and integrated security. Everything works except report subscriptions - we get the error "Subscription can't be created or edited because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid."

The problem is that we have a domain account specified on the Execution Account page of the report server configuration manager. If we specify the same username and password in a datasource it works, so I know it's good, but this is exactly what we want to avoid.

I'm following this link, but everything looks correct to me: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-the-unattended-execution-account-ssrs-configuration-manager?view=sql-server-ver17

Any ideas what else to check?

I have a scheduled export that runs at 6 AM every morning and sends an excel file to several users, and has run for years. I recently made changes to the report to show certain text and format cells based on certain criteria, but these changes are not shown on the export.

To complicate things, even more recent changes are now shown on the export, but the missing conditional formatting is not.

Newer export jobs that I've made to test this send the "complete" excel report with all changes.

Does anyone have an idea as to what we can try to get this export showing all changes? Should we re-create the export job?

I’m trying to make a parameter based off the value of my fruit parameter where I only have a certain amount of available values. The Fruit parameter has values: Apple Orange Banana

I want the second parameter to return the values of a different column depending on what the user picks for Fruit. An example would be

If @fruit = “Apple” then return 'Main'[apple_column]

If @fruit = “Orange” then return 'Main'[orange_column]

If @fruit = “Banana” then return 'Main'[Banana_column]

I’ve tried using if and switch with other table functions but can’t get it to work

Is this even possible? It seems like it should be such an easy thing. Thanks for any help, I really appreciate it

I have been banging my head on this all week and not any closer to a solution. We have a scale out server setup and a lot of reports being run daily as part of one of the core apps (80K-100K+). There are "bad" reports that just fail sometimes and other "bad" reports that cause a memory dump. The later I'm having a really hard time tracking down and wondered if you guys had any ideas.

I can gather all the error logs, parse them out, get the names of the reports that ran right up to the point of the crash, get from the exception what category it is (e.g. if it has UnhandledReportRenderingException I can look for status='rrRenderingError'), and look through the executionlogs views for it. It's supposedly UTC in the database executionlog2 view and it's CDT/CST on the SSRS servers running the reports. Nothing lines up. Not even close. So I wanted to validate some assumptions

1) Is the executionlog2 view in UTC?
2) The error logs generated are always in the timezone of the server generating them?
3) Despite crashing the process, the problematic report would have an entry in the executionlog2?

This was announced earlier today - What's New in SQL Server Reporting Services (SSRS) - SQL Server Reporting Services (SSRS) | Microsoft Learn. Check it out!

I am able to see my .rcs’s (report part files) in ssrs website folder but when i open report builder on my desktop and search for a report part, they do not show. I have data reader on and am able to publish report parts from report builder. It is just when i open a report in builder and then open insert report parts, it finds the server and the correct folder but it does not show the parts that are definitely there. Any ideas??

Hi all,

I am very new to server administration.

We have several SSRS reports 200+ MS SQL server 2012.

There are separate folders for Dev, test and prod. And in each of these I have the same folder structure in all these 3 environments.(for example folder names: Customers, Employers. Customers folder has Weekly Customer report and Quarterly Customer report)

Now some of them have Weekly or Monthly subscription too.

New server was created with MS SQL 2019 and this should have another environment Staging along with Dev, test, prod but same folder structure as the old server for customers and employers. I am given the task to move these reports over.

What is the best way to do this? IS there a way to automate this?

Thank you

Running across a weird error, and I can't seem to figure out if there's anything I can do to fix it. So we're building a solution for a customer using SSRS as the basis to create a bunch of reports that can then be put into a distributable PDF. All has been working good, until the customer came to us last week with a request to use their own custom font. They provided us with the otf files that we needed for their font, they've been installed on the SSRS server (Install for all users) and my dev machine. I updated the reports, and all looks good with the new font in the HTML render. So now when I go to export to PDF, and open in Adobe, I get this error:

"Cannot find or create the font "xyz,Bold". Some characters may not display or print correctly"

There are a few spots that have some odd characters, but overall it looks fine but just nothing is bold. I confirmed there isn't a separate "bold" font and it seems to look great if I bold the font in Adobe. Anyone have any ideas here, I'm kind of at a loss? I have a feeling SSRS is kicking out an old version of PDF, or maybe there's an embed fonts option I missed. I'm hoping its an easy fix and I'm not the first person with this issue.

I am trying to see if anyone knows what I can do to resolve this issue. We use SSRS in a .Net application. For years we have been able to use a string in the Action Go To URL. I believe that the application somehow captures that URL when it is clicked and then navigates somewhere in the application. After upgrading to SSRS 2022 the places we have this URL don't even act like thy are links. The pointer never changes to a hand. This is the function that we use. Does anyone know what may have changed that makes it so it isn't recognized as a URL anymore?

="Open:Entity:" & Fields!EntityID.Value

I thought maybe it was just something with the existing report, but I created a brand new report and it still doesn't work. If we revert back to SSRS 2017 the URLs work again.

So, this is so weird.  Has anyone tried to sum a lookup in SSRS in two different tables and have the sum only work in the first table? 

I've tried swapping the tables, whichever table is first works, the second table sum basically just does a row count.

I have two datasets, and I need to identify which ID exists in the other dataset that is missing in the other dataset.  So, I'm doing a Lookup from one dataset to the other.

 If the value doesn't exist it gets a 1.  This works.  I have it visible on the report, 1s and 0s as expected.  Rows are highlighted based on the same expression.  Works great for both datasets in both Table 1 and Table 2.
=IIF(Lookup(Value, Value, Value, "DataSet1") ="",1,0)
=IIF(Lookup(Value, Value, Value, "DataSet2") ="",1,0)

The trouble is when I try to sum the 1s at the bottom of the tables.

First table. This works.  12 rows, 8 missing from DataSet2, Count says 8.  
=Sum(IIF(Lookup(Value, Value, Value, "DataSet1") ="",1,0))

Second table, new tab when exporting to Excel.
This breaks.  21 rows, 10 missing from Dataset1.  Count says 21.
=Sum(IIF(Lookup(Value, Value, Value, "DataSet2") ="",1,0))

If I move table 2 to be the first table on the report, then the sum works for table 2 but breaks for table 1.

Why does the table order matter?  If I put them side by side, still only the first table sum works.
Grouping by the lookup didn't work.  It has to be something so obvious I'm missing.

Hi I am using SSRS 2016 and 2022, I want to enable logout functionality in it. The window is active for more than 1 hr. Is there any way we can implement logout functionality in that, also I am using custom security. Any thoughts about it

I have a query that will pull a datetime value from a column (actual_dt) and in that query I also have a CAST/CONVERT to pull the date only (MM/DD/YYYY only).

The "date_format" date will show for the parameter label while the actual_dt datetime value will be used for the parameter value to be passed to the main query.

The issue is that I pulled the desired results in SSMS with actual_dt column showing datetime and date_format column showing only the date. The issue is that running the same query in VS SSRS > Query Designer, I'm getting datetime for both columns.

Here is my current query:

select distinct actual_dt, cast(actual_dt as date) as date_format
from dbo.table_of_dates
order by actual_dt desc

What am I missing? Is it my query, different syntax in SSRS or is there a better way of doing it?

Appreciate the help in advance.

I have been tasked with converting crystal report reports to SSRS. I am running into a problem where the customer wants a location value bolded, followed by non bolded text pulled from the database. The text is plain text with carriage returns. The user also wants wrap around. In the first example you can see in crystal, bolded Location, followed by wrapped text that includes carriage return. The second example is SSRS, I use HTML mark up to get the bold and shove it in one cell in order to achieve the wrap effect, but in doing so I lose the plain text carriage returns. The second example I use a single field again but without html it has the carriage returns, but no bold. If I use two columns I can achieve the bold and the carriage returns, but not the wrap arounds.

Can anyone give me an idea how I might achieve all three requirements in the ssrs version of the report?