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 set a parameter in SSRS subreport that is a static list

I have a SSRS report that uses a drill thru subreport. The subreport is used 3 times in the main report and takes several parameters. In 2 of the subreports I set one of the parameters, SexAtBirth, using a static value, Female or Male. Here is a…
Gloria Santin
  • 2,066
  • 3
  • 51
  • 124
0
votes
1 answer

Return Corresponding Year in SSRS Expression

I have a start date and an end date in my report. Now when the report is run, we want to display if it's current year and if so, display "2016" else, using the end date as a guide, display the year judging by the end date. How do I accomplish this…
UpwardD
  • 739
  • 4
  • 12
  • 36
0
votes
2 answers

SSRS Report Parameters passed out

I am currently building a number of logging and analysis tools to keep tabs on our SQL environment. We are currently using SQL Server 2014. What I want to do is keep check of all the parameters that are passed to our reports during the day. All of…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
0 answers

Oracle - Aggregation in Materialized Views

Let me just explain my problem with a simple example - I have this table - Now, this table is queried with a date range parameter. The result will be sum of value for each Type for that date range. Like if I query for From = "12/1/2016" and To =…
Prateek Singh
  • 863
  • 1
  • 8
  • 28
0
votes
1 answer

SSRS : Set bottom border line of a table row at each page end

Problem : I have a requirement where i need to set bottom border to the last row on each page of an SQL Server Reporting Services (SSRS) report, Now I have a large table (tablix) that splits across several pages. How can i do this for per page for…
stoner
  • 417
  • 2
  • 12
  • 22
0
votes
1 answer

How to increase the maxReceivedMessageSize calling a WCF from ssrs report?

I'm calling a WCF to obtain database information from a SSRS report, it works retrieving small amounts of data, but with bigger queries, it throws an exception The maximum message size quota for incoming messages (65536) has been…
Daniel Forero
  • 41
  • 8
0
votes
2 answers

SSRS column filters

According to user requirement, We need to have the filter functionality on each column of the SSRS report after it is rendered. The required functionality is similar to which is provided by kendo grid or jQuery DataTable (see screenshot). As per…
adesh
  • 11
  • 2
  • 9
0
votes
1 answer

Calculating Total using IIF expression

I have a report section where it calculate the TOTAL column by dividing the total of "Call Opportunities (PW)" and "LCAs Accepted(PW)". For example, 735.0 / 67 should be 9.1, but it is averaging it. I have to code below, but not sure how to change…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

Set static height for bar chart using SSRS

I have a bar chart and the business has requested that I set the height for each bar at a static height i.e. 40 for the entire result set and then have the data labels displayed above the bar. How can I set the output to a static height for each bar…
C Layne
  • 33
  • 2
  • 7
0
votes
0 answers

SSRS reports does not show all the data in view

SSRS report does not pull all the data from the view that its bind to. This view when run sql server shows more than 250 records but when this same view is integrated with SSRS report it shows very few of them less than 10 records. It does not have…
Skanda
  • 131
  • 4
  • 14
0
votes
1 answer

SSRS Switch Sort

I have the following switch statement on a text box: =Switch(Fields!Column1.Value ="V10", "A", Fields!Column1.Value ="V2", "B", Fields!CColumn1.Value ="V7", "C") Then it has been sorted on Fields!Column1.Value. When I run the report the data it…
netraider
  • 267
  • 2
  • 8
  • 16
0
votes
2 answers

SSRS Date Parameters

Please could someone provide some insight to the situation below? I am looking for a Date expression (LAST Day of the Following Month) which I would like to use it on my "End Date Parameter". I have expression below, but for some reason it is only…
satya
  • 313
  • 1
  • 7
  • 15
0
votes
1 answer

SSRS - Lookup set to ignore the " " values

I have created a lookupset below: =RTRIM(LTRIM(Join(LookupSet(Fields!Fund_Family.Value & Fields!Portfolio_Company_Name.Value,Fields!Fund_Family.Value & Fields!Portfolio_Company_Name.Value,Fields!Security_Type.Value, "DataSet1")," /…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
0 answers

SSRS get old scheduled report files

I am using daily SSRS reports to send email as Excel. Now i lost my some data from server. I don't have backup of Database. I can't get files from email which was send to client. Is there any way that i can receive the file which emailed from SSRS?
Jigar Parekh
  • 595
  • 10
  • 23
0
votes
1 answer

SSRS: Raising records up to a higher group level

In SSRS, I want to display some exceptional records interspersed with grouped records. Exceptional records should be displayed at a higher group level. All records are from the same DataSet, but exceptional records can be identified with a boolean…
awright
  • 1,224
  • 1
  • 13
  • 23
1 2 3
…
99 100