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

Hi All

anyone have a working link for SSRS download? Using this gives me an error: https://www.microsoft.com/en-us/download/details.aspx?id=100122

https://preview.redd.it/822y7p7jxtcd1.png?width=1194&format=png&auto=webp&s=30a827e08e931d10ed3d3a83dc07f81be913ee9d

S

Is there a way to have an SSRS subscription write to Microsoft Teams? I only see email or file share as the only options.

Is it possible to create tabs on the left side of a report? I’m thinking of like a dashboard or customer Wii that shows customer information and has tabs that a user can click on to see various details about that customer

So we finally got SSRS 2022 after years of using 2012 or lower.

I'm not finding a way to force List View mode instead of Tiles like I could with the older versions. List View mode is so much better as it has descriptions and people seem to be able to find their reports easier than in tile mode.

Googled it like crazy, read everything MS has on SSRS and can't find anything about forcing List View mode in the new version. In the past it was just /Pages/Folder.aspx?ViewMode=Detail

Is that not a thing anymore?

Also, it seems like when I "Hide Item" it only hides it for me while on the older versions it hid it for everyone. Is there not a way to set Hidden property for everyone?

How do we pull out information from SAP B1 to create a statement of cash flow in SSRS?

Hi there!

I am hopeful a savvy SSRS user may be able to help me out. I have a report that pulls from our database a list of items. We have the manufacturer short-coded (example - Patagonia would be coded as "PAT"), however, there is a list of over 4000 manufacturers so it isn't really feasible to code all of this with IIF statements to display the description. Is there a way to add a search box or something similar that could be on the side of the report where a user could search the code to see the description or long-name of the manufacturer? I haven't seen anything like that but if possible, that would be absolutely wonderful.

Disclaimer, I do not wish to make anyone here give me legitimate step by step instructions on building this report, just generic direction so I know how to research and learn on my own, I just wanted to clear that up so you all understand the level of help I'm asking for.

So here's the skinny, my company uses an ERP system for all of our accounting functions, however it's a smaller company and a very niche program that is specifically built for NFP/Governmental entities, and has very limited functions. It's a point of contention with us in the department, but ultimately making Excel workbooks to manipulate the data has been easier than completely switching our accounting system over to a new ERP system, and the chances that we actually change are slim to none and certainly not within a year.

I've been tasked with developing a Statement of Cash Flows for my company, and where it gets tricky is that we don't have this function in our reporting with our ERP, and even if we did, the support group isn't adequate in understanding our requests and providing us with comprehensive guides or answers. This means that we have to rely heavily on the community of users, or developing external approaches to solve our issues. In the past, we've had a contractor that has used their background with SQL and SSRS to develop template reports for us with regards to balance sheet reporting and income statement reporting, so it is certainly viable to build out a report function in SSRS to pull and manipulate the data from our ERP system, but here is where things get sticky--I've never used SSRS and I don't have a background in SQL just yet.

I'm curious, from those of you who use SSRS, how capable is the program of building a SoCF, and what steps would I likely need to go through in order to build a template out for this report? I'm trying my best to recreate our audited financials in Excel, but this would be far easier if I could use the format and organization of our accounts as they're laid out in the ERP system to design and format this report. I'm looking into a beginner SQL course, as well as some beginner SSRS training courses to educate myself on the two, but the issue with trying to plan this out is that I don't know what I don't know, and someone with more knowledge of the program would be able to help at least clear the path a bit for me to learn how to build this on my own.

I have a bar chart that shows % on the Y access 0-100% and the X access has months. The value we are showing is % of laptops issued in (3 days or less) or (4 days or more). So, each month has 2 values. There is a parameter that determines the @Start and @end dates.

If I use the regular values everything works.

If I use %, each month is showing 5% and 6% or 10% and 8% all of the (3 days or less) values add up to 100% when adding each month horizontally and same goes for the (4 days or more).

For the life of me I can't figure out how to show the % each month so each month will equate to 100%. Maybe I am overthinking it, any help is appreciated.

To better explain it, if the duration is Jan - May, I want to see for each month 80/20 or 60/40, etc.

We have a dedicated Windows 2016 Server with 6GB of RAM, I'm feeling like that is undersized for what we run. The server probably needs half of that if not a little more just to function. Currently some subscriptions become kind of orphaned where they never actually finish.

Our reports can have millions of rows depending on the parameters.

So I'm curious what other people are running for memory on a dedicated report server?

I installed SSRS and can't get any of the URLs to return with more than an error page. The most detailed message I can get is "Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)".

The error seems to indicate a problem with the database connection, however:

• server is running as a domain account with admin level access
• db connection is running as the same
• report server database and tables were created successfully
• test connection function on the Database section in config manager succeeds
• I can log into the database using the same account, and view and read data from tables in the report server database
• hard drive has plenty of space

It might be worth noting that I'm running an evaluation install of SSRS

when i go to this page to download SSRS 2022 https://www.microsoft.com/en-us/download/details.aspx?id=104502 the exe i launch afterwards shows this: https://imgur.com/a/Dbvbs8Z

is this intentional? also does this mean i need to use a SQL 2019 license key instead of 2022? cause it states my 2022 key is invalid.

Hey Reddit Mafia,

I have a client that is wanting to migrate to SQL 2019 from 2012. That upgrade path as you all know de couples SSRS from the SQL upgrade. The problem that I am having is that migrating the SSRS to 2019 around forms based authentication, their 2012 setup uses forms based auth for login. I have tried several times to migrate this and am running into problems. I have installed 2019 SSRS and assigned it the correct virtual directories and it upgrades the SSRS database fine, then i restored the encryption keys sucessfully and stopped services. i copied the aspx login page as well as the dll and pdb files to both reportserver/bin and /portal directories and then edited rsreportserver.config file and web.config file but when i start the services and try to access the url i always get an http 500 error.

I am at intermediate level on SSRS here and need help to get the forms auth working. what am i missing?

Thanks in advance!

Hi, starting yesterday browsers have been blocking downloads of reports. We can hit keep to get the file but is there another way to whitelist the address so we can download without the extra step?

​