I tried everything! Hidden columns, report variables…making sure it was not in tables rows, or header. Added query to dataset. Nothing would work. So frustrated! Any other suggestions?

How would I keep a header row on a report like “freeze” in excel?

I want to see the headers while i scroll down the report.

The row group pane at bottom of report builder does not have this option. Any ideas?

Thank you!

As the title suggests, I am looking for any best practices on how to setup/manage security and the folder structure in an organization. Since SSRS's security model uses inheritance, it seems like it would be difficult to setup a folder structure like Department -> Department Managers -> Department Director where security is restricted the further you go without purposefully breaking inheritance. Should we create AD groups for each report item to control access? We also have people in other departments (or even within departments) who can/cannot access certain reports. Any guidance would be much appreciated. Thank you!

I have a report in SSRS where users can update a report by inserting a new delivery date for X item. This a parameter that does an insert into a Temp Table. We are trying to somehow keep track of who does the changes because we are using a SSRS web server. Is there a way to achieve this?

So we are trying to update our reports to an existing report server but point them at views from a Azure SQL server. We are having real difficulties with parameters on reports. The report server refuses to recognise them so the reports cannot run. For reports with no parameters they run the data straight away, has anyone come across this?

Heya Team.

I am new to SSRS, I figured this would be a good project for me.

Background
I am trying to automate some paginated reports based on a SQL Database. The Data in the database is being placed by a python script that is pulling data out of our CRM with its defafult headers. Its going into a single table inside of the table. Its NOT going into the "Report Server" & "ReportServerTempDB" that was made when I installed SSRS.

What I want to do
Have an automated way of spitting out reports based on the customers name, once a month as kinda a snapshot. I think this is refered to as the parameter. But also be able to have our account managers at any given moment print out a report based on the data in the database on a parameter of their choosing.

I have built the paginated report in PowerBI Report builder with a direct connection to the SQL database. I understand that I would need to recreate this in SSRS.

I think my questions are

1. Is SSRS the best way to do this? Should I be doing this in PowerBI Report Builder (Its got to be a paginated as the data will expaned and shrink based on our clients.)
2. If it is suppose to be done in PowerBI Report builder, why on gods earth is it so hard to publish the SQL dataset...

I have 7 main reports that need to be combined into one report. I've create one report that contains 7 subreports. There are 2 reports that use a cascading parameter to select the a product option.
Report 1 has option A, B, C D and E
Report 2 has options A, B, C D , E, F, G, H, J

If I try selecting all the options for report 2 then report 1 will not run and I get the error: Subreport could not be shown.

Any idea how the parameters for subreport 1 can be updated to ignore parameter values F, G, H, J if they are selected? If I only select A, B, C D and E all reports will return results.

Hello,

I've inherited, as part of my job, support for existing SSRS reporting and know close to nothing about it.

For scheduling there is supposed to be a Subscription tab/button on the report, I dont have that. Is it a role security issue or do i need software like Visual Studio?

Going forward do I need Visual Studio to make modifications to reports?

Any advice or recommendations are appreciated.

Thank you

We have migrated all places our SSRS reports to a new server (version 15.0.1103.12) using SSRS 2019. When we display a report and click on the print icon. It automatically prints to PDF and we don't want that. We want to be able to directly go to the print dialogue windows. We are using Microsoft Edge if that helps anything?

Thanks

Any ideas on how to bulk add fields from the ssrs query?

Hello! I'm hoping some of the smart people on here can help me out with a thorny issue I've encountered.

I'm a software developer trying to build a tool using the .net ReportingServices2010 SOAP interface on an SSRS 2012 box (I know) to migrate subscriptions owned by one user to another (domain change). The first step is to gather up all of the reports owned by the old user using the ListSubscriptions method for the root folder, which works great, but does not show subscriptions for reports created under the old user's user folder. Attempting to path into the folder (still using ListSubscriptions) results in a permissions error: 'System.Web.Services.Protocols.SoapException: 'The permissions granted to user 'domain\SomeUser' are insufficient for performing this operation.'. I have made sure the account the tool is running as has the correct permissions for this, and am beginning to think it's tied to the old account being either disabled or worse deleted as part of IT's migration process.

I really don't know anything about SSRS so if I'm thinking about this all wrong, I'm open to suggestions. I also know that editing the metadata tables in SQL directly is an option, but have read that that is not supported/recommended which is why I opted for using the web service. If that's the only option we'll just have to back it all up and do that, just looking for some ideas as documentation around this stuff is pretty much non-existent.

