Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2269 questions
198
votes
14 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
29
votes
9 answers

can not open the drop-down arrow besides the report in SSRS report manager to add subscription

I try to configure the report manager. It is sql2008r2 report service running on server 2013. There is no problem to pull the report. But I can not open the drop-down arrow besides the report to add subscription. I add the virtual directory,…
user1188125
  • 609
  • 2
  • 11
  • 21
22
votes
3 answers

What are the rules for using "Internal" parameters in SSRS

There is an option to create "Internal" parameters in SSRS: In what context are they used? What are the general rules for using internal parameters?
whytheq
  • 31,528
  • 57
  • 155
  • 255
19
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
  • 5,950
  • 9
  • 43
  • 75
11
votes
4 answers

Access Page number in report body In SSRS

I want to use Globals!PageNumber in Report body part. How can I access inside Report body? I am using SQL Server Reporting Service 2008 R2.
Mike
  • 307
  • 3
  • 7
  • 17
10
votes
2 answers

Oracle Date format exception in SQL Server Reporting Services

Earlier my client was using SSRS 2008R2 with Oracle as transaction database. Recently they have upgraded to SSRS 2017 and now many reports are throwing following error: ERROR: Throwing …
Aftab Ansari
  • 913
  • 8
  • 17
10
votes
2 answers

Error connecting to Data Source in SSRS

I am trying to connect to Datasource but getting this error: An error occurred during local report processing. An error has occurred during report processing. Cannot create a connection to data source 'PO'. You have specified integrated security…
Aruna Raghunam
  • 823
  • 4
  • 20
  • 38
10
votes
5 answers

SQL Server Reporting Services 2008 R2 always show for login prompt

Whenever I try to access SSRS 2008 R2 through a URL (i.e. after being published on the net), it always shows a login prompt when accessing the report. The problem does not appear in the development environment. How do I prevent this login prompt…
Pankaj Kumar
  • 1,708
  • 6
  • 27
  • 39
10
votes
7 answers

Sub report could not be shown. Sub report works separately - Not with Main Report

I've one main report with 5 sub reports. Sub report contains more than 10 parameters. (With 10 Multi valued parameters - So I've used Join method to pass value from Main report to Sub Report) I've also tested Sub report separately and it is all…
pedram
  • 6,199
  • 8
  • 52
  • 79
10
votes
2 answers

Showing day name and month name in ssrs

I am having a date example 4/29/2015 . I need to change the format of date like "Wednesday,april 29,2015. How to achieve this using SSRS.?
Alias Varghese
  • 2,040
  • 2
  • 16
  • 47
10
votes
4 answers

SSRS Format to display as percent

I've gone through quite a few examples on here and I apologize if I'm asking a repeat question, as far as I can tell, I am not. I have an SSRS report made that shows gross sales for certain aspects of our sales departments. They are broken down, in…
Hinarf
  • 161
  • 1
  • 1
  • 9
9
votes
2 answers

SSRS: field shows correct in query but wrong in report preview

I have the following query: SELECT TOP ( 10 ) EMPLOYEE , NAME , SUM(QTYFINISHED) AS QTY , SUM(HOURS) AS REALTIME , SUM(PROCESSTIME * QTYFINISHED / PROCESSQTY / 60) AS CALCTIME , SUM(PROCESSTIME *…
HEDMON
  • 646
  • 7
  • 21
9
votes
1 answer

Can not select multi value parameters in SSRS 2008 R2 subscription

Solution: Wow.. just found the problem and answer to my question below. Had to do with Compatibility settings in IE 9. Once I added my reporting server url to my Compatibility View websites, everything started working properly. I'll leave this…
user3352442
  • 91
  • 4
8
votes
2 answers

Can I create SSRS Reports in VS 2015 using SQL Server 2008 R2?

I'm new to SSRS. Recently upgraded my development environment from Visual Studio 2010 to Visual Studio 2015 Enterprise Edition. Currently my reports are made using Crystal Reports. I would like to to use SSRS and I'm trying find out my current…
Brian
  • 101
  • 1
  • 1
  • 5
8
votes
4 answers

Could not load file or assembly error on adding custom libraries in SSRS reports

I have created a custom library(CodeLibrary) which internally references the dlls Microsoft.TeamFoundation.Client and Microsoft.TeamFoundation.WorkItemTracking.Client. I added this custom Dll codelibrary.dll to my SSRS report. and the expression of…
perplexedDev
  • 641
  • 4
  • 13
  • 28
1
2 3
…
99 100