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 2008 ReportViewer page 0 of 0

I am rendering a series of reports in a winform webbrowser passing parameters directly to the SSRS reports directly in the URL…
trapspring
  • 56
  • 7
0
votes
2 answers

Need to Aggregate on the Last Month for a Grouped Report

I have a dataset that looks like the following: | Location | Category |Item Name | Month | QTY | | -------- | -------- | -------- | -------- | --- | | NY | Hardware | Screw | Jan 2017 | 100 | | NY | Hardware | Screw | Feb 2017 |…
FlyFish
  • 491
  • 5
  • 22
0
votes
1 answer

Changing color of body report, depending on value in table

I have report in SQL Server 2008. Report has a parameter, parameter values: organization1 organization2 organization3 organization4 To display a list of parameter with values, I used "Available Values" "Get values from a query". If value of…
Arthur Brown
  • 5
  • 1
  • 3
0
votes
1 answer

SSRS Sum Expression for Adding Percent Column

I think I've exhausted my searches with Google. Before it gets suggested, and I know it will, I cannot update my stored procedure to do this because of how the data is returned. I have to do this calculation in the report. My table is grouped by…
JohnD
  • 43
  • 2
  • 9
0
votes
2 answers

SSRS using Subtract Function in Filters

I am creating a report that shows the performance on a monthly basis.I have historic data from 200101. When I create and preview the report all data shows from 200101 to most recent month. I want to limit the number of months to be the most recent…
AKR
  • 13
  • 5
0
votes
1 answer

SSRS not displaying external image with parameter source in asp.net remote Report

I have asp.net application in framework 4.0. i have created one image folder in my project, images are added in that folder. and i have SSRS report deployed on same server.i am using external image source but images from the reports are not…
Vinayak Gurav
  • 35
  • 4
0
votes
1 answer

'All' filter on report causing error "[BC30516] Overload resolution failed"

I'm trying to add a filter to a report. I thought this would give me all records when “All” is selected since the filter wouldn’t take effect and if it didn’t = “All” then it would kick off the filter. ‌=iif(Parameters!vType.Value <> "All",…
Shaves
  • 884
  • 5
  • 16
  • 46
0
votes
1 answer

SSRS chart, how to prevent horizontal axis categories displaying when value is 0

I've placed a simple bar chart into an SSRS report which is designed to display a series of Consultant Names (along the x axis), with a corresponding count of patients who are flagged as being in the category ">18 Weeks" (on the y axis), based on…
Jon295087
  • 731
  • 1
  • 8
  • 28
0
votes
2 answers

Access rs:parameterLanguage URL parameter in RDL (Microsoft Sql Server Reporting Services)

My software runs Sql Server Reporting Services (2008 and 2016) reports via url, like…
Palladian1881
  • 145
  • 6
0
votes
1 answer

SSRS Report Parameters and Report Setup System

I've got a front-end application that pulls a report on top of SQL lives "Report Setup System" software that pulls the specific SSRS template/parameters that pass them to SQL procedure. the report path specifies a given SSRS file, and no parameters…
Elizabeth
  • 719
  • 1
  • 14
  • 27
0
votes
0 answers

SSRS to get Field Based on Expression, based on working days

I want to display the header of my ssrs report in the format as in excel... Ignore the details in the table :) I am trying to display the DAY1, Day2 header in my SSRS as shows in excel. Logic Says (if today is working day then until the last working…
Ruchi
  • 146
  • 1
  • 8
0
votes
1 answer

Use MSBuild to define SSRS projects RDL Schema version

I am working on a Continuous Integration project that builds a Microsoft SSRS solution. However the RDL files produced are not always of the same schema version, some of them appear in 2008 format, and others in 2010 etc as per the…
Mark
  • 501
  • 2
  • 11
  • 28
0
votes
1 answer

Alternate Row Colour SSRS not working

i currently have the row background colour set with expression that is; =IIF(ROWNUMBER(NOTHING) MOD 2,"White","Silver") However on some rows it seems that colour is not alternating and staying the same like the image below. Does any one know why…
KCodeR
  • 121
  • 5
  • 19
0
votes
1 answer

SSRS hidden row become visible with multi group toggle

I have multi group query I want the only first one to show and plus sign next to it so when user click on the plus sign it opens the lower level group and it has another plus sign +USA +Australia When click the sign next to USA it should show…
asmgx
  • 7,328
  • 15
  • 82
  • 143
0
votes
1 answer

ssrs how to remove particular rows conditionally

In my ssrs report, I have a column "Total" and it contains integer values. Now I want to remove the entire row from report, where value of column Total = -1.
A.G
  • 11
  • 2
1 2 3
…
99 100