Thanks!

Just as title states, I have a few reports with inline queries and stored procedures. I ran both and the queries/exec procedures both ran perfectly. But when I run the report from ssrs I get a dataset error. I thought it might be database access issue with the ds and the user but that isn’t correct. I also checked that it could be because I was hitting two different databases but I cut one out. I also tried it without one of my parameters that is new but still nothing. I am at a loss of how to debug this issue. Again if it isn’t clear, I tried it inline and as a procedure and nothing works. I used the profiler to find the exact sql command and the procedure runs great. The inline is obviously not perfect due to double quotes but once that is fixed it is good to go as well. Any help would be great thank you all in advance.

Hi,

I am trying to put a certificate on SSRS, but I get a vague "We were unable to create the certificate binding" error. All my google links are purple now and I cannot find any new information.

SQL server 2019 with SSRS 2022 (same setup works in DEV environment - no problem).

THE ERROR:

Front end: We were unable to create the certificate binding

More information:

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80070001

---> System.Runtime.InteropServices.COMException: Incorrect function. (Exception from HRESULT: 0x80070001)

--- End of inner exception stack trace ---

at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)

at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.CreateSSLCertificateBinding(String application, String certificateHash, String ipAddress, Int32 port)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateSSLCertificateBinding(UrlApplication app, String certificateHash, String ipAddress, Int32 port)

The certificate is from our internal certificate server and works fine on the development box, just not production (it is not a public certificate). The certificate DOES contain the private key.

netsh shows no current bindings:

C:\Windows\system32>netsh http show sslcert

SSL Certificate bindings:

No indication of a conflict when checking netsh http show urlacl

--> Anyone ever seen this before? It is driving me nuts.

I am using MS Report Builder and I have a report with multiple datasets. Each dataset corresponds to a table on the report. I was asked to add a table to the report and I cannot figure out how to get the table width to stay the same when I run the report as it is in the report designer. I can’t even find a width property. What am I missing?

I'm trying to create paginated report based on level hierarchy,
I have 4 levels where I want to create a report in the following structure
Lvl 1
Lvl 2
lvl 3a
Cost center
Item
Cost center total
lvl 4a
Cost center
Item
Cost center total
Lvl 4a Total
Lvl 3a Total
lvl 3b
Cost center
Item
Cost center total
lvl 4b
Cost center
Item
Cost center total
Lvl 4b Total
Lvl 3b Total
Lvl 2 Total
Lvl 1 Total

Here is a Sample data, I want to know can we achieve that in SSRS/ power BI report builder?

I have a tablix that is grouped by industry (the parent group industry contains 4 detail child groups) , so that when the report is run, the 4 lists are produced for each industry in order.

Example (returns something like this-)

Aerospace

1. Top 10 customers by price
2. Bottom 10 customers by price
3. Top 10 customers by date
4. Bottom 10 customers by date

Construction

1. Top 10 customers by price
2. Bottom 10 customers by price
3. Top 10 customers by date
4. Bottom 10 customers by date

My question is, is there a way to force a page break to occur so that the first two lists of each industry is on a page together, then the 3rd and 4th is on a page together? If so how? I’m at my wits end

Thanks in advance!!

I am working on a report and as I work on it, I realize for use friendliness for future changes or anyone else looking at the report, it would be great if design view for expression values didn't display <<Expr>> but rather the title of the text box. It's a little surprising to me that I'm struggling with something that should be so simple because no instead of having the display tell me what each box is, I have a bunch of expression values and it makes for very poor readability.

Is there a way I can get SSRS to behave this way?

Hello Everyone,

I am converting crystal report to ssrs. i have created two tablix inside a rectangle and i have used this formula for printing data side by side:"=IIF((RowNumber(Nothing) Mod 2) = 1, False, True)" . The problem is tablix sometimes have null values and formatting changes and tried to insert the empty rows and visibility expression but on preview there are many unnecessary empty rows in tablix happens.

Can anyone can help with this problem .

Thanks!

Hello! We are moving away from Crystal Reports and I haven't had to build a report from scratch in years.

I have started making new SSRS reports. Does anyone have advice on lessons learned?

I think I need a template with a header and footer. Company name, report name, and date at the top. Page count and who ran the report at the bottom. I need ideas of any cool templates you have made.

I am new to SSRS. I am a 20 year database administrator. TYIA

Hello Guys,

I already did a lot of search about my issue and i've found nothing. So you are sort of my last hope.

