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

The permissions granted to the user are insufficient to perform this operation. (RsAccessDenied)

I need some help with this error: The user does not have the required permissions. Verify that sufficient permissions have been granted and that the Windows User Account Control (UAC) restrictions have been handled. Im executing ie as…
user3865905
  • 15
  • 2
  • 5
0
votes
1 answer

SSRS: Not sure how to create matrix with 2 pivots

I have data like so: NAME TITLE SALARY HIREDATE ------------------------------- HANK BOSS 100 1/1/2016 JOHN JERK 100 1/1/2015 MIKE PUNK 200 1/1/2014 We want to show this data as such: NAME HANK JOHN …
enforge
  • 915
  • 3
  • 10
  • 26
0
votes
1 answer

SSRS Static Date Expression

I'm creating an SSRS report and I need to set a begin date so that it always returns 12/21/2015. Is there an expression to use in SSRS to bring back a static date that will never change? I've been chewing on this for awhile and searching…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
0
votes
1 answer

Table Visibility SSRS

I am very new to SSRS, being transferred over to reporting from my current position in a couple of months. I am trying to have my table be visible or hidden based on a particular parameter. If @rate is left blank I want the table to be hidden, if…
Femmer
  • 133
  • 12
0
votes
2 answers

SSRS different number formats on the same column

I am trying format 1 column to have the number format based on what the value is: My current table I am trying to get it to be a percentage except when the description says flat tax, I then want it to be a currency. Any ideas? SELECT t1.property,…
Femmer
  • 133
  • 12
0
votes
1 answer

Multilevel grouping in a single column - ssrs 2008 r2

I have been trying to add a multiplevel grouping in the job field column as shown below (sample excel sheet template), Column Job has job code and then visit dates grouped by job code. Is there any way to achieve to this in SSRS 2008 r2? It works if…
user1263981
  • 2,953
  • 8
  • 57
  • 98
0
votes
0 answers

How to create SSRS Forms?

I've an SSRS report that requires some data input at the runtime, i.e. most of the data on the report comes from SQL Server, however, there are some fields that needs to be input by the user at the run time. Data input in these fields will only be…
SJaka
  • 712
  • 13
  • 40
0
votes
1 answer

SSRS 2008 R2 Report. Change month grouping from calender month

I have a report that outputs relatively simple counts of clients. It outputs everything from a system as data parameters are not required. They want to see everything. The thing that is throwing me is, they want months grouped by the 24th of one…
ChipChipowsky
  • 3
  • 3
0
votes
0 answers

SSRS Report Manager language suddenly switching

We've been experiencing lately some issues with SSRS report manager language, which switches suddenly from French to English (happened 2 times), and vice versa. Note that the clients browsers are in French and report manager is still showing in…
Zakaria Belghiti
  • 521
  • 3
  • 8
  • 19
0
votes
1 answer

SSRS Grouping within Totals

If I have 2 row groups; year and status, is it possible to show totals for all years grouped by status? Year Status Value 2014 Open 100 Closed 200 2015 Open 200 Closed 300 Total Open 300 Closed 500 Until now I have always…
Lee Tickett
  • 5,847
  • 8
  • 31
  • 55
0
votes
0 answers

Splitting values in a pie chart

I'm filling a report with a table that looks like this: Code | Data AAGU | AAGU = 41.43%; BCGS = 40.68%; BCGS | BCGS = 41.43%; OTHER = 34.98%; XXX = 2%; So my question is, how can I create a chart where each slice is one of the…
Luis Lavieri
  • 4,064
  • 6
  • 39
  • 69
0
votes
1 answer

SSRS Trying to add a page break between 2 Subreports which are grouped in parent.rdl

So I have a report that I was able to get almost exactly how I wanted it, but I can't manage to get a page break between the 2 subreports. Help would be highly appreciated. I have 3 reports PARENT.rdl SUBREPORT_1.rdl SUBREPORT_2.rdl SUBREPORT_1…
Jay
  • 455
  • 3
  • 17
  • 34
0
votes
1 answer

Rdlc Showing information in square blocks like form

Actually I have to create a report in rdlc report viewer. In that I want to show information in blocks form like each block will contain 1 character. for ex. I have a string "Test", i want to show like 'T' in one box, 'e' in another and so on... I…
Abhinav
  • 353
  • 1
  • 7
  • 19
0
votes
1 answer

SSRS multiple datasets: How to display only records that are not in both Datasets

I'm using SSRS 2008 R2 and building a report with Report Builder 3.0. I need to query 2 databases, a Central one here at headquarters and a Satellite one in Australia. They both have a table called Buyers. The satellite site just contains a smaller…
KD84
  • 15
  • 1
  • 8
0
votes
1 answer

SSRS 2016 : Moving the position of the entire parameter box from top to left

I want to move the entire parameter panel that defaults to the top in SSRS 2016 to the left of the report. Has anyone done this in the past? I can reorder the individual parameters in the panel but I want to move all these parameters to the left…
CarbonD1225
  • 851
  • 6
  • 24
  • 39
1 2 3
…
99 100