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,855 questions
2 answers
One of the answers was accepted by the question author.
Why am I being prompted to define query parameters for my dataset?
Why am I being prompted to define query parameters for my dataset when I select "Refresh fields"? It is simply calling a stored procedure.
![](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(147.20000000000002, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
adobe saves report incorrectly
Hi after some work, my subreport which is just one rectangle enclosing various "sub" rectangles etc looks beautiful when saved to word. But ridiculous when saved to pdf. the first sub rectangle prints on pg 2 out of order after the 2nd…
![](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(41.6, 70%, 14%)' 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.
403 error from app requesting report rendering
hi i'm geting particulars on the calling app but a peer of mine trying to render my report from his app got the following error. i reached out to him to determine if he entered the ssrs report directory correctly but if the community can offer insight…
1 answer
SSRS 2016 allows the display of sensitive parameter in its URL such as Session state token
SSRS 2016 allows the display of sensitive parameter in its URL, such as Session state token. This can be used to manipulate the data being displayed allowing other resources information be visible to other users.
asked 2020-08-20T09:17:11.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(140.8, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Ismael González Briongos
1
Reputation point
commented 2020-08-25T08:58:36.64+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
Vulnerable and outdated Jquery and bootstrap version (Integrity)
SSRS 2016 uses vulnerable Jquery 3.3.1 and Bootstrap 3.3.5. A security assessment found that an attacker may use the vulnerable JavaScript framework version to perform malicious attacks. Assessment suggestion for remediation is patching or update to…
asked 2020-08-20T07:38:43.74+00:00
Ismael González Briongos
1
Reputation point
commented 2020-08-25T08:58:17.857+00:00
ZoeHui-MSFT
34,836
Reputation points
1 answer
Help creating a Report that Combines output of 2 tables and a Query
I'm not sure if this is even possible but wondering if anyone has any advice to help see if? Current doing this in Report Builder 3 I'm hoping to have a report out put something kinda like the below The goal is based on two other tables and…
asked 2020-08-18T05:02:27.477+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, 57.99999999999999%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Joshua Reynolds
1
Reputation point
commented 2020-08-25T08:56:46.123+00:00
ZoeHui-MSFT
34,836
Reputation points
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,495 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,855 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
34,836
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
34,836
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
34,836
Reputation points