Long time ssrs user on multiple company, i am facing something new. I am trying to build reports on a very specific database, HFSQL, using an ODBC connection.

I've build the connection string, validated.

When i run the query itself on MS Report Builder, it shows the expected results.

When i build a very basic report, just a tablix, in preview or published, i get #error on all fields. No matter the datatype. There is no calculation, just the field value

I've already tried to create new datasource, new report, make explicit datatype conversion, use different credentials ... righ now i am out of ideas.

Thanks in advance if someone can help.

Have a good day

I am attempting to perform an upgrade/migration of my existing instance of SSRS 2016 to a new 2022 install. I'm doing a side by side installation so that I end up with both the existing 2016 and 2022 versions on the same VM and then once I get the databases migrated to the new instance I will cut over to 2022 and decommission the 2016 installation.

I can install the evaluation edition of 2022 just fine. However, no matter which key I try to use, the installer rejects the key and tells me to enter a valid 25 digit product key. I've tried following the MS provided instructions here as well various other methods such as the registry (referenced here and here).

I opened a support case via the O365 admin portal and was told that because this isn't a cloud-based software they were unable to provide any support.

At this point, I'm starting to wonder if I just need to purchase an additional license for 2022 since my SQL Server license only goes up 2016; can anyone confirm if this the case? Or is there something else I'm missing to get the 2022 install to accept my license key?

Hi,

I have two instances of SSRS running, 2019 and 2022. In 2019 dataset caching (only dataset, not reports) works perfectly. The same configuration on the version 2022 doesn't work though. I see in the execution log that the data is being live retrieved again, instead of retrieved from the cache.. Anyone have any ideas?

Thanks!

We have an SSRS server that has been running for years. Starting today, when someone attempts to access, we get a 503 service unavailable message. Has anyone else observed this?

Error log shows "System.Net.HttpListenerException: The process cannot access the file because it is being used by another process".

I'm able to navigate to the default website as well as master data services website on the same port.

These are the updates that just installed last night. As far as I know, nothing else has changed since yesterday. Certs are up to date, subscription is good, etc.

https://preview.redd.it/nn60j1m4fnid1.png?width=569&format=png&auto=webp&s=0ff7eb5bc7b9b2aa7aeaae7d7ad0c8b060cf2b05

I am reporting on the Catalog table in the ReportServer db.
I don't know my SSRS version, but the .rdl report definition is 2016.

Background:

Recently I found an error in a report written by someone who assumed that the Employee table would contain a list of the employees - and s/he failed to account for the fact that people leave and are removed from the Employee table (only current company employees are listed).
This person used a Join instead of a Left Join, which gave 7 records in July, instead of 100+.

To ensure this wasn't happening in other reports, I wrote some (pretty ugly) SQL to figure out which reports used that Employee table, then looked at the join clauses.

Given that success, I thought it would be nice to have a report which shows all reports that use a user specified table name. This is what I'm having trouble with.

Question:

I have four columns in my report: Report Name, Report Path, SQL Length, and the SQL Statement itself.

I would like for the Tablix row to grow to show the SQL, but only up to a maximum height of 1" (3cm).

I am aware that I can set the height to 1" and set CanGrow = False, but I want to set a max height.
I'd want the ability to scan the list of report names visually and some complex reports (often the SQL is over 5k containing a hundred or more line breaks) make this impractical.

Setting the height to 1" with CanGrow=False exports to Excel does work, (the SQL is all there) it just isn't how I want to do it. I haven't found a way to use an expression for the row height. Any ideas?

I have a tricky report to build

I am building a report where it will be printed and a barcode scannd in a warehouse. I am rebuilding an old report.

There is a table section that is straight forward, but there is a bunch of independent fields.

Basically there is a detail section that will be a table that is purchase order detail and a bunch of text boxes. Each page has to hold one purchase order.

I've gotten the one page thing down for the table, but for the text boxes I CANNOT figure out how to get them to reflect the table in terms of the PO I am viewing. They are all from one dataset and all on the same row on the DB.

It would be easy peazy in power BI but this is shockingly hard. Ive been asking chatgpt for hours and can't figure this out. It keeps directing me to to select the first PO in the expression which results in the same PO on every page that doesn't match the detail table.

Any thoughts on how to do this?

Long story short:

• Need text fields to match purchase order information on table
• There is one purchase order displayed on each page ( I have figured this part out)
• How do I get text boxes to match the extra details a about the purchase order? The text boxes all display the same purchase order information - does not reflect the actual PO on the page I am viewing