Stack Overflow
Stack Overflow

Questions tagged [ssrs-2012]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2012 in March 2012.

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2012 in March 2012. More info in the tag.

3624 questions
219
votes
17 answers

How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the layout size in report properties as width=18in and…
brijit
85
votes
10 answers

SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports are blank in Safari and Chrome

I migrated our reporting services from version 2008 to another server version 2008 R2. In version 2008 the reports work fine on Safari. The new version 2008 R2 the reports do not show up at all. All I see is the parameter section and then the report…
Anita C
  • 859
  • 1
  • 7
  • 4
83
votes
17 answers

SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8... why?

I have some simple reports in SSRS 2008 R2, but they won't display at all in Safari or Chrome. According to Microsoft's Books Online, these browsers are supported in limited fashion. However, I can't see anything after the data "Loading" clock…
Greg H
  • 831
  • 1
  • 7
  • 4
41
votes
10 answers

SSRS report definition is newer than Server

I created some reports in Visual Studio 2015 with all the latest updates. However, when I try to deploy the reports I get this message: The definition of this report is not valid or supported by this version of Reporting Services. 11:40:28 Error …
M Kenyon II
  • 4,136
  • 4
  • 46
  • 94
36
votes
8 answers

Download all SSRS reports

I want to get a copy of all .rdl files in one server. I can do the download manually one report at the time, but this is time consuming especially that this server has around 1500 reports. Is there any way or any tool that allows me to download all…
asmgx
  • 7,328
  • 15
  • 82
  • 143
31
votes
2 answers

SSRS - Changing tab name when exporting to excel

I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression for page name =Fields!classname.Value. In doing so,…
user3798811
  • 493
  • 1
  • 4
  • 7
26
votes
7 answers

The report definition has an invalid target namespace rsInvalidReportDefinition

I have created a ReportProject with Visual Studio data tools 2015. When I create a report.rdl file using the report wizard, the rdl file has schema for 2016. My reporting server is of version 12.0.4213.0. How can I create a report.rdl which is…
Anirudhan J
  • 2,072
  • 6
  • 27
  • 45
21
votes
14 answers

Could not load folder contents - SSRS Report Manager

What I want to do is log into report server manager. I have added the user to a job role in SSMS and have equally assigned the user to a specific role in Report Manager (2016). Through a secure host, I can log in with the built-in account but I am…
UpwardD
  • 739
  • 4
  • 12
  • 36
20
votes
3 answers

SQL Server Reporting Studio report showing "ERROR#" or invalid data type error

I struggled with this issue for too long before finally tracking down how to avoid/fix it. It seems like something that should be on StackOverflow for the benefit of others. I had an SSRS report where the query worked fine and displayed the string…
Josh
  • 1,876
  • 3
  • 21
  • 35
20
votes
3 answers

Vertical merge in SSRS Tablix

Is there any chance to do vertical merge of fields in tablix? I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.
veljasije
  • 6,722
  • 12
  • 48
  • 79
15
votes
14 answers

SSRS error on preview : "The size necessary to buffer the XML content exceeded the buffer quota" hides original error

I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly this hiding irritates me much more than original…
Roman Pokrovskij
  • 9,449
  • 21
  • 87
  • 142
14
votes
1 answer

SSRS Lookup Based on Multiple Conditions

I have a dataset (Volume) looks like this: In my report, what I want to get is this: The Lookup expression: =Lookup (Fields!Id.Value, Fields!Id.Value, Fields!Volume.Value,"Volume") can only lookup on ID. Is there any way I can do lookup on…
C.C
  • 179
  • 1
  • 2
  • 13
14
votes
4 answers

User '%' does not have required permissions, SSRS 2012 on Windows 7

After a fresh install of SQL Server 2012 Developer on my Windows 7 machine, I configure SSRS. Then, in IE (version 11), I try to access the SSRS server at http://(servername)/Reports. Windows asks for my username and password. Odd, because I'm an…
glenn380
  • 711
  • 1
  • 5
  • 10
13
votes
2 answers

SSRS 2012 right aligned text cut off

We recently upgraded from SSRS 2008 R2 to SSRS 2012. A good portion of our existing reports are now rendering with some columns cutting off right-aligned text. We used BIDS 2008 to develop the reports and then deploy the RDL's to SSRS 2012…
drizzie
  • 3,351
  • 2
  • 27
  • 32
12
votes
2 answers

sp_send_dbmail embed mhtml file in body

I have an SSRS report that I need to embed in the body of an email using the sp_dbmail stored proc in SQL Server. I'm able to do this using the front end of Outlook by attaching the .mhtml export of the SSRS report using the "Insert as Text" option…
Pops
  • 468
  • 2
  • 15
1
2 3
…
99 100