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

SSRS - Limit users to upload certain file types?

Is it possible to limit the types of files that can be uploaded into SSRS 2008? So far I have only been able to completely restrict file upload. We just want to limit it to certain file types. Thanks!
Henk Huisman
  • 3
  • 1
0
votes
2 answers

What is the correct syntax in Expression to count date column rows if both parameter values are in date?

I have 2 parameters in my query @selectedMonth and @selectedYear. I have 5 different date columns and I need to count all rows for each column where the month and year in the date match the parameters selected. I have set up each parameter with a…
Caroline Allen
  • 183
  • 14
0
votes
1 answer

SSRS - Can you compute a difference between 2 different Tabllixes?

Hi all, Is it possible to calculate a difference between two different tablixes in an SSRS like the below and show in the 'Delta' column in the top tablix? I have included the design format as well (on the right)
Matthew Buffett
  • 1
0
votes
1 answer

Does SSRS preview create phantom error messages?

I am using Visual Studio 2017 to design a SSRS report. Are some of the error messages one sees when they click on the Preview button actually meaningless? For example, I get, "The tablix 'Tablix2' is invalid. The value for the DataSetName property…
xarzu
  • 8,657
  • 40
  • 108
  • 160
0
votes
1 answer

SSRS Returning incorrect WW

I have an SSRS report (2008R2 3.0) that uses parameter filters for workweek in the format YYYYWW. In 2018 there were 52 work weeks based on the ISO standard (source) . For default parameter value I select the last WW using the following…
AJQShake
  • 89
  • 1
  • 1
  • 9
0
votes
1 answer

SSRS Report Query

Is it possible to insert a clickable + sign in an SSRS report column header? If "yes," then, on clicking that operator, I would like to display other columns which have been hidden by default. For example, as shown in the attached screen shot, to…
Chintan Dave
  • 1
  • 1
0
votes
1 answer

How to produce a Gregorian Calendar in SSRS like is shown in the image

How can I produce in SSRS this Gregorian calendar (to choose a start date or an end date for a filter like is shown in the picture)? Should I use a gauge or something else?
Newbie SQL
  • 122
  • 13
0
votes
1 answer

Using an IN statement for query in SSRS

In an SSRS report I'm building, I've a query like the one below: SELECT ID, Name FROM TableA WHERE Name IN (@name) And then within SSRS, I have the parameter available values set to 'Get values from a query' and the Value field will be something…
peterbonar
  • 559
  • 3
  • 6
  • 24
0
votes
1 answer

Arrange Columns in SSRS Matrix by Label by Percent

I have a dataset like in the image below. I have used a Matrix in SSRS to unpivot the data. What I have is like in the second image below. You will notice that percentage columns are at the far right. But what customers want is the name of a…
UpwardD
  • 739
  • 4
  • 12
  • 36
0
votes
1 answer

SSRS 2008R2 optional page breaks for tablix that has 5 row groups on the tablix

I am trying to use an existing page break parameter in a new tablix that I added to an exisitng ssrs 2008 r2 report. I am trying the solution at…
user1816979
  • 511
  • 4
  • 13
  • 25
0
votes
1 answer

Mutually dependent parameters

Is it possible to change ONE parameter drop down values if ANOTHER parameter drop down values has been changed? For example, you have two parameters: drop down YEAR (simply populated int values from stored procedure: 2016,2017,2018) drop down…
Nat
  • 630
  • 1
  • 5
  • 17
0
votes
1 answer

Repeat Row Totals in a Matrix

I have created a Matrix as below. It shows the score for each month. Now I want to created another row to display the Row total in each cell (please see the table). I appreciate if someone can help me. Thank you M1 M2 M3 M4 M5 M6 M7 Score…
DataMan
  • 139
  • 1
  • 2
  • 14
0
votes
3 answers

SSRS access built-in functions from report vb code

I'm working on create a multilingual SSRS report for SQL Server 2008R2. To do that without external code and only get translation from DB, I need to use Lookup() built-in function in the section code of the report. I have the following expression…
GLNebiacolombo
  • 1
  • 2
0
votes
1 answer

Displaying SSRS Reports in Kentico Results in ClientID Errors, How to Interpret Documented Solution?

So I have deployed a report in SSRS, and I can view it at its hosting location at localhost. Now I'm trying to get the report to display in a ReportViewer control in a Kentico webpart. I get the error: "Internal error: ClientID reference before…
Marley Stacy
  • 100
  • 12
0
votes
2 answers

Calculate the count of rows in a table (SSRS grouping a table)

I have a table in ssrs as follows. It is grouped by System and souce description as shown below. I need to calcluate the difference after each grouping as follows Calucated Diiference = Initial - filtered - Final = 0. How do you get the values of…
xrx215
  • 747
  • 6
  • 22
  • 38
1 2 3
…
99 100