Skip to main content

Questions tagged [ssrs-2012]

SQL Server Reporting Services 2012, a web based reporting tool produced by Microsoft and bundled with SQL Server 2012.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

SSRS 2012 to SSRS 2019 upgrade with forms authentication

I have a client that is wanting to migrate to SQL 2019 from 2012. That upgrade path as you all know de couples SSRS from the SQL upgrade. The problem that I am having is that migrating the SSRS to ...
Mizmaul's user avatar
0 votes
1 answer
104 views

I changed permission of SQL Server Reporting Services through SQL Server Management Studio

Now I can't access Reporting Services through SSMS. I can't even connect to Reporting Services now.
user avatar
1 vote
2 answers
2k views

SSRS not sending scheduled email to specific contact [closed]

I have a specific contact for my SSRS subscriptions that does not receive any mail from SSRS. her email is an organization email, everyone else including me are getting emails but only that specific ...
sql_girl's user avatar
  • 345
0 votes
0 answers
108 views

How to export the SSRS report in excel

I have 7 pages in my SSRS report and also I'm used page break option. Is there any way available to export all the pages in single excel sheet. Please provide me solutions
Nethaji.R's user avatar
0 votes
1 answer
816 views

SSRS Configuration

I'm trying to configure SSRS to use email subscription feature. This SSRS server is hosted on AWS and I have an SMTP relay to use. This SMTP relay requires an userid and password to authenticate. I ...
Vikas Singh's user avatar
0 votes
1 answer
739 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 ...
abbhey's user avatar
  • 115
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 ...
user avatar
2 votes
1 answer
481 views

SSRS is missing after failover to other node

We have 2 node setup cluster, after a failover I can't see the reporting services, even the service it self is missing. I checked control panel program manager, SSRS is not installed, I open ...
Mel Cuya's user avatar
1 vote
2 answers
3k views

Convert SID string to varbinary(85)

My ssrs server was moved to a different domain because of which the Users table need to be updated with new SID current sid: S-1-5-21-39949945-591092532-1226208319-1007 I want to convert this sid ...
Mohammad Yusuf's user avatar
0 votes
2 answers
54 views

SSRS breadcrum just breaks into multiple lines

This is a very annoying thing happening to the reports I am developing. The top breadcrumb sometimes works fine while at times breaks into multiple lines. I have only IE 11 in my environment, Is it ...
Ramakant Dadhichi's user avatar
1 vote
1 answer
499 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 ...
Mrphin's user avatar
  • 133
1 vote
1 answer
2k views

SSRS, Limit Fixed number of Columns in Matrix within a Tablix - issue in sorting matrix data

I am converting a crystal report to ssrs report, i am trying to implement "Format With Multiple Columns" feature of crystal report to ssrs. I have a Main tablix that has two Two Groups 1st Group - ...
Vinayak's user avatar
  • 21
1 vote
0 answers
307 views

CC/BCC and comments section is missing in the SSRS subscription page

We're using SSRS 2012. We tried to limit the permission level of users, and assigned them "Manage Individual subscriptions" role, instead of "Content Manager" or "Subscription Manager", however, now ...
Roni Vered's user avatar
4 votes
3 answers
2k views

Why is this SSRS Report rounding a BIGINT Value to the nearest Thousandth when exporting to Excel?

I have a SQL Server Reporting Services (SSRS) 2012 report that is populated via stored procedure (SP). The SP returns various fields, one of which is a BIGINT datatype. When I execute the SSRS ...
John Eisbrener's user avatar
3 votes
1 answer
774 views

Creating Report Subscriptions on report that are using a Shared data source that uses Windows Integrated Security

We've recently deployed a new SSRS Server 2012, that can use Windows Integrated Security. We configured the servers to properly use Kerberos authentication and we solved the double hop issue. Now, ...
Roni Vered's user avatar
0 votes
1 answer
802 views

How can I display 9 rows of results in a 3x3 grid?

I have a report that gathers data to be printed on labels, we want to print up to 9 labels per page, on a 3x3 grid. Am I able to use something like groupings to get this layout generated ...
Bazul's user avatar
  • 103
1 vote
1 answer
773 views

Can I rename the View Report button in SSRS

I was wondering if it is possible to rename the button View Report in SSRS or even add some command buttons with it.
Scorpion99's user avatar
5 votes
2 answers
9k views

Multi values for SSRS parameter with Like statement

IN SSRS, I have a parameter named Comment which I set to Allow multiple values and specified available values for it. My problem is that if I select one value, I will get results but if I select ...
Scorpion99's user avatar
1 vote
1 answer
5k views

