Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
592
questions
1
vote
2
answers
8k
views
Error while trying to create a database for SSRS
I have installed SQL Server Reporting Services 2017, and my database engine is developer edition 2017. Now, while trying to configure SSRS from its Configuration Manager I get this error
I have found ...
- 2,132
1
vote
1
answer
46
views
Validity period of an open ssrs report
We have SSRS 2008 r2 rdls. I open an SSRS report and keep it open in my browser for more than 30 mins. If I now click any drill downs either through an action or go to report. I don't want the report ...
1
vote
0
answers
442
views
How to improve performance of SSRS report using Cubes as data source?
I am trying to build an SSRS report with SSAS as the data source. It has 4 cascading parameters. I used the SSRS Query designer to generate MDX because I am not very familiar with Cubes/MDX.
It works ...
- 11
1
vote
1
answer
2k
views
Migrate SSRS Reports to Power BI Report Server
I have to servers: one with the SSRS Report Server and a second server with the Power BI Report Server.
The issue is I'm trying to migrate the SSRS Reports to the Power BI Report Server instance on a ...
- 145
1
vote
1
answer
133
views
Same SSRS report, two different subscription names
I would like to know how to change same SSRS reports from one subscription name to two different “from” names?
- 19
0
votes
1
answer
267
views
Redirecting Report Server connections using host file
I am connected remotely to a server called New_Server and trying to connect to the Report Server which is installed on it by referring to another server:
I've changed the host file on NEW_SERVER to ...
- 711
0
votes
1
answer
172
views
SSRS and DBA Scope
Just a quick questions regarding DBAs, recently I was asked about the scope of DBA in terms of SSRS and BI, in your experience who handles and maintain/configure your SSRS, is this part of the DBA or ...
- 31
0
votes
1
answer
621
views
SQL Server account permissions for New ReportServer database from wizard
I'm trying to create a ReportServer database on a different server (Server_AT) other that my Reporting Service server (Server_RT).
ON Server_AT, I created the RSExecRole as per the script here. Then ...
- 105
4
votes
2
answers
8k
views
Migration from SSRS 2012 to SSRS 2017
Our company is moving from SSRS 2012 to SSRS 2017. I would like to know if anyone has done a similar migration. If yes, could you please guide me through the steps?
From what I read about the ...
SSAS developer
2
votes
2
answers
778
views
SSRS- database and Report Server - can they be different?
I have inherited a few database servers. I am currently planning for a Server upgrade, but this DB server has a ReportServer and ReportServerTempDB database in it.
When I open Reporting Service ...
- 105
0
votes
0
answers
463
views
SQL Login for SSRS Reports require EXECUTE permissions?
Recently my team did a SSRS report deployment.The reporting server was installed in application server and it was pointed to database server.I don't know why we do like that?Probably to avoid load on ...
- 1,315
1
vote
1
answer
188
views
SSRS 2016 on SQL Server 2014
I have question about using SSRS 2016 on SQL server 2014
First of all, I don't have much experience with Reporting services.
Company use SQL server 2014 and they have SQL database on it (DB is ...
0
votes
1
answer
25
views
SSRS table populating data into a field that should be blank
I am having trouble resolving an issue. I have a table on an SSRS report. The query for the table gets the definition, the total count of that definition and calculates the percentage of all the ...
- 95
3
votes
1
answer
73
views
Steps involved in configuring SQL Server and its components after server is renamed
I have a cloned (duplicate) server with SQL Server on it and the server name had to obviously change once it was copied. This article describes two actions to perform:
using below code to manually ...
- 711
1
vote
1
answer
408
views
SSRS Reports Blank on Zebra Printer
I need assistance getting labels to print from SSRS 2014 to a Zebra GK420D direct thermal label printer. The labels show up when running the report but when I print them to the label printer, all that ...
- 97
0
votes
1
answer
7k
views
Migrating SSRS from SQL Server 2012 to 2016
I have a requirement of migrating my whole SQL Server from SQL Server 2012 to 2016. I have already migrated the database engine part. I have not really worked on SSRS (the reporting part), so I need ...
- 397
0
votes
1
answer
306
views
SSRS Label Orientation
I'm trying to print labels on a Zebra printer in SSRS 2014 and the orientation is coming out wrong. In report builder, I set the page size to 4.15 x 1.15 with correct margins. Also, in report builder, ...
- 97
0
votes
2
answers
463
views
SSRS - select where parameter and fixed value
So there is a lot of stuff about using SSRS parameters to select multiple values but nothing about using both a parameter and a fixed value using the in select statement.
So what I'm trying to do is ...
- 173
1
vote
2
answers
13k
views
SSRS report ERROR "Could not load folder contents Something went wrong. Please try again later. "
One of our report servers is raising errors when trying to reach it from clients computers and works just fine from the actual server.
the error is:
I found that it was a bug in sql 2016 using this ...
- 345
2
votes
1
answer
3k
views
SQL Server Reporting Services 2017: Install Cumulative Update
SQL Server Reporting Services are no longer part of the installation media since SQL Server 2017.
How to update an existing Installation of SSRS 2017 to the most current version?
- 402
0
votes
1
answer
2k
views
Unable to log into SSRS through SSMS
I am trying to log into SSRS with SSMS to make a custom role. I am using my domain admin account that is able to log into the database engine side of things fine but when I try to go to reporting ...
- 320
1
vote
0
answers
74
views
SSRS Export Pop-Up Warning
I'm building a new reporting server using SSRS 2016 and have been given one specification I'm not sure is even possible. My supervisor wants a pop-up message whenever someone exports a report that ...
- 97
6
votes
2
answers
5k
views
SSRS 2017 reports having issues with IE 11?
I'm experiencing symptoms very similar to what is described in this 2015 MSSSQLTips article:
SQL Server Reporting Services (SSRS) is not compatible with Internet Explorer 11
You upgraded to ...
- 9,964
0
votes
1
answer
221
views
How would one create an SSRS datasource to quickbooks?
My team is stuck. We are attempting to create reporting in SSRS to connect to quick books. We were successful in creating DAO connections in ms access, however we want to have reporting in SSRS and ...
0
votes
1
answer
796
views
Data-Driven Subscription - how to iterate through all parameter values?
I am trying to build a data-driven subscription in SSRS (In SharePoint integrated mode, but I believe that's irrelevant). The rsds file I am running against has a certain parameter that is a hard-...
- 2,003
2
votes
2
answers
557
views
Is there overhead from using synonyms to access another database?
If one database is accessing tables on another database on the same SQL server through synonyms, does that incur any significant overhead to either of the databases?
Setup: We have one database (A) ...
- 195
2
votes
0
answers
2k
views
Investigating Failures of a Subreport in SSRS 2016
I have a SSRS report, MainReport, that basically just calls a series of sub-reports to compile everything into a nice and tidy Excel Document (users love their Excel reports), with each sub-report ...
- 9,427
1
vote
1
answer
409
views
Two Inner join on the same field to get same data
I'm developing a Report in SSRS for MS CRM 2011.
There is a table named StringMapBase which contains Option Set we have declared in different entities.
This table has Value and AttributeValue column.
...
- 13
1
vote
0
answers
114
views
How to make gauge label stretch across full width of gauge panel?
I have a gauge panel (grey) onto which I am trying to put a gauge label (green) that should stretch across the entire panel. However, when I put 100 into the Width property, it doesn't actually ...
- 11
1
vote
1
answer
340
views
Removal of blank lines
I am creating a SSRS Report to produce some address labels. I have a SELECT statement as follows:
SELECT DISTINCT
AddressLink.intAddressID, Addresses.txtLabelSalutation, ...
- 161
2
votes
2
answers
898
views
Is it possible to host pbix and rdl files on the same report server instance? [closed]
Just upgraded an existing instance of SQL Server 2014 to 2016. That instance has an instance of Reporting Services installed. My end goal is to connect Power BI Desktop (March 2018) to my existing ...
- 21
1
vote
1
answer
477
views
SSRS purge rows from dbo.catalog
We have a third party software that generates reports by adding a new "temp" report to the SSRS catalog every time a user prints a report so now the dbo.catalog table is almost 3 GB and has 16K+ rows ...
- 33
0
votes
2
answers
2k
views
SQL Server 2017 and SSRS on Same Server?
I heard that you cannot have SSRS and SQL Server on the same server, I have not been able to find anything that says this or otherwise, is this a true fact?
- 103
2
votes
1
answer
1k
views
Encrypt connection between SSRS and SQL Server
We are working under a requirement that all connections to SQL Server be encrypted. After setting up a Reporting Server (2016), I see an unencrypted connection to the SQL Server. There are no data ...
- 7,939
1
vote
1
answer
85
views
Averaging 2 values based on an ID in SSRS
I am hoping I might be able to get some help with a problem I am having. I am currently trying to build a report in SSRS to replace an excel spreadsheet we use for data analysis so the report can be ...
- 161
0
votes
1
answer
2k
views
Report Server Reports Hanging
I'm working on a issue with heavily fragmented indexes on a large production DB. I've pretty much identified the indexes that are heavily fragmented, including those that are not really being used. I ...
- 115
2
votes
2
answers
11k
views
SSRS report stuck on Loading but ExecutionLog says otherwise
I have a report that is stuck on loading in the reporting server portal (it's been over a day). However when i check the ExecutionLog...
select * from ExecutionLog3
WHERE UserName = '...
- 53
5
votes
1
answer
3k
views
SSRS View Report: Change View Report Button Text
Is there anyway to change the View Report Button in SSRS to say something else. Such as "Hello", or "See Data". Is there a place in the SSRS XML RDL, I can edit?
user129291
5
votes
3
answers
19k
views
Can SSRS used to Update or Modify data tables?
We all know SSRS (SQL Server Reporting Services) is to read data.
However, can SSRS be utilized to update rows or insert rows, and should it?
I am seeing resources here, where you can take user ...
user129291
0
votes
1
answer
2k
views
SSRS: http://localhost/ReportServer accessible but no report listed
I deployed SSRS on Windows 10 in the right way I think, at least, http://localhost/ReportServer is accessible on Internet Explorer.
As you can see in the picture below:
I created a report using SQL ...
- 1,564
1
vote
0
answers
553
views
Collation Conflict when patching SSRS
We recently upgraded our test database servers from SQL 2014 SP2 CU3 to 2014 SP2 CU10. Most of the servers are fine, but on 2 of them we are getting the following error when connecting to the ...
- 3,252
0
votes
1
answer
5k
views
How can I achieve conditional page breaks in SSRS 2016
I am using SSRS 2016 and Report Builder. I need the page breakinging with a group to be conditional on the value of a parameter. Does anyone know if this is even possible?
- 135
3
votes
3
answers
4k
views
SSRS 2016 report manager using m/d/y date parameter format in Chrome
I've got a 2016 SSRS server, set up with UK regional settings. When using Chrome, date parameter fields are using the US mm/dd/yyyy format instead of the expected UK dd/mm/yyyy:
Edge and IE are ...
- 197
1
vote
1
answer
7k
views
SQL Server Reporting Services 2017 Cant connect and doesnt show in Configuration Manager
I have a few question about SSRS 2017 that I cant find answers to.
Can you no longer add it to the default instance? It seems to force it to an instance called SSRS
After doing the configuration ...
- 15
0
votes
1
answer
3k
views
Report Server tempdb's chunk data table is growing very large on daily basis
In SQL Server 2005, reportservertempdb chunk data table is growing too much in gbs. Need to know why? We are truncating it on a daily basis, still it grows too much. Database is in simple mode. Need ...
- 23
0
votes
1
answer
251
views
Making Switches Work in SSRS
I'm trying to get my report to display different color cells, depending on the condition. This is my current code:
=Switch(Fields!DaysToExpiration.Value > 31, "Green",
Fields!...
2
votes
1
answer
3k
views
'Refreshing' SSRS subscriptions (parameter values not valid due to lack of data in the tables)
In a place where I work we have lots of subscriptions set for SSRS reports. Some reports have as many as 100 subscriptions set up.
Our data warehouse is refreshed every night, with all the data ...
- 155
0
votes
1
answer
144
views
Linked reports in SSRS
Can some one help me how to find out Original report of a Linked report in SSRS.
We tried by editing the permissions on SSRS console and report permissions but no luck.
Thanks,
Venkat Kokulla
1
vote
1
answer
739
views
Give users permission to read subsets of data in tables in SSRS
I'd like to create a SSRS report which utilizes data from our Data Warehouse, DW. This DW has summarized, for example, the sales of 100 or so stores into one table FactStoreSale.
In the report I've ...
- 197
1
vote
3
answers
24k
views
Moving SSRS reports from one Server to other
Is there any way to move all SSRS reports from one server to other, other than downloading each .rdl file and uploading them one by one to the new one?
I followed the steps in this forum post on MSDN,...
user138896