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,799 questions
2 answers
Only fields from the current dataset can be added
I'm getting the error. "Only fields from the current dataset can be added". I'm trying to add BILL_ID and it DOES exist in the current dataset assigned to the table. Please help.
asked 2021-04-09T16:53:51.457+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(131.20000000000002, 27%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Steve Griffin
1
Reputation point
answered 2021-04-12T01:43:36.983+00:00
ZoeHui-MSFT
32,821
Reputation points
2 answers
One of the answers was accepted by the question author.
How do I get rid of this authentication prompt?
Hi, I am getting this prompt every time I try to access reports -a week ago I was not being prompted . What can I do to allow access without having this prompt ?Please help urgently.
asked 2021-04-11T14:14:46.79+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(80, 89%, 17%)' 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)
Rubina Akter
21
Reputation points
answered 2021-04-12T01:35:33.61+00:00
ZoeHui-MSFT
32,821
Reputation points
1 answer
One of the answers was accepted by the question author.
rs.exe script to deploy all reports from one folder
Hi What is the simple rss script to upload all the reports in my local folder in one time to SSRS server using RS.exe command? My sql server version is 2012
asked 2021-04-06T08:03:09.803+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, 90%, 21%)' 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)
arielman2304
676
Reputation points
commented 2021-04-11T10:53:11.46+00:00
arielman2304
676
Reputation points
1 answer
Post SSRS 2012 to 2016 migration, Excel rendering of large reports is very slow
We recently migrated from SSRS 2012 to SSRS 2016. We have a few large reports ( 45 - 74 columns that typically returns 30k - 100k records), that took up-to 1 minute to render to Excel on the 2012 SRRS server, but is now taking 6+ minutes to render on…
asked 2020-12-30T15:45:55.547+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, 18%, 33%)' 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)
yferguson1
1
Reputation point
commented 2021-04-09T16:10:03.33+00:00
yferguson1
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Dynamic report subscription
HI Team, I am trying to create a report and subscribe that can generate separate output for each of the value in the parameter/something. Like I want to generate report (through subscription) output for each state dynamically. Please guide me to…
![](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, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
SSRS 2017 Subscription issue
Hello All, We have ~500 reports in SSRS 2008. Recently we migrated all the reports to SSRS 2017. After the migration, we noticed, subscription / Scheduling not working. In the SQL logs we noticed, the reports are shown as successful. But no outputs…
asked 2021-04-07T15:44:25.487+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(316.8, 52%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kirubakara Senthil Kumar S
191
Reputation points
commented 2021-04-09T01:30:04.997+00:00
Joyzhao-MSFT
15,566
Reputation points
3 answers
One of the answers was accepted by the question author.
Error installing Report Viewer in Visual Studio 2019, my project structure is incompatible.
When installing Report Viewer in Visual Studio 2019, it gives the following error: "The package 'Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1449.0' was restored using '.NETFramework, Versão = v4.6.1, .NETFramework, Versão =…
SQL Server Reporting Services
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,799 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,570 questions
asked 2021-04-07T14:39:14.13+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(166.4, 17%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Emerson Medeiros
21
Reputation points
answered 2021-04-08T17:16:35.647+00:00
Emerson Medeiros
21
Reputation points
3 answers
Is Microsoft report builder free for use?
Good time of day to everybody. Is Microsoft report builder downloadable by link (https://www.microsoft.com/en-US/download/details.aspx?id=53613) free for use? Should I have additional licensed software to use it if i have access to SQL Server Reporting…
asked 2020-10-26T18:37:12.713+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(288, 36%, 37%)' 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)
Yasander
1
Reputation point
commented 2021-04-08T15:26:01.64+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(105.60000000000001, 96%, 20%)' 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)
Vance Smith
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Is it possible to deploy only reports which were changed using RS.exe?
Assuming I have 20 rdl files and I modified just one, is it possible in the deploy process to overwrite just this file instead the whole 20 in the SSRS server using RS.exe and VB.NET file?
asked 2021-04-06T11:20:05.967+00:00
arielman2304
676
Reputation points
accepted 2021-04-07T07:02:12.827+00:00
arielman2304
676
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server - Report Server Schedule
I am working in the SQL Server Enterprise (2019) - Power BI Report Server to create a shared schedule. I can't seem to find the documentation on the Schedule Details within Site Settings. I found the schedule properties (general page) but that…
![](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(22.400000000000002, 49%, 12%)' 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)
2 answers
One of the answers was accepted by the question author.
dynamic columns with accumulated sum - tricky tricky
at the first image is what I have now: on rows i have calendar quarters where each row contains claims (like auto insurance claims) that happened that quarter (Date of Loss) on columns I need say 12 quaters of Payment Date (DoR dimension) …
asked 2021-04-03T13:18:40.303+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, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGL%3C/text%3E%3C/svg%3E)
greg lipman
61
Reputation points
answered 2021-04-06T12:42:26.667+00:00
greg lipman
61
Reputation points
2 answers
One of the answers was accepted by the question author.
Install Dynamics 365 Report Author Extension - Failing
Hello. I have a new computer, and I'm trying to install Dynamics 365 Report Author Extension. I have Visual Studio 2015. I get an error when trying to install the extension - that something in the environment is missing. No details are available,…
asked 2021-04-06T09:44:09.393+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(137.6, 69%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gittel Marcus
21
Reputation points
answered 2021-04-06T11:56:08.853+00:00
Gittel Marcus
21
Reputation points
2 answers
Free Form Field in SSRS
I'm using a SQL Query to display results in SSRS...I have no problem doing that. But, I want to create a text field in the same report, that a user can enter a value in to perform a calculation. So for example, the SQL query brings back the following…
asked 2021-03-31T18:37:03.67+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(134.4, 46%, 23%)' 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)
RedSoxRay
1
Reputation point
commented 2021-04-06T02:26:03.453+00:00
Joyzhao-MSFT
15,566
Reputation points
1 answer
SSRS in Sharepoint: Report in iFrame fails to export
The report renders correctly in the iFrame, but selecting to Export (to any format) using the 'Export' functionality, I get a popup saying 'Server busy This action cannot be completed because the other program is busy. Choose Switch To ....' I tried…
asked 2021-03-25T15:05:12.303+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, 51%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENL%3C/text%3E%3C/svg%3E)
Natalie LLoyd
21
Reputation points
commented 2021-04-05T08:42:10.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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,816
Reputation points
1 answer
One of the answers was accepted by the question author.
How do I put a hyperlink to an item in a report?
Good afternoon. You need to put hyperlinks to the elements in the report in the column. Moreover, the link should change depending on the text in the cell. That is, hyperlink = the first part of the hyperlink + ID + the second part of the hyperlink.
asked 2021-04-02T06:57:06.267+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(128, 69%, 22%)' 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)
Konstantin
41
Reputation points
commented 2021-04-05T08:11:10.277+00:00
ZoeHui-MSFT
32,821
Reputation points
1 answer
Parameter not being refreshed.
I have a parameter Y that is supposed to get refreshed according to the values set in parameter X which is fetching values from a query and is single select value. My issue is that it is getting the values properly the first time but when the X…
asked 2021-02-23T04:40:29.4+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(195.2, 28.000000000000004%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ashwin Shyam
1
Reputation point
commented 2021-04-05T04:58:08.22+00:00
Ashwin Shyam
1
Reputation point
1 answer
How to fix SSRS 2019 Report Viewer Control Issue with IE 11 not showing icons
My team is upgrading SSRS from 2014 to 2019. Our ASP.NET application integrates with SSRS using Report Viewer controls and we therefore have upgraded these controls to be the 2019 version. In our testing we find it works well with modern browsers…
asked 2021-03-26T14:13:16.87+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(268.8, 15%, 36%)' 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)
MacDonald, Christopher
1
Reputation point
commented 2021-04-02T08:35:29.7+00:00
Joyzhao-MSFT
15,566
Reputation points
1 answer
PolyBase Error .
From last 2 days ...,scratching head for this problem . funny part ... in afternoon hours this gets executed successfully .., while in evening hours the same file when we create and try to select external table . it gives this problem . 105083;The…
asked 2021-04-01T18:11:36.54+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, 74%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rakesh Dhar
96
Reputation points
answered 2021-04-02T06:16:57.813+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
4 answers
Reporting on Data that isn't there
I have a report that will report the data from a sql script but need a way to add data to the query when the date parameters go beyond present data. For example, If I query a date range of 9/1/2020 to 11/30/2020 but there is no rows past 10/31/2020 I…
asked 2021-03-31T12:49:45.267+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(179.20000000000002, 53%, 27%)' 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)
InspiredUser33157
216
Reputation points
commented 2021-04-02T06:05:40.523+00:00
ZoeHui-MSFT
32,821
Reputation points
1 answer
One of the answers was accepted by the question author.
report builder - expression query with filter and parameter
Run is not happy with [Dim Policy].[Pol Eff Date].CurrentMember.MemberValue >= Parameters!FromPolEffFullDate.Value when I change to [Dim Policy].[Pol Eff Date].CurrentMember.MemberValue >= CDate('1/1/2017') it works Parameter I tried…
asked 2021-03-31T07:36:07.37+00:00
greg lipman
61
Reputation points
accepted 2021-04-01T07:59:53.377+00:00
greg lipman
61
Reputation points