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,878 questions
1 answer
SSRS 2019 Product version not matching
The latest Microsoft SQL Server 2019 Reporting Services has version 15.0.7545.4810 but after installation, Report Server Configuration Manager shows the Product Version as 15.0.1102.861. Not sure if this is expected or the download link is pointing to…
asked 2020-09-16T02:48:05.49+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, 98%, 31%)' 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)
Kumar
1
Reputation point
answered 2020-09-16T04:08:15.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(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,821
Reputation points
1 answer
Trying to speed up SSRS report with multiple stored procedures
I have a report which displays data for each store, and store-specific subreports. Within the subreports there are 10 stored procedures for each of the 10 components of the report. So because each subreport is store-specific, the 10 stored procedures in…
asked 2020-09-15T08:09:32.197+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(256, 31%, 34%)' 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)
meddojeddo
1
Reputation point
answered 2020-09-16T02:02:01.363+00:00
Lukas Yu -MSFT
5,821
Reputation points
1 answer
One of the answers was accepted by the question author.
SSRS Report History Snapshot not showing after updating report
Hi, I've updated my SSRS report (I've replaced the .rdl file with the updated one) but now the history snapshot is empty. Old snapshots are gone. Is this normal when you update a report? Thanks in advance.
![](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, 96%, 24%)' 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)
1 answer
One of the answers was accepted by the question author.
Free Space in DataBar
Hi, I am using ReportBuilder 2014 and a Databar->DataColumn->Bar I want to get rid of the free space on the left and right of this data bar When I change the columns width, the databar itself gets cut, so this does not work.…
![](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(278.4, 62%, 36%)' 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)
1 answer
Can anyone help me improving the performance of the query in a better way?
I am using below query as a dataset to fetch a document body and some other details to print on a SSRS report. This query is consuming more time than expected to execute. Can anyone help me with a better way to optimize the query. Any help is greatly…
asked 2020-09-15T04:57:22.197+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(192, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Srinivas Kamutam
1
Reputation point
answered 2020-09-15T05:49:03.833+00:00
MelissaMa-MSFT
24,191
Reputation points
3 answers
One of the answers was accepted by the question author.
Fixed width in vertical data bar
Hi, I am using sql report Builder 2014. I try in a vertical data bar, with dynamicly visibility of amounts of bars, to fix the width of the bars to be the same. I know the amount of bars in each data line, so can someone tell me where in…
1 answer
SSRS initial load refreshes
Hello, I have a 44 inch wide report that flashes multiple times when loading in IE. It eventually stops but I have never seen this behavior before and don't know how to correct it. I have interactive height = 0 because I want it to render all on one…
asked 2020-09-10T17:02:06.03+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(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Linda
1
Reputation point
commented 2020-09-14T02:30:43.387+00:00
Joyzhao-MSFT
15,571
Reputation points
3 answers
SCSM - Unable to access Reporting Services
We're installing System Center Service Manager and the only service that seems to be non-functional is the Reporting section. When I launch SCSM I get the error: The Service Manger data warehouse SQL Reporting Services server is currently unavailable.…
asked 2020-09-02T00:49:07.447+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, 70%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJW%3C/text%3E%3C/svg%3E)
Jeremy Watkins
1
Reputation point
answered 2020-09-13T18:01:56.07+00:00
Andreas Baumgarten
104.1K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Value is not displaying for a new field in existing RDL
Here with attached a RDL. We added a new column "Consultation medium" in the existing report. The value in this column displays, when the dataset returns value in the first row. At the same time, when value is not having the first row in…
asked 2020-09-11T08:12:56.583+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(310.4, 48%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesan, Geetha
96
Reputation points
accepted 2020-09-11T10:27:51.957+00:00
Ganesan, Geetha
96
Reputation points
2 answers
One of the answers was accepted by the question author.
SSRS - how to use a percentage allocation in report builder
I have been working with a SSRS matrix report using report builder to report costs amongst the various business units. I developed a hierarchy for the column grouping based on the business unit. I have a row grouping based on the Acccount number and…
asked 2020-09-09T21:24:50.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(256, 76%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
littlehelp
21
Reputation points
accepted 2020-09-10T12:21:47.647+00:00
littlehelp
21
Reputation points
7 answers
One of the answers was accepted by the question author.
How to split a string into two different fields in SQL server
Hello Everyone, I have a scenario where i need to divide a string from one column to two different columns in sql server. example: input is: COL 1 sql 13434 test 39480 sql2 39 tests 39 data 123 tests 4587 output should be: COL 1 …
![](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, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
1 answer
SSRS 2014 SMTP settings
My server has been emailing reports from SQL fine but changes to O365 seem to have caused it to stop accepting mail without authentication via username and password. SSRS 2014 does not have settings for this in the Configuration Manager and the…
asked 2020-09-07T15:22:19.473+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, 27%, 29%)' 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)
Calum Morrison
116
Reputation points
commented 2020-09-09T08:42:55.997+00:00
ZoeHui-MSFT
35,556
Reputation points
3 answers
Finding a program similar to Crystal Reports (used by VB6)
Hi! Not really sure about all the functionality Crystal Reports brought to the table, but it seems that it was in heavy use during the 90's - I do not know that status of this tool today. I am taking over an old VB6-application using Crystal Reports,…
asked 2020-09-02T09:13:46.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(102.4, 14.000000000000002%, 19%)' 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)
Inkimar
1
Reputation point
answered 2020-09-08T17:55:53.56+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(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips
17,721
Reputation points
1 answer
One of the answers was accepted by the question author.
Is it possible to have a link in SharePoint online to a dynamic report from an on-site SQL database?
I am seeking to use an existing SQL report to interrogate an on-site database but this be done from a SharePoint online interface, is this possible? If so, what is the architecture required to achieve this within the O365 tenant security bubble? TIA, …
asked 2020-09-07T16:23:18.033+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(83.2, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Duncan Fisher
21
Reputation points
accepted 2020-09-08T10:15:36.86+00:00
Duncan Fisher
21
Reputation points
1 answer
One of the answers was accepted by the question author.
SSRS 2017 reports loading slow on first time
Hi, i have created SSRS reports and Query which i am using in particular SSRS report is fetching data immediately.when i try to run any report first time it is taking more time when i run the same report 2nd or 3 rd time it is loading immediately.is…
asked 2020-09-07T05:57:41.94+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(38.4, 51%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
venkateswararao
21
Reputation points
accepted 2020-09-08T06:50:58.277+00:00
venkateswararao
21
Reputation points
2 answers
SSRS: Keep together ignored when generating von docx reports
Hello, we have problems creating docx documents with SSRS. The main report contains several subreports. One of the subreports contains of a tablix with some textboxes (as headlines) and another subreport for the details. The inner subreport…
asked 2020-09-01T07:13:58.99+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(115.19999999999999, 11%, 21%)' 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)
Schulz, Grischa
1
Reputation point
commented 2020-09-08T01:53:30.56+00:00
ZoeHui-MSFT
35,556
Reputation points
3 answers
SSRS - Unable to Hide Rectangle with CountRows Expression
Greetings! I'm trying to hide a rectangle based off on how many rows exist in a dataset but it's indicating that the Hidden Expression has an error. I know it's complaining about security permissions, but I'm pretty sure that is a false flag since…
asked 2020-09-02T22:28:22.257+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(112.00000000000001, 1%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
Underwood
1
Reputation point
answered 2020-09-07T10:11:06.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(102.4, 90%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Farhan Ahmed
1
Reputation point
2 answers
Hide dynamically a tablix in SSRS
Hi, I have a SSRS report with 2 tables. There are kind of the same except one has summary data and the other one has details. I am trying to display one table at a time. Basically, when we launch the report, we should only see the summary table. …
asked 2020-09-03T18:37:50.84+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, 53%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Bola Razaki
1
Reputation point
answered 2020-09-07T02:47:51.257+00:00
Joyzhao-MSFT
15,571
Reputation points
2 answers
Have Report Builder forget saved credentials
Using Report Builder 3.0 for SQL Server 2014. I need to have it forget some user credentials forgotten when connecting to a report server. I have tried deleting the user config file, the clear all recent item lists option, and uninstalling and…
asked 2020-08-17T15:56:02.537+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, 8%, 14%)' 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)
Andrew
1
Reputation point
commented 2020-09-04T16:29:28.28+00:00
Brenda Stewart
96
Reputation points
2 answers
One of the answers was accepted by the question author.
Having issues with a function to change a parameter value.
I have 2 parameters coming in - one has a job number that has to be reformatted and updated to the other. I wrote a function to do the format because nothing I tried in the expression for the second parameter worked. Well, it's still not working. The…
asked 2020-09-03T20:49:18.04+00:00
Brenda Stewart
96
Reputation points
accepted 2020-09-04T15:09:19.373+00:00
Brenda Stewart
96
Reputation points