SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,860 questions
1 answer
Parameter Pane Style Sheet
Is there a way to change the style (more specifically the background color ) of the parameter pane when rendering the report on Report Viewer?
asked 2020-09-12T14:01:37.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 24%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
Joe Erickson
1
Reputation point
commented 2020-10-01T05:19:22.287+00:00
ZoeHui-MSFT
34,996
Reputation points
1 answer
SSRS 2019 File Share delivery not working
I am standing up a stand alone SQL/SSRS server with a named instance in aws EC2. Everything is working great except for the file share delivery to an inside domain joined file server. When using the file share account in SSRS configuration all the…
asked 2020-09-02T18:24:51.147+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 78%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mikedelix
1
Reputation point
commented 2020-10-01T05:18:17.86+00:00
ZoeHui-MSFT
34,996
Reputation points
1 answer
Trial using on-premises data gateway and paginated reports
Is there a way we can try out Power BI so that we can see how it works with an on Premises data gateway and insure a secure connection is used to view paginated reports developed in Power BI report writer or MS Visual Studio?
asked 2020-09-18T17:38:05.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 37%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hibberd, Mark
1
Reputation point
commented 2020-10-01T05:16:50.437+00:00
ZoeHui-MSFT
34,996
Reputation points
2 answers
SSRS chart with hint on series results on mouse over graph in "Parameter is not valid"
I have a very strange problem when I set the tooltip (hint) in the Series properties of a line that includes Environment.NewLine (in all different formats) and even spaces (" ") and other tekst to the different field values. When I preview the…
asked 2020-09-30T14:14:42.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 62%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Rutger Laarveld
1
Reputation point
answered 2020-10-01T02:18:38.45+00:00
ZoeHui-MSFT
34,996
Reputation points
1 answer
SSRS API download .pdf
With the API I can do this: http://10.0.15.78/reports/api/v2.0/Reports(01234567-89ab-cdef-0123-456789abcdef)/Content/$value Which sends back the report (.rdl) file. However, I am hoping to make a simple client app with a tree of report folders and allow…
asked 2020-09-29T20:31:31.667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 61%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Angus Beare
1
Reputation point
commented 2020-10-01T02:13:04.837+00:00
ZoeHui-MSFT
34,996
Reputation points
2 answers
One of the answers was accepted by the question author.
SSRS 2019 report embed into iFrame
we are looking some interactive report like dashboard kind of stuff so once we clock report title it will take you to other report so does it possible into ssrs 2019? 2.we need way to fixed columns character for displaying max limit this is possible…
asked 2020-09-29T09:27:17.06+00:00
Jitendra Jadav
21
Reputation points
answered 2020-10-01T01:10:19.123+00:00
ZoeHui-MSFT
34,996
Reputation points
1 answer
SSRS Report Viewer(website) is not scrolling in ipad
Hi, I have an application which uses the ssrs embedded into the application using the <object> html tag. When we open the ssrs report url in the ipad directly scroll appears as expected but in the application the reports sectrion is not getting…
asked 2020-09-29T13:21:31.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 87%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vemuri, Srilekha (Cognizant)
1
Reputation point
answered 2020-09-30T02:27:32.487+00:00
Joyzhao-MSFT
15,571
Reputation points
1 answer
One of the answers was accepted by the question author.
internal custom reporting error within SCCM
I am getting a certain error below when trying to do reports System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has…
asked 2020-09-27T21:34:07.593+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 51%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Milton Dorrielan
136
Reputation points
commented 2020-09-28T15:10:12.08+00:00
Milton Dorrielan
136
Reputation points
2 answers
One of the answers was accepted by the question author.
PowerShell command to update resource in SSRS
Hi there, I have around 100 folders on an SSRS server - each containing reports. I need to replace 2 specific reports across every folder. The manual process to complete this is documented at the following URL: …
asked 2020-09-16T10:24:16.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 87%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Anvy Ramsamy
21
Reputation points
accepted 2020-09-28T07:40:19.12+00:00
Anvy Ramsamy
21
Reputation points
1 answer
SSRS PBIRS Web Analytics
My environment an on premise PBIRS, running many .pbix and .rdl reports. I need to monitor which reports is mostly used by users. I added Google analytics code in my "C:\Program Files\Microsoft Power BI Report…
asked 2020-09-25T19:52:57.093+00:00
Douglas Filipe
1
Reputation point
answered 2020-09-28T01:56:50.873+00:00
Joyzhao-MSFT
15,571
Reputation points
2 answers
One of the answers was accepted by the question author.
How to use a PIPE to search in textbox parameter
Hello I have a parameter that allow the user to search for any phone number using 3 or for number. so i have this in my query t.phone.number like ( '%' + @number + '%' ) which work perfect ow we need to search for two different numbers such…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 49%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
2 answers
Percentage change column in Matrix tablix
I'm using SQL Server 2016 Report Builder. I have a very simple matrix that displays sum of revenue for my metrics by fiscal year. The dataset is a stored procedure that only returns data for two fiscal years, based on an input date parameter. Here's…
asked 2020-09-18T02:59:49.947+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 65%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mark Palmberg
1
Reputation point
commented 2020-09-25T10:04:24.107+00:00
Joyzhao-MSFT
15,571
Reputation points
1 answer
One of the answers was accepted by the question author.
Previous financial year - dates in a parameter in SSRS
Hello I currently use: =IIF(Today() >= DateSerial(Year(Today()), 4, 1),DateSerial(Year(Today()), 4, 1), DateSerial(Year(Today()) - 1, 4, 1)) and =DATESERIAL(Year(Now()) + (IIF(format(now(),"MMdd") > "0331",1,0)) ,3,31) …
asked 2020-09-24T09:35:00.047+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 54%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWF%3C/text%3E%3C/svg%3E)
Will Faulkner
201
Reputation points
commented 2020-09-25T06:37:28.507+00:00
Will Faulkner
201
Reputation points
0 answers
Cannot inialize the report (the request failed with HTTP status 404:NOT FOUND)
Please help me here, Suddenly the error occurs in our environment...
asked 2020-09-22T22:41:03.087+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shiva Ravichandran
41
Reputation points
commented 2020-09-25T03:25:19.163+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Crystal-MSFT
45,896
Reputation points Microsoft Vendor
2 answers
can a tablix's header be repeated even on the same page?
Hi. At https://learn.microsoft.com/en-us/answers/questions/86991/too-much-room-between-my-header-and-1st-line-of-ta.html you can see in the first image the tablix involved in this post. Because the detail info can be voluminous (ie it grows because it…
asked 2020-09-22T21:31:52.817+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
db042190
1,516
Reputation points
commented 2020-09-25T02:07:43.953+00:00
Joyzhao-MSFT
15,571
Reputation points
2 answers
One of the answers was accepted by the question author.
Is it more secure to install Reporting Service and SQL Server on different servers?
Hi, For security sake, will it be safer to install the Reporting Service and SQL Server on different machine? Thanks for help. Jason
asked 2020-09-24T08:05:33.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 41%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jason Huang
21
Reputation points
accepted 2020-09-25T00:35:28.557+00:00
Jason Huang
21
Reputation points
2 answers
One of the answers was accepted by the question author.
SSRS 2017 -- Why does a cached report render interactively instead of from a pre-generated snapshot?
Hi All, I am seeing strange behavior with cached reports. I have configured a report to always render from pre-generated snapshots. As a result, from the user's viewpoint, the report renders almost instantaneously. But sometimes, the report…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
all datasets and t-sql scripts in master and sub using the same session
hi i am involved with a front end technology that sends a request to my master report. the subreport's multiple t-sql scripts and one proc MAY need to use the same sql engine session started by the master's proc. there is plumbing back to the …
3 answers
Remove whitespace for images in a tablix
Hi I have a datasource that contains multiple bmp images. They are bound to a tablix that shows one image per row. The tablix has large whitespace between each row. The tablix contains no other information other than the images. Is it possible to…
asked 2020-09-23T05:07:02.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 84%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Shiv
1
Reputation point
commented 2020-09-24T09:29:06.433+00:00
ZoeHui-MSFT
34,996
Reputation points
2 answers
SharePoint Form Based Authentication and SSRS data source
I have SharePoint 2016 Web Application with Claims Authentication (using NTLM). When I try to create "SharePoint List Data Source) as Embedded Data Source in Report Builder or Shared Data Source in SSRS Portal - everything is working fine. I'm…
asked 2020-09-23T09:25:59.503+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 9%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Matus Corny
6
Reputation points
answered 2020-09-24T08:16:59.48+00:00
Matus Corny
6
Reputation points