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
LookupSet no longer working after v150.900.148
The following code to retrieve a list of textual descriptions for a sales contract no longer works in v150.1404.0. In place of the descriptions, it is now printing "#Error". =Join( LookupSet( CStr(Fields!BOLId.Value) + "," +…
asked 2020-09-22T00:13:48.577+00:00
Gary Fuhr
96
Reputation points
commented 2020-09-24T03:04:47.96+00:00
ZoeHui-MSFT
34,996
Reputation points
2 answers
Images in SSRS reports
Hello I’ve got a report where I'm using rectangle to create a page. I've dragged an image onto the rectangle and resized the image the same as the rectangle. The image has the rectangle as it’s parent. I’ve added text boxes on top of the image, the…
asked 2020-09-22T16:14:13.133+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(198.4, 5%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RoyB09
306
Reputation points
commented 2020-09-24T01:27:42.737+00:00
ZoeHui-MSFT
34,996
Reputation points
5 answers
One of the answers was accepted by the question author.
SQL Query with string and Tab as an email format.
Hello Everyone: I have a table with column names below : Select * from Table Column1 Column2 Column3 California area Report California Beach Program John Doe Here is my…
asked 2020-09-18T19:38:16.417+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(284.8, 36%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
kkran
831
Reputation points
commented 2020-09-23T15:00:47.01+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(96, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Stefan Hoffmann
621
Reputation points
3 answers
One of the answers was accepted by the question author.
Licensing SQL Server 2016 Reporting Services - Sharepoint
Hello! We have a Sharepoint 2016 Server Farm, with Database tier on SQL Server 2017. Now we want to install SQL Server 2016 Reporting Services in Sharepoint mode (i.e. install Reporting Services - SharePoint to our Sharepoint Servers). Do we need a…
asked 2020-09-21T19:04:18.037+00:00
Alexey Bulgakov
21
Reputation points
answered 2020-09-23T09:32:38.86+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
1 answer
SSRS 2016 Bing Map TileServer issue when report deployed on Reporting manager
Hello, This is in regards to showing Bing maps in SSRS 2016 on the reporting server. I am able to use a TileLayer using spatial data on my SSRS IDE and able to generate maps on my local designer. Once I pushed this report on reporting server it…
asked 2020-09-03T08:58:49.663+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(211.20000000000002, 7.000000000000001%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
Nilesh Patel
1
Reputation point
commented 2020-09-21T07:56:17.043+00:00
Joyzhao-MSFT
15,571
Reputation points
2 answers
Report won't return values from procedure unless it is recompiled
I started seeing strange behavior in a report yesterday and don't understand what's going on. I'm hoping for ideas. Situation: I have an rdl report with a dataset that calls a stored procedure. Yesterday I noticed that the report stopped returning…
asked 2020-09-02T15:52:41.807+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(140.8, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Crescentia Stegner-Freitag
101
Reputation points
answered 2020-09-21T07:54:49.127+00:00
Joyzhao-MSFT
15,571
Reputation points
6 answers
Reporting Services protocol HTTPS return to HTTP in web services URL
Hi!! I have a reporting services server version 2019. On this server a security certificate was installed and configured so that the reporting works with the HTTPS protocol. When entering the URL of the web service and using the HTTPS protocol,…
asked 2020-09-02T19:18:55.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(124.80000000000001, 73%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pablo Porras
21
Reputation points
answered 2020-09-21T07:49:09.043+00:00
Joyzhao-MSFT
15,571
Reputation points
1 answer
SSRS Report runs slower in Preview Mode/Report Viewer
I am using Visual Studio 2019 and using Microsoft Reporting Services Projects Extension v2.6.7. The problem i am facing is i have a report that process about 60k records, the report is complex and has Groups, repeat headers, dataset filters and also VB…
asked 2020-09-10T02:31:42.663+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(48, 59%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Vinayak Naik
6
Reputation points
commented 2020-09-21T06:36:57.147+00:00
ZoeHui-MSFT
34,996
Reputation points
5 answers
too much room between my header and 1st line of tablix
hi we run 2016 enterprise. i just stood up a report with a header and following directly beneath the header's last line is a tablix. i deleted the tablix's header. when i render in vs 2017 i see a reasonably small gap but when i save to pdf way…
asked 2020-09-04T15:51:17.42+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-21T02:55:55.817+00:00
ZoeHui-MSFT
34,996
Reputation points
3 answers
Software Update Group Patch Status Query SQL
Hi Team. Currently he gave the client a patch status report of the month, where he shows me all the computers and their different patch status (Installed, Not required, Error, in progress, pending restart or unknown status) More than 100…
asked 2020-09-19T17:15:05.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(86.4, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rafael Aguilar
496
Reputation points
commented 2020-09-20T17:29:28.72+00:00
Rafael Aguilar
496
Reputation points
7 answers
Not In Filter expression
Hi, I'm trying to filter my dataset rows where I dont want my dataset to have rows with X,P I m not able to find "Not in" operator to filter the dataset based on ResultType field How would I do that?
asked 2020-09-09T16:46:08.48+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(236.8, 1%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Saqib Mahmood
1
Reputation point
answered 2020-09-18T03:55:26.09+00:00
Joyzhao-MSFT
15,571
Reputation points
3 answers
power bi training
Hi experts, I have worked as a DBA for around 6 years, (every now and then I did some basic reports in Power BI). Unforuntately the last 2 years I was unable to work, so now I am trying to get back in the market but as BI developer. I do know sql,…
asked 2020-09-11T13:29:06.113+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(249.60000000000002, 46%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
ovonemty
56
Reputation points
answered 2020-09-18T03:53:03.233+00:00
Joyzhao-MSFT
15,571
Reputation points
2 answers
SQL Server reporting (SSRS) rskeymgmt is not working
Hi there, We are using rskeymgmt -j -m [remote server] -n [instance name] (for named instance )to join the server in scale-out. But it is not working and giving the below error message. rskeymgmt : Unable to find the Reporting Services WMI…
asked 2020-09-15T06:11:26.357+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(124.80000000000001, 6%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Surya Se
1
Reputation point
answered 2020-09-18T03:50:50.467+00:00
Joyzhao-MSFT
15,571
Reputation points
3 answers
How to connect Power BI data to Firewall server
Hello. Data visualization is in progress through "power bi". The problem I have is. Because of a firewall on the server using the Naver Cloud Platform Importing data from "power bi" is not possible. I need to disable the…
asked 2020-09-11T07:08:49.313+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(0, 87%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
김재민
1
Reputation point
commented 2020-09-18T03:48:23.787+00:00
Joyzhao-MSFT
15,571
Reputation points
1 answer
Rendering scale of background picture in report builder.
Hi, What I'm trying to do is to align some objects to background image of main rectangle keeping everything together in report builder. Everything looks good in design view, and objects are aligned to each other using rectangles. When i run it in…
asked 2020-09-17T07:55:59.217+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(240, 32%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
I2ufu5
1
Reputation point
answered 2020-09-18T03:36:11.37+00:00
Joyzhao-MSFT
15,571
Reputation points
3 answers
One of the answers was accepted by the question author.
can a footer show data being used on the current page's tablix
hi we run 2016 enterprise and develop in vs 2017. can a footer's text boxes "see" data from the single row currently feeding the tablix which just runs a subreport? the subreport is run once per page of the master report. the footer would…
4 answers
One of the answers was accepted by the question author.
Should aggregates be created in a temp table or CTE or there is any better way of doing it ?
I want to know if aggregates should be created in a TEMP table or CTE in a SP ? The requirement is to plot aggregated data with detail dimension data . I wanted to know if I m using SSRS as the front end and SQL server 2016 as the back end .Should I…
asked 2020-09-15T15:48:58.51+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(32, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mudassar A
486
Reputation points
accepted 2020-09-17T15:41:04.55+00:00
Mudassar A
486
Reputation points
2 answers
One of the answers was accepted by the question author.
SSRS 2017 Delivery Extension Deployment
In SSRS 2008 to 2012 the code block for permissions in rssrvpolicy.config is below. Does anyone know what code block is used in SSRS 2017? <CodeGroup…
![](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(19.2, 63%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Export Header color
Hello I’ve got an expression on the Fill properties of the SSRS 2012 report header, =IIF(Globals!PageNumber<>1, "Blue", "Red") . The expression works on the report, the header on Page 1 is Red, all other pages the header is…
2 answers
One of the answers was accepted by the question author.
MSSQL2019 for Linux, The SQLServerAgent is not currently running, so it cannot be notified of this action. error:22022
My database has been installed successfully, but my service agent has been reporting errors, The service agent in my Windows database management tool is green, meaning it's on, but when I create the job, it reports an error and I've already run the…
![](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, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)