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
5
votes
2 answers

How to insert Excel formula to cell in Report Builder 3.0?

There is RDL report template for SQL Server Reporting Services. I need to set value for cell in table in the report template which must be calculated from other values in the report. When the report is exported to Excel file I need to see the Excel…
asolovyov
  • 903
  • 1
  • 10
  • 21
5
votes
2 answers

Interactive sorting In SSRS on Values - Matrix report

I want a interactive sorting in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value. We are grouping rows by Primary Key and grouping column by Columns and use Value as data. My Matrix Report - ID …
Wumar
  • 103
  • 1
  • 1
  • 11
5
votes
3 answers

Report preview cannot find Data source folder

When I try to preview report in Visual Studio 2012 Designer I am getting an error: An error occurred during local report processing. An unexpected error occurred in Report Processing. An error occurred during local report processing. Error in the…
user170442
5
votes
1 answer

SSRS 2008 R2 Globals!RenderFormat.Name=EXCELOPENXML

In an existing 2008R2 report, I have a concern about reports being exported to Excel. I have this concern since the result is related to the visibility of tablixes, columns, and rows based upon the export option chosen by the user. When I am…
user1816979
  • 511
  • 4
  • 13
  • 25
5
votes
1 answer

How to check for null values before doing .AddDays() in SSRS?

I have the following as the value for my textbox in SSRS report: =iif(IsNothing(Fields!MyDate.Value), "", Format(Fields!MyDate.Value.AddDays(30), "MMMM dd, yyyy")) It gives me an "#Error" every time MyDate is null. How do i work around…
roman m
  • 26,012
  • 31
  • 101
  • 133
5
votes
2 answers

SSRS 2012 Report Models

I am preparing a SSRS 2008 R2 commercial demo for my company, using Report Model to produce a kind of "BO Universe" data model to use with Report Builder, to show how users can produce their own reports by using a data model already created by a…
Daniele Di Punzio
  • 503
  • 2
  • 5
  • 7
4
votes
1 answer

SSRS - How to Sum values on a LookUpSet expression

Hi I have a column that uses a lookupset expression =Join(LookupSet(Fields!ReportUNC.Value, Fields!ReportUNC.Value, Format(Fields!cntSelfService.Value, "###,#######0"), "ExecutionCount")).I'm getting an incorrect parameter when I sum that expression…
Arsee
  • 651
  • 2
  • 11
  • 36
4
votes
3 answers

Unsupported RPL stream version detected: 101.116.1047292257. Expected version: 10.6

When I run the SSRS report in Visual Studio I'm able to run the report but when I execute the report through the report server it's throwing the below error any help. Error : An error occurred during client rendering. Unsupported RPL stream version…
Kapil
  • 1,823
  • 6
  • 25
  • 47
4
votes
2 answers

How to group this SSRS report?

I have an SSRS report. It looks like this: Its definition looks like this: As you can see it's just a bunch of numbers in different columns A to G. Those numbers were grouped by A then B then C. For each row in the report, column D,E,F,G are my…
Just a learner
  • 26,690
  • 50
  • 155
  • 234
4
votes
3 answers

Replace Zero with Blank in SSRS

Is it possible to replace 0 with blank in ssrs matrix. The expression =IIF(IsNothing(Count(Fields!referralNo.Value)),0,Count(Fields!referralNo.Value)) is same as =Count(Fields!referralNo.Value). When I try…
Monte
  • 103
  • 1
  • 1
  • 5
4
votes
1 answer

SSRS 2008 R2 Subreport that returns no data will not display

Used this site for many years but first time posting a question... I have a parent report which consists of multiple child sub-reports (all being the same report for testing purposes). The child reports contain a tablix and a few free-standing…
TheDirtyJenks
  • 399
  • 1
  • 3
  • 12
4
votes
2 answers

"the target principal name is incorrect" 401 error

So we have an small app that points to a report on a 2008 SSRS server. This app works fine normally, but since we added more websites to the server, we have changed the web app binding to something that is not the name of the server. This has caused…
Limey
  • 2,642
  • 6
  • 37
  • 62
4
votes
2 answers

Report.aspx to ReportViewer.aspx

We recently had a new SSRS Environment set up and the report manager URL for report is now Reports/Pages/Report.aspx The previous environment was ReportList/Pages/ReportViewer.aspx and would accept parameters in the url, the new one does not. How do…
NewGuy
  • 1,020
  • 1
  • 9
  • 24
4
votes
1 answer

Can't go into advanced mode in SSRS 2008 R2

I cannot find advanced mode in SSRS 2008 R2. I need to freeze the top row in a tablix so it stays there when scrolling on a report. Apparently I can do this in "advanced mode", but when I click the arrow to the right of the groups in the grouping…
Dom Vito
  • 507
  • 8
  • 38
4
votes
2 answers

Create a dataset which is a subset of another dataset in SSRS

In my SSRS report, I already have a dataset A(by running a SQL script), and parameter P1 use all the records in A. Now I want to get a subset of A, and use another parameter P2 to refer to it. Is it possible that get the whole and the subset of the…
BartMao
  • 651
  • 7
  • 21
1 2 3
…
99 100