Forum Widgets
Latest Discussions
SSRS Use Excel WorksheetFunction.Round method in custom code
Hi, I'm trying to implement a custom code function to be used in an expression of my SSRS report but I'm unable to get it running. Here's what I have so far: Report Properties - References: Assembly Microsoft.Office.Interop.Excel, Version=15.0.0.0 Report Properties - Code Public Function fRunden(Wert as Double, Dec as Double) as Double Dim excelApp As New Microsoft.Office.Interop.Excel.Application dim roundval as double roundval = excelApp.WorksheetFunction.Round (Wert, Dec) Return roundval end function In the Tablix Textbox I've added the following expression: =Code.fRunden((sum(Fields!Hours.Value,"GroupDataset")/sum(Fields!Hours.Value,"TotalDataset"))*100,2) Howerver, rendering the report results in #Error in the textbox From the Microsoft language documentation the WorksheetFunction is implemented as an interface. So I'm not sure if I correctly use the objects in my custom code. Any help is greatly appreciated. Thanks
SQL Report Builder rendering error.
Hello Recently a colleague who uses Report Builder regularly has been getting a weird error when the reports are rendering properly. He thinks it's since his laptop has completed some updates. I've attached a screen shot as an example. We know that this doesn't appear to be a system issues as other users are not reporting any problems. From looking at the screen shot it's almost like the report is out scale. Thanks TimSSRS-generated Word .doc files don't render correctly in MS Word 2505
Hi All, SSRS 2022 version 16.0.9276.19198 generates Word 97-2003 .doc files which can be opened fine in MS Word 2504. Word 2505 doesn't display the same .doc files correctly, the document layout is off. Is there a version of SSRS that generates Word .docx version 2007 files? Alternatively, is it possible to correctly display Word 97-2003 files in Word v. 2505? Thanks!
SSRS Subscriptions "To" Field Not User Email
Hi, I know this has numerous other posts, but I could not find crystal clear, satisfactory answers in any of them. SSRS 2019 When a user subscribes to a report in SSRS, the "To" field is pre-populated. However, it is pre-populated with their username, not their email. In our case, the username is part of the email, e.g. "email address removed for privacy reasons". I tried altering the SendEmailToUserAlias attribute in the rsreportserver.config file, but changing this to False merely makes it editable, and we don't want it to be editable. We want the email to show up. (If it is editable, users could have control over the email a subscription it gets sent to, and the point of the feature is for them to be able to set up subscriptions for themselves.) (Mine does let me edit because of elevated permissions, but "To" is appropriately greyed out for standard users) Changing the DefaultHostName attribute doesn't seem to either update the pre-populated email nor does it seem to constrain the domain to which emails can be sent (which could maybe be okay if we really couldn't get the true email pre-populated, but isn't desirable either). I put the same host name that is used in Report Server Configuration Manager for the sender address, which is on the same domain as user email addresses. In AD, the userPrincipalName is the full email address. The only attribute that seems to have just the username is sAMAccountName - is this indeed what SSRS is pulling from? I would rather not have to change this attribute, but I might be willing to if it meant that users could subscribe to emails themselves automatically. Is there really NO way to have the "To" field pull in the users email address?
What are the risks associated with JavaScript hyperlinks on SSRS ?
Hi everyone, On January 6, 2025, Microsoft set the default configuration in SSRS so that the SupportedHyperlinkSchemes property no longer supports JavaScript. My questions are: 1. Specifically, what are the risks associated with JavaScript hyperlinks on SSRS ? 2. Does this change affect only hyperlinks? Will other uses of JavaScript in SSRS be impacted as well ? Thanks in advance, Ian
Cannot Change Service Account After SSRS Migration
Apologies if this is posted in the wrong place. Following the migration of a Report Server Database to a new server, i have imported the SEK and the SSRS website appears to be working as expected, but i need to change the service account from the default. When i try to change the user and enter a location and a password for the Key file it then asks for administrator login credential for "applying grant rights script for the new windows service account", even though i am an administrator on the server and in SQL If i click OK i get a message saying Report Server Configuration Manager A connection could not be established with the information provided Hit OK to change your connection settings A connection was successfully established with the server, but then an error occurred during the login process (Provider:SSSL Provider, error 0 - The certificate chain was issued by an authority that is not trusted) Can anyone advise on how to resolve this?
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?
