Forum Widgets
Latest Discussions
Where clause that looks up values from an outside source, using Report Builder in SSRS
First off, I apologize if this is posted in the wrong place, but I didn't see anything that was dedicated to Report Builder. Secondly, I'm in Finance and understand some level of SQL reporting so please bear with me on this question. I also realize that being within the corp walls, that my ask here might be something that I may not have permission to do, but I won’t know for sure until I attempt this. I use SQL Server Management Studio 19.3 to create my queries. Once I have my query where I want it, I launch Report Builder from SSRS. I do not see a version # for Report Builder. I copy my query into the SSRS report and then publish it (save it, etc). Example data: Table 2 has a field called “Username” I write lots of queries that ultimately end up being SSRS reports that rely on Table 2/Username. Many of these queries I hard-code in a list of Usernames. So, say I have 10 SSRS reports already created but then in the future the list of Usernames changes. It’s a pain to update all of the different queries/SSRS reports. Say my query looks something like this: Select t1.ID, t1.Field1, t1.Field2 From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID Where t2.Username in (‘Username1’,’Username2’,’Username3’) Is there a way to have the above WHERE clause look at another table where I store the values ONE time? Where I can manage that list of Usernames in ONE place? Basically ending up with something like the following? Select t1.ID, t1.Field1, t1.Field2 From Table1 t1 inner join Table2 t2 on t2.ID = t1.ID Where t2.Username in Table3/External Source If so, I would appreciate any insight on how to accomplish this. The more detail the better as I am a novice at this. If you need more info, please let me know, but I believe this should cover what I’m after.
GO To URL Action - Pass Parameters SSRS
Hello! I am trying to use the Go To URL action to open up another report and also pass the parameters stipulated by the user in the "Parent" report to the "Child" report. I added the code below to a text box on the main report and it opens the Service Call Proposal-TAGR report successfully. Now I just need to pass the parameters in the URL as well and I don't know the syntax for doing that. Any help would be appreciated. Thanks! javascript:void(window.open('http://sql-server11/Reports/report/TRC/Signature Service/Service Call Proposal-TAGR' ,' _blank'))
go to file Url, extended ascii gets converted
Hi all, I have a textbox action 'go to Url' that has links like \\Myserver\Documents\Documents_Uploaded\Czekański DOC01_169645.pdf When this link is clicked and the browser is opened (tried it with Edge, Chrome) the link is converted to \\Myserver\Documents\Documents_Uploaded\CzekaÅski DOC01_169645.pdf which doesn't work obviously. all extended ascii characters seems to be converted to some other extended character when the browser is opened, can I prevent this conversion from happening, in other words just accept to string the way it is? And just to make clear when there are no extended ascii characters in the string it works as intended :-) I tried the System.Uri.EscapeDataString(URL) and System.Web.HttpUtility.UrlEncode(URL).ToString some sites suggested but that doesn't work for files locations only for web urls Thanks in advance Rbie
Fixed Rectangle or Table
Hello All, I have a need to put multiple tables into a single report. Issue is that some of these tables can grow up to 2 pages or more pushing all the other tables into different pages. I want it somewhat like a dashboard where users can view all the tables/tablixes in one page and have the ability to scroll up/down and right/left. In order version of Report Builder, I recalled that rectangle you can set it to fixed size and place multiple tables in one page without having it push into multiple pages. However, it's been a while since I use Report Builder and do not see this option any more with newer version of Report Builder. Anyone have any suggestions how to get it to work similar to what I'm looking for?
SSRS Report Rendering Issues via ReportExecution2005 API
Hello everyone, We are encountering intermittent issues while requesting PDF renders of large SSRS reports from our SSRS server using the ReportExecution2005 API from a .NET 6 backend. While this generally works, we occasionally run into unexplained failures. For example, we have a report with approximately 47,000 pages. Every time we attempt to generate this report, the process fails after about 17.5 minutes. Examining the ExecutionLog and our own logs, we can confirm that: The data query executes successfully Report processing completes without errors The rendering process runs for a few minutes before the SSRS service throws an error, terminating the connection with our backend The ReportingService log file contains the following error: System.Threading.ThreadAbortException: Thread was being aborted. Additionally, ExecutionLog3 lists the status as: rsInternalError Since this issue consistently occurs around the 17.5-minute mark, we initially suspected a timeout and increased all possible timeout values. However, this had no effect. Interestingly, when we restart the SSRS service, the PDF sometimes renders successfully, taking about 40 minutes to complete. After that, all subsequent requests again fail with the same error. This raises a few questions: If the report sometimes completes successfully, can we rule out a timeout issue? Memory usage remains well below the configured limits, and we can manually request and render multiple large reports simultaneously without issue. Is there any known SSRS behavior that could cause this repeated failure over time? As a temporary workaround, we’ve set up subscriptions to trigger SSRS to render the PDF independently, but we would prefer to resolve the API issue so we can use our direct request approach. Has anyone encountered a similar issue or have insights into what might be happening? Thanks in advance!
SSRS Styling parameters
Hello, I am encountering an issue or possibly a limitation of SSRS. I am trying to have parameter "A" be greyed out or hidden based off of the value inputted into parameter "B". Currently I am using cascading parameters to display different values in param "B" depending on param "A" inputted value however would it be to grey out or hide param "B" based off of the value of param "A"SSRS Report with multiple parameters but can only use one
Hello All, I have a report I am creating that has two parameters that can be used, but only one of them can be used. If parameter 1 is used then I need parameter 2 to automatically select the empty value. If parameter 2 is used than parameter 1 will select the empty value. Is this possible? Thanks Crote
SSRS error on sign in ERR_UNEXPECTED
Hi All, I have an error coming up when anyone tries signing into our company's Report Server Portal. The error appears for one or two seconds and then the portal starts loading successfully. This is from an Azure VM running Windows Server 2019 Datacenter. Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64). SSRS SQL Server Developer edition 15.0.1102.675. Below are links to log snippets from one of the attempts at signing in. This error occurs for all users and only on sign in, not while trying to run any reports. At the time of testing the issue, there were no other processes running or users running reports. RSHostingService log snippet RSPortal Log snippet Any guidance or tips would be greatly appreciated. Thanks
Reporting Functionality | Power BI paginated Reports| SSRS
Hello, I need to create a report on Power BI paginated report which is similar to SSRS ,where I need to show a report as given below. From the report which I have created got the result as below. Now I need to generate a new column called TestNo column which need to be included in my result shown above. But it should be based on SDIDATAITEMID value which I have shown above. It should give me the values as TestNo 8043366 - 1 8043367 - 2 8043368 - 3 8043369 - 1 8043370 - 1 8043371 - 2 ,.... Likewise.... I can provide more info if someone could help me here.
