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,910 questions
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
36,111
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,731
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
36,111
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,576
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
2 answers
One of the answers was accepted by the question author.
SSRS - Color coding values based on data compare
Hi Folks: We have SSRS report (2016) with 2 columns Qty1 and Qty2 and want the record colored (red) If the Qty1 and Qty2 are matching. The Qty2 column has records in 5 decimal places and we want to round off to 3 decimal when comparing the values. I…
![](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(172.8, 67%, 26%)' 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
How to fix "Infinity" and "Nan"
I am getting "Infinity" or a "NaN" value on my expression below. Suggestions on my expression to improve it? =Sum(CDbl(IIF(Fields!Type.Value = "Charges", Fields!PatientAmount.Value + Fields!InsuranceAmount.Value, 0)))…
asked 2020-08-29T16:22:25.683+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(185.6, 8%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jeff S
1
Reputation point
commented 2020-09-04T06:52:14.15+00:00
ZoeHui-MSFT
36,111
Reputation points
4 answers
interactive sort and filter in a graph
I am very new to SQL Server Report Builder. I'm using Microsoft SQL Server 2014. My purpose for using SQL Server Report Builder is to publish up-to-date graphs for my SharePoint list. I am using SharePoint 2013. I figured out how to create my first…
asked 2020-08-18T01:47:02.903+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(204.8, 88%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Ruth Calistrat
1
Reputation point
answered 2020-09-04T01:26:47.05+00:00
Ruth Calistrat
1
Reputation point
4 answers
One of the answers was accepted by the question author.
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…
asked 2020-09-01T17:47:43.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(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
commented 2020-09-02T16:48:29.027+00:00
Pablo Porras
21
Reputation points
1 answer
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…
asked 2020-08-27T08:12:12.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(227.2, 38%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Edward Turner
1
Reputation point
commented 2020-09-02T07:53:27.843+00:00
ZoeHui-MSFT
36,111
Reputation points
3 answers
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…
asked 2020-08-28T10:27:36.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(86.4, 28.999999999999996%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
akshay kumar
1
Reputation point
answered 2020-09-02T06:16:26.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,821
Reputation points
2 answers
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…
![](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, 28.000000000000004%, 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)
1 answer
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…
asked 2020-09-01T05:08:51.723+00:00
Shivendoo Kumar
736
Reputation points
answered 2020-09-01T07:09:11.54+00:00
Joyzhao-MSFT
15,576
Reputation points