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,869 questions
5 answers
One of the answers was accepted by the question author.
SQL Server Reporting Services -- Deploying report fails -- The operation has timed out
HI All, I am getting an error today that I have not received before. When using Visual Studio to deploy a report to my SSRS 2017 Report Server, I am getting the error "The operation has timed out." I am using SSDT and Visual Studio…
![](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, 1%, 23%)' 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)
1 answer
One of the answers was accepted by the question author.
SSRS - STORED PROCEUDURE WITH TABLE VALUED PARAMETERS
Hi, How can we use Stored Procedure with Table Valued Parameter in SSRS Dataset ? CREATE TYPE DBO.MultiFilter AS TABLE ( filterVal VARCHAR(200) ) CREATE PROCEDURE DBO.USP_multiFilterTest @position DBO.MultiFilter READONLY …
asked 2020-08-19T09:59:25.577+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(300.8, 28.000000000000004%, 39%)' 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)
Srinivasa Rao Chigulla
46
Reputation points
commented 2020-08-21T18:29:45.693+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, 34%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Allen M
11
Reputation points
1 answer
One of the answers was accepted by the question author.
Lookup do not bring amount
Hello There I have to datasets one for expenses and one for revenues, it is partially working because the lookup is bringing one value from the datasource therefore I am out balance. The money is sitting there but my lookup is not bringing both…
![](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, 49%, 18%)' 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)
1 answer
Type of reports
We are considering getting our teachers (55 teachers) to set weekly homework via Microsoft Teams. As I am in charge of homework, is there a way for me to see (run a report/analysis) who has set homework across the organisation. We currently have this…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,584 questions
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,869 questions
asked 2020-08-12T15:38:54.57+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, 62%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
D Samuel
1
Reputation point
commented 2020-08-21T09:53:40.837+00:00
Sharon Zhao-MSFT
25,081
Reputation points Microsoft Vendor
2 answers
Change Offset of bars in a ranged bar diagram
Hi there, I am using MS Report Builder 2014. Is there a property or other way to change the vertical offset between bars in a range bar diagram? This is how it currently looks like: And thats how I would like it to look like (I would…
asked 2020-08-19T09:12:20.043+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(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)
klaus6001
41
Reputation points
commented 2020-08-21T09:19:12.377+00:00
ZoeHui-MSFT
35,381
Reputation points
5 answers
One of the answers was accepted by the question author.
Enquiry about Queries for SRSS
Hello everyone, I write my problem here because I tried everything that I could, and I don't find a way to make what I want. I need to make a report, for this, I'm using Microsoft SQL Server Report Builder to prepare Tables and Queries. Here…
asked 2020-08-19T14:50:34.277+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(12.8, 62%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFP%3C/text%3E%3C/svg%3E)
fabien prieur
41
Reputation points
commented 2020-08-21T05:15:26.003+00:00
fabien prieur
41
Reputation points
1 answer
Why SSRS report parameter not considering float values after selected the data type as float, when we pass values at preview level.
Why SSRS report parameter not considering float values after selected the data type as float, when we pass values at preview level.
asked 2020-08-20T09:04:41.677+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(233.6, 68%, 32%)' 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)
Sathish
1
Reputation point
answered 2020-08-21T02:23:01.233+00:00
Joyzhao-MSFT
15,571
Reputation points
1 answer
How to use lookup() to bring a value from another dataset into a tablix
I have two datasets that include the fields branch and sales. I using dataset1 for the rest of the table, but for one cell I want the sum of sales from dataset2. I want this to be included in the branch row group using the field from dataset1. So I used…
asked 2020-08-17T07:08:40.137+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
commented 2020-08-18T02:56:01.017+00:00
ZoeHui-MSFT
35,381
Reputation points
3 answers
Power BI paginated report on a local Power BI server to publish on Share Point online
Hi, I have a paginated report on a local Power BI Server. It works fine. I want to show this report on a Share Point Online page as a web part. I am getting an error regarding the URL of the report that it is not valid. All the examples that I…
asked 2020-08-04T09:16:38.153+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(163.2, 63%, 25%)' 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)
Sedso
1
Reputation point
answered 2020-08-07T06:32:58.497+00:00
ZoeHui-MSFT
35,381
Reputation points