This is actually pretty easy to do and Microsoft even has a writeup on it:

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-total-to-a-group-or-tablix-data-region-report-builder-and-ssrs?view=sql-server-ver16

The steps are:

In the tablix data region row group area, right-click a cell in the column...

@ScottPletcher I do agree that triggers and CDC are not necessarily performance killers, but they do impact performance. I haven't set up CDC, so I am not sure what the...

If memory serves, CDC is not trivial to set up and it can be a performance suck as well.

My opinion is still that targeting the stored procedure or application code...

To add to what Ant-Green suggests (dumping to flat files), that also would allow you to build a proper schema for it. I've seen some of the automated tools for...

My opinion, the easiest way to set this up (as a SHORT TERM thing) would be an after update trigger then. I say short term as triggers are "hidden problems"...

Might not hurt to ask about the new security policy and let them know that you are having issues complying to the new security policy due to how SQL Server...

Another thing to check is the logs. Look at the security logs on the server XXX. Chances are something will be in the log like "access denied".

Also, with it working...

One approach I can think of to this is to have the end users insert their job request into a table. Then you have a SQL job that runs every...

As far as I know, you can't have it export from SSRS INTO an existing Excel file. If you can, I'd be curious to know how that was done and...

@Grant Fritchey - pretty sure it is a cross database query (use db2, select from db1), so it should be using the same set of data and data structure, but...

While I agree with Jeff in the sense that "if the system is designed in one way, why change it to work a different way", I think I would not...

I am not sure how you ruled out "other tasks". SQL creating a dump is caused by something and the original dump you indicated to me REALLY looks like it...

My opinion, turning on the legacy cardinality estimator is more of a band-aid solution and it will fail in a future upgrade to SQL server as Microsoft isn't going to...

The error tells you exactly what is wrong. The CMS can't be in the registered server list. You will need to edit the CMS list to remove the "my new...

Moving physical hardware to virtual is easy in something like VMWare using a process called P2V. It stands for "Physical to Virtual" and it is for moving physical hardware to...