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
4
votes
1 answer

SSRS 2008 R2 - Excel output not formatting to page size

I have a batch of reports that are set up to print very nicely in landscape on A4 page. But when I set the default format to Excel, the resulting spreadsheet, when printed without changing anything in the print setup, is wider than an A4 page so of…
nzmike
  • 578
  • 1
  • 7
  • 25
3
votes
1 answer

Count value in SSRS

I want to ask a question regarding the count error that is generated in SSRS reporting server. I have two condition simultaneously, but the count is working only for one condition not for both. Please suggest is there any problem in my logic or…
Arpit Sharma
  • 138
  • 1
  • 11
3
votes
3 answers

SSRS 2008 R2 to SSRS 2016 Migration

I have to migrate 770 SSRS Reports (Includes both Native mode and Sharepoint Mode Reports) from 2008 R2 version to SSRS 2016 version. Which is the best tool for this SSRS migration ? I have seen few tools like Microsoft Reporting Services Migration,…
Sunjith
  • 76
  • 1
  • 11
3
votes
0 answers

Display TINYINT as INT instead of TRUE FALSE

I am selecting a TINYINT column from MySQL database, it will display properly in MySQL, but when I print the value in the report using SSRS, it will display the value as True or False instead of its original value in number. According to this…
Newbie
  • 1,584
  • 9
  • 33
  • 72
3
votes
1 answer

Report Title Will Not Stay Centered in SSRS Report

I've created a report with a row grouping and a column column for a report - and I have centered the report title in the report header above the tablix as shown below. The Channel data uses an expression that replaces NULL values with a 0. The…
MISNole
  • 992
  • 1
  • 22
  • 48
3
votes
1 answer

Create a Header Row in SSRS

I am trying to create a header row for a matrix in my SSRS report. Currently my matrix is configured as the following: If I right+click to add a new row, it will insert a row above but I cannot merge the entire row of cells to form a single row,…
MISNole
  • 992
  • 1
  • 22
  • 48
3
votes
1 answer

SSRS Format string to date time DD MMM YYYY HH MM

Display in reporting services text box - data is grouped. Best way to format grouped data 20170518110610 to DD MMM YYYY HH MM? I.e. 18 May 2017 11:06 Tried Text box properties - number - custom format - dd-mmm-yyyy hh:mm the result is the same…
Rosebud
  • 579
  • 2
  • 10
  • 19
3
votes
1 answer

Getting top 20 rows and the rest in 21st row in an SSRS Matrix Report

I want top 20 rows from an SSRS Matrix report and rest of the rows should be aggregated in 21st row with the row name hard coded as “Others”. I have created the SSRS Matrix Report with row grouping based on "Category_Name" and Column grouping based…
S.Jo
  • 58
  • 5
3
votes
1 answer

Why SSRS report fonts are rendered different on IIS

I am using Gotham and PT sans fonts for SSRS Report which are reflecting in the SSRS Report on Localhost but when I am trying to see same in IIS, fonts are not Reflecting. I have already added fonts in C drive fonts folder. Why SSRS report fonts are…
Sarita Khutale
  • 139
  • 3
3
votes
1 answer

How to change ReportServerUrl in Report Builder 3.0?

We have 2 reporting server. One for test and one for production. Our business analyst will build the reports (rdl files) using Report Builder 3.0. After they complete the development and test on test reporting server (e.g. http://test/reportserver),…
Mark
  • 283
  • 3
  • 22
3
votes
3 answers

Limit number of pages displayed in a SSRS Report

I have seen many posts regarding limiting number of rows displayed on one page in a SSRS Report. But I want to display 50 rows in one page and would like to limit the report to 5 pages. Is this possible ? Can I limit the number of pages displayed by…
Programmermid
  • 588
  • 3
  • 9
  • 30
3
votes
1 answer

Get previous,current and Next Record in ssrs report in a page

I am creating a report Which Show Previous,Current and Next id on Report. We can get Previous id via Preveious(Fields!Id.Value) but how can get next Id. Here is no function as Crystal report Next(Fields!ID.value) in ssrs. I am new in SSRS .Please …
Manoj Pandey
  • 87
  • 1
  • 1
  • 11
3
votes
3 answers

SSRS Report Custom Sort Order

I am having some problem for a custom sorting required for one of row groups that I have in a SSRS table. The logic for the custom sort order - If the row group value contains a particular value then it should always be displayed at the bottom and…
Aritra B
  • 1,726
  • 6
  • 29
  • 45
3
votes
1 answer

SSRS SWITCH Syntax not working

I have a columns in my dataset that will be returning several different values. In an attempt to to use grouping in the report I am trying to clean up the data. After reading several posts I found this post that seemed to be very close to what I…
Perry
  • 1,277
  • 2
  • 17
  • 39
3
votes
1 answer

Need to set a date parameter on an SSRS subscription

I have a report in SSRS that takes a single date as a parameter. What I want is for that report to have a subscription that uses the Saturday of two weeks ahead as the date (i.e., Monday 7/4 would give Saturday 7/16). How can I do this in the…
Dom Vito
  • 507
  • 8
  • 38
1 2 3
…
99 100