Login failed SSRS Domain\Machinename$
Hi! I have a 4-server Reporting Services 2019 farm, connected to a separate database server. The reporting services starts with a domain user and the reporting was properly configured. Currently the service works without problems and the reports are…
SSRS - Report Model - convert XML to SQL?
Hi. I have a series of SSRS reports written against a report model. In report builder the dataset shows the XML which has been generated. Question is, can i convert the XML to SQL? Reason for asking is that I want to delete my report model and just…
Maintaining tablix width when hiding some columns in rdlc report
In our project, we got some rdl files that contains dynamic column, User can decide which to show or which to hide by a Multi-Selection Report Parameter. then it comes some problems: 1.if there is a report contains 10 columns, when the user selected 5…
SSRS Email settings
Hi, SQL Server 2012 Standard I dont see the column for entering authentication details for smtp server under email settings of SQL Reporting server configuration window. I edited the configuration file and added the userName and Password tags in…
Reporting Naming Convention for TFS Project Name and Reporting Manger Folder
Hi All, What is best way to organize your reporting (SSRS Paginated, SSRS Mobile and Power BI) Projects and reports on TFS and Reporting Manger..? I have separate SSRS Project on TFS for each Sub-Folders on Reporting Manager. On Report Manager, I…
SSRS Report Execution time different to Schedule Subscription time
Hi everyone. I am having trouble diagnosing an issue with an SSRS schedule. It runs once a week at 0130 but the execution logs suggest it executes regularly around 0146. I have tried the following but I found no clue as to what this may be: …
subreport spans multiple pages when saved to pdf
hi we run 2016 enterprise. i have a master report calling my subreport multiple times. i should start with the sub. when i run it stand alone and save to pdf, it spans multiple pages which dont want. the sub's report page size shows 8.5in, 11in…
pulling a calculated field from two separte fields
Hello, I have a table that is fed by a dataset. The dataset is a stored procedure that returns two lines associated with each employee. They are sorted by the indicator so line 1 is always followed by line 2. For example: …
Avoiding CSV injection vulnerability in SSRS
I'm trying to find a way to avoid CSV injection when i export a report to CSV format is SSRS (Microsoft Reporting Services). The "manual way" to do it is to add an apostrophe (') to each cell. That will "convert" everything to text…
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.