Questions tagged [ssrs]
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
1
vote
1answer
25 views
Dynamically changing tables in datasource in SSRS
I have an SSRS report that I have set up to query two tables, let's call them ABC_Audit and ABC_AuditDetail. I have now added XYZ_Audit and XYZ_AuditDetail to the same database, and want to be able to ...
0
votes
0answers
8 views
Settings Necessary to deploy SSRS
I am fairly new to SSRS.
What are the project settings in SSRS deployment and what do they mean and refer to?
I have successfully created my first SSRS project in Visual Studio. The deployment ...
0
votes
0answers
17 views
SSRS using same paramter accross the where clause
Hi I have the following running in Oracle Developer
and ((new_acc.NEW_ACC_BY = :User_Name and trunc (new_acc.NEW_ACC_Date) between :From_Date and :To_Date)
or (spd_award.spd_by =:User_Name and ...
1
vote
0answers
28 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 ...
0
votes
0answers
8 views
Decrypt KPI data from ReportServer database in SSRS/PBIRS
Does anybody know if there is a way to decrypt via SQL the KPI data that's stored in the Catalog table in SSRS/PBIRS? The KPI functionality is useless to me if there's no way for me to query it ...
1
vote
1answer
25 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 ...
0
votes
0answers
21 views
How to change SharedDatasets in SSRS on several reports at the same time
I moved the report server from one server to another.
Now I need to change the Shared Dataset url in the 300 report definition, from server_1 to server_2.
Below is a bit of problematic source in XML:
...
0
votes
0answers
12 views
Error: Subreport could not be shown when running a Linked Report
We have a main folder (All Reports) where we deploy all of our reports from SSDT. Only the Devs have access to this folder. Next we have a number of user role specific folders, to which users are ...
1
vote
0answers
49 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 ...
1
vote
1answer
41 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 ...
0
votes
0answers
29 views
SQL Server 2008 R2 SSRS Failure sending mail: At least one of the From or Sender fields is required, and neither was found
I am trying to set up a subscription for a SSRS report in SQL Server 2008 R2 and I am getting the following message:
Failure sending mail: At least one of the From or Sender fields is required, and ...
0
votes
0answers
11 views
Input field / form embedded in SSRS report
I understand that this is not what SSRS is for, but I don't have the option of picking a tool. Ideally, nothing other than SSRS would be used.
We would like to implement commenting on our test ...
1
vote
1answer
27 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?
0
votes
1answer
23 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 ...
0
votes
1answer
19 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 ...
0
votes
1answer
33 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 ...
0
votes
0answers
8 views
SSRS 2008R2 to 2016 report manager - has permissions model changed?
Has the permissions model changed in report manager from 2008R2 to 2016? I am working on a migration project at the moment and after doing a successful backup/restore of the ReportServer database to ...
0
votes
0answers
29 views
permissions for the account running the sql server reporting services
I was checking one of my SSRS (sql server reporting services) server and notice that the SSRS service is using the same account that is used for the SQL Server services.
I would prefer it had its own ...
1
vote
2answers
90 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 ...
2
votes
2answers
71 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 ...
0
votes
0answers
30 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
vote
1answer
32 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
1answer
14 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 ...
3
votes
1answer
44 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 ...
1
vote
1answer
46 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 ...
0
votes
0answers
71 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
281 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
13 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
78 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
26 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
422 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
68 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
14 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
17 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
20 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
669 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
41 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
31 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
157 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
79 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
191 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
55 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
25 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
25 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, ...
1
vote
2answers
165 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
141 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
45 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
294 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
141 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
61 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 ...
