Reporting URL not working
All, Reporting URL is not working. How to troubleshoot the issue. However http://localhost/Reports is working, and 'http://Servername/Reports' is not working. Please assist to troubleshoot the issue.
SSRS report when run manually in Reporting Services never finishes. Same report when run via a report subscription runs in less than a minute.
I created a report subscription for a SSRS report and it runs and is delivered within one minute. The same report when run manually in Reporting Services never finishes. The report simply calls a stored procedure which selects from a SQL view. …
SSRS report in Visual Studio takes 2 minutes to run, the deployed report when run from Reporting Services takes forever. Why?
I have a report that runs in 2 minutes in Visual Studio connected to the production database (16k rows, 50 columns), but it takes more than 16 minutes when run by Reporting Services in production after deployment (I have to cancel each time). Both…
How to show #ERROR as Zero or as Nothing in matrix cell when groups and calculated field are based on switch-function in SSRS?
Imagine simple BI task: We have two grouping columns and one calculated field. like select group1, group2, sum(sales) Sum_of_sales from dbo.table1 group by group1, group2 When for some combination of grouping columns there's no ROW in dataset -…
Exclude empty rows in Report
I have a table in an RDL file. Empty rows create due to the (Finish) field contains in sql query, (Finish) field not used in the main report. Field (Finish) is used as a parameter to go to the subreport, I cannot delete it. How to exclude…
pdf makes top margin on first page slightly larger and adds blank page at end
hi we run 2016 enterprise and develop using vs 2017. my subreport has been changed to have a .04 cm top and bottom border so a rectangle at the top can always have a predictable bottom border location for tear off purposes. when i print stand alone…
Does SSRS 2019 have the ability to encrypt attachments?
We are going to be sending email attachments as part of a data driven subscription. Some of the attachments could contain PHI. Can SSRS 2019 encrypt the files that are attached to the email?
Is there a way to auto-create all of the columns in a tablix?
Is there a way to auto-create all of the columns in a tablix? I have a SQL view with 100+ columns that the user wants to see in a spreadsheet created from an SSRS report and I do not want to manually create each column for the tablix.
Just show last date with Report Builder 3.0 custom report
Is there anyway to just show the last date something was added within the report builder as in reports I am getting multiple results when I just want the date of the last one added.
VB.NET ReportingService2005 QueryDefinition.CommandText
I would like to know if there is a good example of ReportingService2005 QueryDefinition.CommandText using vb.net. My goal is to retrieve / get the SQL within the rdl report. I found this Link but no examples how to use it. any suggestions is…
define query parameters for my dataset in SSRS
Why am I being prompted to define query parameters for my dataset in SSRS when I select "Refresh Fields" when it is simply calling a stored procedure? There is an SSRS report parameter for each stored procedure parameter.
Why am I being prompted to define query parameters for my dataset?
Why am I being prompted to define query parameters for my dataset when I select "Refresh fields"? It is simply calling a stored procedure.
adobe saves report incorrectly
Hi after some work, my subreport which is just one rectangle enclosing various "sub" rectangles etc looks beautiful when saved to word. But ridiculous when saved to pdf. the first sub rectangle prints on pg 2 out of order after the 2nd…
403 error from app requesting report rendering
hi i'm geting particulars on the calling app but a peer of mine trying to render my report from his app got the following error. i reached out to him to determine if he entered the ssrs report directory correctly but if the community can offer insight…
SSRS 2016 allows the display of sensitive parameter in its URL such as Session state token
SSRS 2016 allows the display of sensitive parameter in its URL, such as Session state token. This can be used to manipulate the data being displayed allowing other resources information be visible to other users.
Vulnerable and outdated Jquery and bootstrap version (Integrity)
SSRS 2016 uses vulnerable Jquery 3.3.1 and Bootstrap 3.3.5. A security assessment found that an attacker may use the vulnerable JavaScript framework version to perform malicious attacks. Assessment suggestion for remediation is patching or update to…
Help creating a Report that Combines output of 2 tables and a Query
I'm not sure if this is even possible but wondering if anyone has any advice to help see if? Current doing this in Report Builder 3 I'm hoping to have a report out put something kinda like the below The goal is based on two other tables and…
SQL Server Reporting Services -- Deploying report fails -- The operation has timed out
HI All, I am getting an error today that I have not received before. When using Visual Studio to deploy a report to my SSRS 2017 Report Server, I am getting the error "The operation has timed out." I am using SSDT and Visual Studio…
SSRS - STORED PROCEUDURE WITH TABLE VALUED PARAMETERS
Hi, How can we use Stored Procedure with Table Valued Parameter in SSRS Dataset ? CREATE TYPE DBO.MultiFilter AS TABLE ( filterVal VARCHAR(200) ) CREATE PROCEDURE DBO.USP_multiFilterTest @position DBO.MultiFilter READONLY …
Lookup do not bring amount
Hello There I have to datasets one for expenses and one for revenues, it is partially working because the lookup is bringing one value from the datasource therefore I am out balance. The money is sitting there but my lookup is not bringing both…