Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssrs-2012]

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

48 questions
6
votes
2 answers

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 instance 1 Machine 2 SSRS instance 2 pointed to…
RyanW
  • 163
  • 1
  • 2
  • 6
5
votes
2 answers

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 more than one, I will get an error. The problem is…
Scorpion99
  • 387
  • 1
  • 6
  • 19
4
votes
2 answers

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 migration, it looks like its a very tiring process since…
SSAS developer
4
votes
3 answers

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 report directly the value is properly displayed, but…
John Eisbrener
  • 9,547
  • 6
  • 31
  • 65
4
votes
1 answer

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 and DBS) server - only 1 - must be specified. The…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
3
votes
1 answer

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 is involved with the setup for the data source…
Debbie
  • 303
  • 2
  • 4
  • 12
3
votes
2 answers

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 one page and the rest on the next. The Tablix has…
Matt
  • 31
  • 1
  • 1
  • 3
3
votes
1 answer

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 the display around 40% of the screen is blank.…
nojetlag
  • 2,927
  • 9
  • 34
  • 42
3
votes
1 answer

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, all our reports are using Shared data sources that…
Roni Vered
  • 585
  • 7
  • 17
2
votes
1 answer

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 location, connect to the report server via remote desktop…
Akash
  • 1,032
  • 1
  • 9
  • 25
2
votes
1 answer

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 used for the calculated field '=CountRows' includes…
BKChedlia
  • 121
  • 1
  • 2
2
votes
2 answers

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" folder, and deployed all reports to it. I then…
Mansfield
  • 1,061
  • 8
  • 20
  • 33
2
votes
1 answer

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 reporting service configuration manager when clicking…
Mel Cuya
  • 31
  • 1
2
votes
1 answer

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 taking the value of the parameter. Please help me with…
ramya
  • 21
  • 1
  • 2
2
votes
0 answers

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 me expose a nice reporting dashboard in an…
rcourtna
  • 121
  • 3
1
2 3 4