SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
0
votes
0answers
35 views
Count() used in sql query giving #Error in SSRS report after report deployment on report server
I am newbie to SSRS and I am trying to display basic reports in SSRS. I have create a simple table with 1 column named "TotalNumber", whereTotalNumber display the count of total number of user in the ...
0
votes
1answer
45 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. Since I have not really worked on SSRS (reporting part), so need ...
0
votes
1answer
7 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, ...
0
votes
1answer
22 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 ...
0
votes
0answers
9 views
Migrating SSRS reports with shared data sources between instances using rs.exe
Has anyone successfully used rs.exe and ssrs_migration.rss to migrate reports using shared data sources between SSRS instances? This doesn't seem like it would be that unusual of a situation but I ...
0
votes
1answer
55 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 ...
0
votes
1answer
22 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 ...
0
votes
0answers
10 views
Granting local Windows account access to single SSRS shared data source?
So we have a multi-tenant SSRS 2016 system which most customers don't have access to so from the frontend we will create folders, reports, data sources etc. We have one customer who is trying to use ...
1
vote
0answers
14 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 ...
0
votes
0answers
16 views
ReportServer on Failover fails to update the policy user
Information
Our system has two nodes, S1, S2, which we recently added to our SCluster. One of the databases is the ReportServer. Now, everything fails over just fine, except for the ReportServer ...
6
votes
2answers
186 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 ...
0
votes
1answer
26 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
0answers
28 views
SSRS Column error
We have SSRS reports. When we import those reports in MSCRM and run, the column in the report moves to the last if it doesn't has data.
for instance:
If all columns have data then columns will be ...
0
votes
1answer
51 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
votes
2answers
70 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) ...
2
votes
0answers
68 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 ...
1
vote
1answer
40 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.
...
1
vote
0answers
9 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 ...
1
vote
1answer
22 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, ...
0
votes
2answers
72 views
Is it possible to host pbix and rdl files on the same report server instance?
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 ...
0
votes
0answers
63 views
Report does not display when parameter allows multiple values
The report has two parameters: @p1, a date and @p2, a string. @p2's available values come from a query based on @p1. This report works when @p2 does not allow multiple values. When it does, the report ...
1
vote
1answer
38 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 ...
0
votes
2answers
127 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?
1
vote
1answer
68 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 ...
1
vote
1answer
55 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 ...
0
votes
1answer
47 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 ...
1
vote
0answers
305 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 = '...
4
votes
1answer
266 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?
2
votes
2answers
221 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 ...
0
votes
1answer
33 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
vote
0answers
102 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 ...
0
votes
0answers
48 views
Random errors in SSRS Log “The report server cannot open a connection to the report server database.”
My SSRS runs snapshot in the morning. I noticed some of the reports are not snapshoting once in a while.
I found following error which is random daily for the difrerent report.
The report server ...
0
votes
0answers
35 views
SSRS Subscriptions are not sent to the users
I have an SSRS report, in which Subscriptions are configured. There are multiple Subscriptions. Some times the users subscribed are not getting the reports. No error in the Subscriptions tables in ...
0
votes
1answer
244 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?
1
vote
1answer
174 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 ...
1
vote
1answer
881 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 ...
0
votes
1answer
248 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 ...
0
votes
1answer
24 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!...
1
vote
0answers
72 views
instance connection or database expanding is stuck sometimes on sql test server [closed]
i have a test sql server and a production server.
when i connect to the production instance sometimes it connects right away, and sometimes its stuck on expanding mode and this error appears:
it ...
1
vote
1answer
51 views
Report Builder Indicator showing incorrect symbol
I have a report on which I am using about a dozen indicators as a check boxes. The data source for the report is a SharePoint list. About half of the check boxes are displaying correctly. The other ...
1
vote
1answer
295 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 ...
0
votes
0answers
73 views
Administrators can't browse user folders
Probably a simple one, but I'm having a problem getting access to users 'My Reports' folders. SSRS 2014 in Native Mode.
If I log in as myself, I see a 'My Reports' folder, and an account with my ...
0
votes
1answer
15 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
1answer
76 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 ...
0
votes
3answers
107 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,...
0
votes
0answers
29 views
Can I use a SQL Server Credential for SSRS Report access
Can I use the SQL Server Credential to connect to a SSRS Report .
Because of recent security changes the account I am using my windows credential for accessing the report . But because of the ...
0
votes
0answers
34 views
Availability Groups - Failover causes SSRS to break
I'd like to preface this by saying I'm not a DB admin nor have any formal training in DB administration, but trying to get an response in a reasonable time from our network team is like pulling teeth. ...
0
votes
0answers
234 views
Connecting to Report Server in Visual Studio
I've been developing SSRS reports for some time in Report Builder and have recently tried to migrate to Visual Studio as the development environment.
Unfortunately I'm having a problem establishing a ...
0
votes
1answer
103 views
How to execute OPENROWSET from SSRS
Trying to create a Dataset in SSRS that executes a stored procedure that imports data from an Excel file. The sproc transforms the imported data and outputs the reformatted data for the SSRS report. (...
0
votes
0answers
22 views
SSRS Report Issue
When I am trying to see the report facing this issue. How to fix this?
An error has occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException:...
