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

How to assign a value dynamically for a group filter in ssrs 2008

I have a table on SSRS 2008 like: [QuarterCount] GROUP Volume [Group] [sum(Volume)] QuarterCount is a syntax like: -Q, where is 1 if the current month is January to March, 2 if the current month is April to July and so on. The…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

How to disable "Document Map" tab while exporting into excel via SSRS 2008

When I export my SSRS 2008 report into Excel, I see there is a tab at the beginning called "Document Map". I do want to disable this tab coming from the ssrs export, but I could not find the way to do it. I appreciate if anyone helps me. Thanks.
BalkDal123
  • 13
  • 9
0
votes
0 answers

SSRS Matrix Display Issues

I have an SSRS matrix that groups some data based on an account's activation date (the columns) and the system date (the rows). The example I have groups these accounts into monthly (ex: all accounts created Nov 2016). Since these accounts did not…
ferensilver
  • 341
  • 2
  • 4
  • 17
0
votes
0 answers

SSRS subscription is processing but mails are not getting delivered

I need to schedule a SSRS report to be sent on daily basis. So, I created a data driven subscription. It's showing the status as "Done: 1 processed of 1 total; 0 errors." Also in the ReportServerDB, there are corresponding report entries in…
Anshul
  • 13
  • 5
0
votes
1 answer

SSRS Sum Amounts with different columns based on an expression

So i am trying to sum columns based on a condition from one group to another. The first column is the expression that counts how many Meters are in that group by company. in the photo it shows eight by that company that have a value of meter,…
Kadmiel
  • 1
  • 2
0
votes
1 answer

SSRS Report document map link goes to page before (another subreport) because the subreport it refers to contains a page break before

I'm using SSRS Report Builder to modify a report that I am currently very happy with. It is composed of several sub-reports, each inside their own rectangle on the main report. I am trying to add a Document Map so that our users can more easily…
Jon Friedman
  • 64
  • 1
  • 10
0
votes
1 answer

Export to pdf overflowing to different page

I am formatting reports and while previewing the page is overflowing I would like to have Tablix and 2 charts on a single page. Please see below: I made sure there are no Page breaks in either Tablix or the charts... I checked Report -> Report…
Aruna Raghunam
  • 903
  • 7
  • 22
  • 43
0
votes
1 answer

SSRS INSTR Compare function when both fields are blank

I'm comparing 2 fields in SSRS using the instr function and giving a conditional color format when one of the fields is different. The below code works perfectly except when both fields are blank or have nothing. When they are both blank or have…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
0
votes
0 answers

SSRS Switch Statement

I have a matrix where I am calculating the Total depending on the other textbox value. This is my expression which calculate Total. If any of the box contains "*" value in SSRS. This expression is applied on total…
Avinash Kumar
  • 41
  • 1
  • 11
0
votes
0 answers

Can SSRS 2008 be used by hosting reportserver and reportservertempdb in SQL Server 2014?

Can SQL Server Reporting Service 2008 be used by hosting ReportServer and ReportServerTempdb in SQL Server 2014?
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
1 answer

Format number in table in SSRS

I need to add a thousand separator to numbers in a table in a report in SSRS. I am using SQL server 2008 R2. There are plenty of examples when using a textbox but I tried changing the number to a string using an expression and it does nothing. This…
Gloria Santin
  • 2,066
  • 3
  • 51
  • 124
0
votes
1 answer

SSRS: Varying functionality by environment

Is there a recommended way to vary SSRS report behavior by environment? For example, I have a click action that goes to a URL that will be different in each environment. I'd prefer a clean solution, rather than editing the report file before each…
awright
  • 1,224
  • 1
  • 13
  • 23
0
votes
1 answer

SSRS RDL file - command Text - RAISE ERROR

Can we add RAISE ERROR in the command text of the RDL file for an SSRS Report? My report is creating a blank PDF file due to missing data in the DB. I want to check the data, and if no data is found I need to raise the error. Is that possible? Or…
Sahi
  • 1,454
  • 1
  • 13
  • 32
0
votes
1 answer

SSRS Total Count calculation if value is less than threshold

I have a very unique question & i have read countless topics on it, not found a correct answer. Please help me in this. I have a matrix where i'm calculating the count of all Satisfied, Very safistied, neither satisfied nor unsatisfied or very…
Avinash Kumar
  • 41
  • 1
  • 11
0
votes
1 answer

Cannot go back to main ssrs report from a drill thru report in Chrome report viewer

I have a SSRS report with includes a Drill Through report. When I run the report from Report Manager and click the link to go to the Drill Through Report, there is a 'Back' button so the user can go back to the main report. When I display this same…
Gloria Santin
  • 2,066
  • 3
  • 51
  • 124
1 2 3
…
99 100