SSRS minimal permission to download reports

I received this request from a developer: When I try to download *.rdl report files from myssrs_server/Reports I’m getting this error: Would you be able to extend my permissions so I can ...
Marcello Miorelli's user avatar
-1 votes
1 answer
502 views

Installation/Configuration Error Installing 2012 SSRS Native Mode

I believe I properly installed Reporting Services for SQL Server 2012 Developer edition however I get a HTTP 500 error when attempting to view the report viewer or manager URLs in both IE 10 and ...
user3318152's user avatar
1 vote
1 answer
2k views

SSRS --> .xlsx file --> SQL ETL -- "External table not in expected format" error, but only when files have not been opened

Long story short, I've had to use a workaround to importing data directly from SharePoint due to SSIS drivers not working with it. My current workaround is almost good enough, but it still has some ...
QuizzicalFerret's user avatar
0 votes
2 answers
4k views

SQL Server 2012 SSRS: Creating a report using global temporary tables

I am creating a SSRS report using a Stored procedure. The stored procedure does dynamic pivoting couple of times. The schema of the intermediate tables are dynamic and thus I'm using temporary tables. ...
Anshul Dubey's user avatar
1 vote
0 answers
2k views

Restarting SSRS using SQL Agent & Powershell

I'd like to create a SQL agent job to restart SSRS each day. In the past i've used a Powershell script executed by a Scheduled task taken from here. This has worked fine, but I would prefer it to ...
Sir Swears-a-lot's user avatar
1 vote
2 answers
9k views

Querying the Username in a Share Data source (SSRS)

I am running a project to go over all logins of all our SSRS 2012 datasources and I need a complete list of all datasources, INCLUDING the loginname used to connect. I couldn't find it anywhere. I am ...
Roni Vered's user avatar
2 votes
1 answer
6k views

Pass a parameter from SSRS to MySQL

Here is the query for the dataset: SELECT DISTINCT CompanyId, Company FROM User_Hierarchy_Mapping WHERE UserId = @FieldManager FieldManager is the parameter name. It's not ...
ramya's user avatar
  • 21
0 votes
2 answers
1k views

SSRS 2012 Report with Oracle database as datasource never finishes

I am investigating a SSRS 2012 Report which used to return data from an Oracle database. However, recently it stopped returning data. The report will sit there and run forever until something times ...
Geoff Dawdy's user avatar
  • 1,133
1 vote
1 answer
1k views

Grouping and Row limit in SSRS

I want to have row limitation(for example, display only 10 rows in every page) to my table in the report. I could limit the rows with Ceiling method where I could find refer. However, I have to group ...
LittleBirdy's user avatar
2 votes
0 answers
954 views

Expose SSRS Reports in websites

I'm fairly new to the SQL Server stack, and am trying to wrap my head around how to best expose on-premise SSRS reports in websites (LAMP stack). URL Access appears to be what I'm after, as it lets ...
rcourtna's user avatar
  • 121
1 vote
1 answer
132 views

Adding a new data set in SSRS with nested stored procedures

I have spOne which builds a couple of global temp tables with over 500 lines of code. Normally it would return a single result set but I wanted to leverage the code for building the temp tables ...
SQL Hammer's user avatar
2 votes
1 answer
4k views

SSRS Lookup #Error on some rows

I'm having trouble working out the details with an IIF containing some lookup statements. The setup: Dataset 1: Transactions Fields: itemid, transactionnotes, rdesc Dataset 2: EmployeeInfo Fields: ...
MSCF's user avatar
  • 21
2 votes
0 answers
380 views

SSRS dynamic data retrieved from another dataset

I want to get data(dynamic)according to the data in another dataset and put the result in textbox of the different dataset. Right now, the data I get is static and I tried to use many expressions but ...
user82817's user avatar
0 votes
1 answer
7k views

How to pass SSRS params into a URL

I have Native SSRS configured on a 2012 instance (11.0.2100). I have two reports with images that act as buttons to toggle between the chart report and the detail report. I want to configure the ...
SQL Hammer's user avatar
4 votes
1 answer
833 views

SSRS - ERROR NUMBER:7357 while passing multiple value parameters using comma delimited string to stored procedure

