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.
SSRS - Slow SQL Connection Opening with ActiveDirectory User
Hi Everybody TL;DR: We are facing a problem with very slow SqlConnections (~20sec per connection) from a specific ReportServer to a Microsoft SQL Server and an Analysis Service Instance. Details see below. The current setup: SQL, SSAS and SSRS instances all installed on the same (Windows) server. There are two datasources configured on our SSRS (one connecting to SQL and one connecting to SSAS). The login-credentials for both datasources are configured with the same AD-user. Our problem: The SSRS-Reports are slow to load (it takes up to several minutes to render the report). We have viewed the log file and could see, that the sqlConnection opening takes up to 20 seconds. And that for each connection! On other ReportServers we have installed, it takes only a few milliseconds. It's not only the first call after some standby, but also every subsequent call. We have also made some performance tests for the specific SQL and MDX queries. The queries themselves are fast. Also the connection to the DB via OLEDB-driver (with the same AD-User) is instantaneous. What we have already tried: - During our analysis, we found the SPNs weren't registered. This has since been fixed: still the same poor performance. - We changed the credentials of the SQL-datasource on the ReportServer to a SQL-user: the test connection was now instantaneous. - But since we need an AD-user for the SSAS-datasource, we tried a totally new AD-user and used its credentials for the datasources: still the same poor perfomance. The next step that comes to mind, would be to completely remove and re-install SSRS, but we'd like to avoid this, if it turns out to not improve the situation at all. Are there any other steps that come to mind, we should/could try before a re-install? Thanks in advance for your help, Toby
Subscription Issue
Hello. I am having an issue with the subscription function. Anytime I attempt to subscribe to a report receive the following error: I have checked to role permissions, ROOT URL, and I'm not sure what is causing the error. The RSPortal log did return the following: 2024-06-06 10:04:26.3373|ERROR|54|OData exception occurred: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Net.WebException: The remote name could not be resolved: 'n' at Microsoft.ReportingServices.Portal.Repositories.SystemService.PopulateLocalizedExtensionNames(IPrincipal userPrincipal, List`1 subscriptions)Report Rendering Very slow when accessed from URL
Hi All, I have both power bi and SSRS report (same report and same data source SQL Server VIEW). When I run the SSRS report in VS it renders the data in few seconds, same is the case with the Power BI report, it renders the data (half a million rows) in seconds from the desktop. The issue is when I deploy these reports to the Report Server , it takes around 5-6 mins to render the data, any suggestions as where should I start to look at , to check where the latency is? Please advice. Is there any TSQL Query that I can run to check the latency? If the issue is on the database end then it must be slow on the VS and Desktop as well , that is my thought. Thanks
How to merge empty cells when exporting report to excel
Hi All, Please see the below screen shot, when I export the report in excel the user sees the report in the below format. If you see column A has only data in ROW 2 , column B has data in ROW 2 and 3, column C has data in all the 3 rows. Is it possible in case of column A if ROW1 and ROW 3 is empty , it should merge all the 3 rows as one, similarly for column B ROW 1 is empty so merge all 3 rows, column C will not be changed as it has verbage for each row. Hope I did explain good. ThanksFailure sending mail: One or more errors occurred
Hi. I am using Visual Studio 2017. I have a lot of subscribe's reports, since last Monday (08/01/2024), they just stopped. a message: Failure sending mail: One or more errors occurred appears. When I checked the RS log, a error message is displayed: emailextension!WindowsService_0!5378!01/10/2024-09:34:21:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Authentication failed because the remote party has closed the transport stream. I have no ideia what it means. The person who installed/configured SSRS didn't work in here anymore... Can someone helps me?
