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,818 questions
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
33,386
Reputation points
2 answers
SQL alwayson sometime not syn data between primary and standby
Hello Everyone I have two SQL instances running on Window Server 2016 Standard, SQL cluster having 2 Node without shared storage. SQL sever version is running on SQL 2016 Enterprise. But I got issue 3 times ready for data between DC and DR not…
asked 2020-08-29T06:35:19.717+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(19.2, 57.99999999999999%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vuthy M
1
Reputation point
commented 2020-09-04T03:37:34.507+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,606
Reputation points
1 answer
SSAS: Server: The current operation was cancelled because another operation in the transaction failed.
Hello, I'm creating dimensions in SSAS and I was successful with the two other dimensions tables but only this one is giving me an error when processing it. the error is Server: The current operation was cancelled because another operation in the…
asked 2020-08-29T04:43:42.787+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, 27%, 29%)' 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)
Sam332
21
Reputation points
commented 2020-09-04T02:49:12.917+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
0 answers
MDX - filtering measure values
Hi everyone, I created a role in SSAS. I denied the dimension customer data which works fine. But what can i do if i want to denied the cell data (I mean the total measure values) for every customer except the customers with the ID 10000 and 11000? I…
asked 2020-09-03T17:37:02.723+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(291.2, 2%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E_%3C/text%3E%3C/svg%3E)
_MG_
1
Reputation point
commented 2020-09-04T02:35:26.59+00:00
Lukas Yu -MSFT
5,816
Reputation points
2 answers
One of the answers was accepted by the question author.
How to check the TFS SSIS version with MSDB SSIS version ? | SSIS2014| TFS
How to check the TFS SSIS version with MSDB SSIS version ? We have all ssis 2014 packages deployed on SSIS server . Now we need to check if they SSIS packages have the same version as TFS version. Is there way to query them together to see the data…
asked 2020-08-18T13:57:26.513+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
481
Reputation points
accepted 2020-09-04T02:12:12.747+00:00
Mudassar A
481
Reputation points
3 answers
Review tool to check security risks, code review
Hi. Is there a Microsoft recommended review tool to check security risks, code review for SQL, SSIS? Thanks
asked 2020-09-02T12:02:02.857+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(291.2, 16%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
venkatesh padmanabhan
181
Reputation points
answered 2020-09-04T01:29:18.783+00:00
m
4,271
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
3 answers
One of the answers was accepted by the question author.
Concurrency question
Hi, I need to make sure that 2 connections to the table never get the same id for processing... For example: create table dbo.concurrency(id int identity, task varchar(80), status varchar(80)) go insert dbo.concurrency(task, status) values('task…
asked 2020-09-02T22:52:17.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(307.2, 68%, 39%)' 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)
Ed
41
Reputation points
commented 2020-09-04T01:20:07.593+00:00
Cris Zhan-MSFT
6,606
Reputation points
3 answers
SQL Server 2019 Software Assurance
Can we upgrade SQL Server 2014 ENT Edition to SQL Server 2019 ENT Edition under Software assurance. Hope we can upgrade only DBENGine, SSIS, SSAS and SSRS .
asked 2020-09-02T08:31:14.88+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(76.8, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Doddasiddavannahally, Pradyothana
41
Reputation points
commented 2020-09-04T01:07:22.293+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Restoring Backup from Block Blob
Hello, we're using SQL 2017 Enterprise on a 3 nodes AG cluster and successfully backing up our databases to our Azure storage blob using a SAS token. We're uploading as a block blob as expected and can restore that DB to a single server in the AG…
asked 2020-09-03T12:51:59.72+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, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKE%3C/text%3E%3C/svg%3E)
kevin eckart
26
Reputation points
accepted 2020-09-03T21:15:23.15+00:00
kevin eckart
26
Reputation points
4 answers
One of the answers was accepted by the question author.
SSIS/SSAS: How to change only the table name without remap the columns, flows and dimensions?
Hi, My company asked me to change the name of some of my SQL Tables( Dimensions ). But the only way that I know to do that is delete the references to the old table and map them again and recreate the OleDBSource/OleDBDestination ( SSIS ) and recreate…
asked 2020-09-01T13:36:21.613+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, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Luis Lima
61
Reputation points
commented 2020-09-03T19:04:56.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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
25,201
Reputation points
2 answers
One of the answers was accepted by the question author.
Creating a cluster with two nodes and a DR in Azure
Hi, I've read some blogs that in scenarios like this say that the recommendation is to change some timeout delay settings in the cluster to avoid false positives. Is there any configuration at the faiolver level or something else that I should worry…
3 answers
SQL Server Always On Listener IP for Async Nodes??
Hello Team, How can I connect to an Async node using the Listener IP or Listener DNS in an Always on architecture (SQL Server 2016)?? Node1 - Primary Node2 - Secondary (Sync) Node3 - Secondary (Async) Our API's connect to Node1 and Node2 using…
asked 2020-09-02T13:18:44.733+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(19.2, 2%, 11%)' 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)
Ashif Shaikh
156
Reputation points
commented 2020-09-03T13:24:23.57+00:00
Shashank Singh
6,246
Reputation points
1 answer
Table replicate using SSIS
Hi, I'm trying to replicate few tables from a Source DB to destination DB. Both Databases are sql server databases. The only issue is that the source DB gets refreshed from production DB backup every night which breaks its replication to the…
asked 2020-08-31T06:54:58.88+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(144, 68%, 23%)' 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)
Sherwin Rodrigues
1
Reputation point
commented 2020-09-03T09:56:49.397+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(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
4 answers
Fixing an Instance of SQL Server 2014 - After Cleanning up some duplicte files.
Hi Folks, This is my first time using this forum. I regularly use the C# Forum. The question is: I recently used the CCleaner to sweep out some duplicate files in my notebook, and of course there was a lot of them of all kinds, included SQL Server, and…
asked 2020-08-27T01:55:39.787+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(118.4, 14.000000000000002%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFV%3C/text%3E%3C/svg%3E)
Flávio Rocha
21
Reputation points
commented 2020-09-03T07:21:27.4+00:00
m
4,271
Reputation points
2 answers
What is the impact of setting ASPaaS\AlwaysUseGateway to false
HI all everybody, this is my first post and I'm here to ask for your help. This is the scenario on my Team: Client - Visual Studio 2019 connecting to AAS deploy using a server of IaaS as data source - issue And they sent me this image…
asked 2020-08-28T02:09:22.31+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, 17%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
CuervoXok
1
Reputation point
commented 2020-09-03T04:19:21.907+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(108.80000000000001, 9%, 20%)' 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)
HarithaMaddi-MSFT
10,136
Reputation points
6 answers
Query slow on SQL 2019
There is one specific query that has been executed on MS SQL 2014 for long time. The query is running on AG secondary RO replica. The query execution time on MSSQL 2014 is about 5 seconds. After migration to MSSQL 2019 the same query is running about 5…
asked 2020-09-01T09:37:21.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(153.6, 35%, 24%)' 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)
Vadim Sudenko
1
Reputation point
answered 2020-09-03T01:27:57.267+00:00
m
4,271
Reputation points
5 answers
Configure DB alert
Hello, I am configuring alert for Prodcution databases. I want to get any error message appearing in SQL Server Error log. But while defining the alert it is showing 2 options Error No Severity Pls suggest
![](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, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
4 answers
Create user to access Alwayson readonly databaes
Hi Our env sql server version is 2016 SP2 EE edition always on enabled. So when we create database user for access the report though link server(expected to connect readonly replica databases ) from other remote node then I I noted permission(DB…
asked 2020-08-25T00:38:01.14+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, 42%, 30%)' 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)
Ashwan
521
Reputation points
answered 2020-09-02T22:14:06.857+00:00
Edwin M Sarmiento
256
Reputation points
3 answers
How does one migrate system databases from an old SQL Server 2012 to a new SQL Server 2017?
How does one migrate system databases from an old SQL Server 2012 to a new SQL Server 2017?
![](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, 40%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)