I am working on a SSRS report to display the logins permissions in a set of databases on a specific server. the server, the logins and the databases are all parameters. NULL shows them all (logins ...
Marcello Miorelli's user avatar
0 votes
2 answers
1k views

Unable to browse to folder on SSRS 2012 through report url

I have installed SSRS 2012 in native mode on windows server 2012 r2 and deployed reports to the server successfully. I am having difficult browsing to any report folder through the report URL. I can ...
kdis's user avatar
  • 195
3 votes
1 answer
3k views

Reporting services - High availability setup - SQL server 2012

I need some guidance on best practices and setup for SSRS. I have a SQLServer 2012 setup with data source on 1 instance and SSRS on a separate server. There is a need to setup HA and I understand what ...
Debbie's user avatar
  • 303
2 votes
1 answer
402 views

Deploying SSRS reports on an "Air Gapped" report server without SSDT?

Whats the simplest way to deploy multiple reports (.rdl) along with the respective data sources to a machine which cannot be connected to from Visual Studio? I can only place files at a given ...
Akash's user avatar
  • 1,032
0 votes
1 answer
2k views

SSRS 2012 Report variables scope

I have a report that uses data from several datasets. I chose to do it this way because the alternative would be to join about 12 tables. From what I can gather, I have to use the dataset name to ...
Hanlie's user avatar
  • 11
2 votes
1 answer
6k views

Count rows in dataset SSRS2012

I want to count the number of rows in my result DataSet, I put in my DataSet a calculated field with this expression : =CountRows("DataSet1") But I have the following error message: "The expression ...
BKChedlia's user avatar
  • 121
1 vote
0 answers
3k views

SSRS 2012 - Dynamically change value of textbox in report header

I am in the process of converting some MS Access 2003 reports to SSRS 2012 (using VS 2010 to develop the reports). I have a report with a number of parameters. Some of the parameters are populated ...
Susan M's user avatar
  • 11
1 vote
2 answers
15k views

SQL Server Reporting services migration (2008 to 2012)

We have a SSRS 2008 (not R2) instance with a few hundred reports, and now, on a new machine we have installed a 2012 instance of SSRS. We need to migrate all the reports, while keeping all their ...
ddaniel's user avatar
  • 623
1 vote
1 answer
429 views

Does reporting webservice url contain the function that helps to export the report to the client version?

The reporting webservice url contains the webservice url that contains all the information of the Reports which are created in SSRS. As the report has been created on reporting service, i want to ...
user2624315's user avatar
1 vote
1 answer
3k views

Impact on SSRS of migration of SQL Server from 2008 to 2012

As part of my project, we are upgrading SQL Server 2008 R2 to SQL Server 2012. We have a separate SSRS 2008 instance running on a separate machine which interact with these existing 2008 database ...
Rohit Goyal's user avatar
2 votes
2 answers
3k views

How can I change the data source of a linked report?

I'm in a situation where multiple "customers" will be running the same report, but against a different database (with the exact same structure). What I've done so far is created a generic "Deploy" ...
Mansfield's user avatar
  • 1,031
1 vote
1 answer
1k views

Report Builder cannot publish to report server [closed]

This is currently in a cloud lab environment. We're not allowed to join any AD domains. We have a linux server (RHEL 6) running MySQL 5.3 and a Windows SQL Server 2012 on Win 2k8 R2. Our laptop is ...
user37336's user avatar
1 vote
0 answers
396 views

Bind web service/Report Manager based on IP address AND hostname

I'm trying to get Apache installed on our main database/application server, and I'd like to give it its own IP address on a secondary NIC so I don't have to use a nonstandard port. This requires that ...
db2's user avatar
  • 9,668
1 vote
1 answer
2k views

Active directory automatic login to SSRS

I have a server running SSRS 2012 at address server1.olddomain.com. This is working fine. My users will be accessing this server from another address (the server is not physically moving). The new ...
Mansfield's user avatar
  • 1,031
6 votes
2 answers
22k views

Possible to run multiple Reporting Services (SSRS) instances on different machines with databases on same machine?

With SQL Server 2012, can SSRS instances be setup on two different machines, with both instances using the same machine for their SQL Server databases? Machine 1 SQL Server 2012 Database Server SSRS ...
RyanW's user avatar
  • 163
3 votes
2 answers
15k views

Page Break is splitting in the middle of a single row in SSRS

I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
Matt's user avatar
  • 31
3 votes
1 answer
557 views

SSRS Reports on WUXGA Displays

We use WUXGA displays (1920 x 1200), and have lots of SSRS reports. Since these reports need to be printed once in a while the layout is adjusted to A4. However when the users look at the reports on ...
nojetlag's user avatar
  • 2,897