Questions tagged [Microsoft SQL Server Reporting Services] (15)

3
answers

How to inspect code in the drop down menu?

Throw ideas like code inspector (F12) to view the css classes for dynamic menus and selectors :hover. The menu is just hidden. If it is important then this is the page of reports in SSRS drop down menu format. A little add. The basic idea was to change this drop-down menu called "SharePoint branding". Result code received ...
1
answer

MS SQL Reporting Services — monitoring activity — how/what?

Hello! Is 2017 MS SQL Reporting Services. He pulled a lot of reports from different systems. Periodically in the logs it is evident that some of the systems create a large number of queries The report server has detected a possible denial of service attack. The report server is dropping requests for service from the IP add...
neoma.White asked March 24th 20 at 12:02
0
answer

How to set rights to the folder or report in Microsoft Report Manager, using t-sql?

Good time of day. Tell me how to set permissions for the folder or report in Microsoft Report Manager using the request. I understand the algorithm of actions like this: 1. Read by user(s) ID 2. Collect policyID 3. Used this policyID need the directory or report Skill is not enough, who can already faced such problem?
1
answer

The use of the WSDL from SSRS

Arose the next problem. Is there a web service example.ru/WEB/Service.asmx He has a method svcMethod and 3 of the input parameter. I created a DataSet, where the source data XML. According to the guides online have set up an appeal to the service.<query> <method name="svcMethod" namespace="http://tempuri.org/">...
alfonso_Dooley asked October 2nd 19 at 16:46
2
answers

Is it possible to run SSIS package from SSRS?

Good day! Is it possible to run SSIS package through report in SSRS? Found here such method of running the package, but as you can see, it uses a running Job on the server, which of course out, but it would be different.
2
answers

How to optimize nested queries?

There is a large report consisting of queries likeRevision as (Select Registrations.new_studentid, Registrations.New_StudentIdName, Filteredcontact.new_accanumber, Registrations.new_attendancepercent, FilteredNew_Event.New_CourseTypeIdName, FilteredNew_Event.New_SessionId, FilteredNew_Event.New_SessionIdName, FilteredNew_Co...
kathryn_Nien asked September 15th 19 at 14:41
2
answers

How to get rid of hang Studio at the "updating fields" in the DataSet?

Trying to do a report with lots of fields and one parameter from the stored procedure. When you create a Studio dataSet hangs tightly. If you specify explicitly what fields are updated.
Einar.Herzog asked September 15th 19 at 07:36
1
answer

Error sending messages in SSRS report server. What to do?

Problem with SMTP server? Either in the configuration of SSRS? Trying to configure the report server SSRS MS in order to send emails via SMTP. Server-side reports have tried everything found in the Internet options but still in the logs when sending a get the message "ERROR: Error sending email. Exception: System.Net.Mail....
Elsie.Strom asked September 13th 19 at 15:35
2
answers

How to add a parameter in the Data Set in SSRS? Need A Dynamic Dataset?

Suppose there is 2 table - tName , tCode In the SSRS report, the user can select what he wants to see - Name, Code How to make the Dataset dynamically changing a request under this option? Trying so, but swears on an error in the request (no details, logs not available): =SELECT * FROM [dbo].[t" + Parameters!version.Value...
kaylah_Dickinson asked August 19th 19 at 22:33
2
answers

How to get data from another server request?

Hi all. Just started working with SQL Server and was faced with the task of obtaining data from another server. Have your server, which will be laid a certain design logic. And you want to query data from tables which are daily updated on the other server. Please tell me how can I get data from another server?
nikita.Stracke asked August 8th 19 at 14:28