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

2305 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
31
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
  • 677
  • 2
  • 13
  • 21
23
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
  • 34,466
  • 65
  • 172
  • 267
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
13
votes
3 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
  • 903
  • 7
  • 22
  • 43
12
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
  • 317
  • 3
  • 7
  • 17
11
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,104
  • 3
  • 24
  • 52
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
  • 926
  • 9
  • 17
10
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
  • 727
  • 10
  • 24
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,748
  • 6
  • 28
  • 41
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
9 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,256
  • 10
  • 65
  • 87
9
votes
4 answers

SSRS distinct lookupset function

I'm using Join(Lookupset) to find unique group values which returns a sequence number. This is my function: Join(LookupSet(Fields!itemId.Value & Fields!UseByDate.Value & Fields!rackId.Value , Fields!itemId.Value & Fields!UseByDate.Value &…
jhowe
  • 10,198
  • 19
  • 48
  • 66
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
1 answer

How to remove Report Server Web Service URLs from Reporting Service Configuration Manager

To start with, I am completely new to SSRS reporting. Please excuse me if I miss any basic details here. I am trying to create a reporting service. Accidently, I have selected an existing Report Server Web Service Site Identification. Now I have 2…
Mahatma Aladdin
  • 2,027
  • 3
  • 17
  • 31
1
2 3
…
99 100