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 difference between 2 negative numbers gives negative result instead of positive [SSRS]

Using SQL Server 2014, I have SSRS report with matrix inside. Problem: difference between 2 negative numbers doesn't give sum The expression of field is: = ReportItems!Textbox1.value - ReportItems!Textbox2.value In report it looks like: Textbox1 …
Dmitry
  • 305
  • 5
  • 21
0
votes
1 answer

SSRS Visibility IFNOTHING or Value >=

=IIF(IsNothing(Fields!actual_end.Value)) or (Fields!actual_end.Value >= DATEADD("d",-7,TODAY()),false, true) I want the row to be visible if the value is blank or if the value is greater than or equal to one week ago. Having a little trouble with…
Femmer
  • 133
  • 12
0
votes
1 answer

SSRS Filter by parameter and Value condition

I am trying to add an parameter that will allow the user to filter by unit Cost. I.e. If for parameter Unit cost, User select "All Costs", it will not perform any filter and will show all items. However, if for the parameter Unit cost, the user…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
0 answers

Dyanamic Parameters in SSRS Expression is Possible?

I have a report with a parameter. The parameter value can be passed from my Application. If the parameter is not passed from UI, it is considered as NULL. I am using IndexOf() on that parameter. Since it is null i am getting error. I want to set…
user3403111
  • 65
  • 2
  • 9
0
votes
0 answers

Can a dataset parameter be used in reportviewer? If so, how?

I use VS2012 to develop reports. I have a report that has 4 parameters. Each of those parameters has a dataset associated with it. When I run the report in VS2012 Preview it works fine. After I have uploaded it to the server using a web framework it…
SSM
  • 1
0
votes
0 answers

SSRS: Optional Multi-Select Parameter

I have been struggling with this issue for a while and thought I'd ask somewhere. My end goal is an empty text box parameter that allows multiple values... But is completely optional. I cannot use a drop-down multi-select because I have ~100k…
user2907866
  • 1
  • 1
0
votes
1 answer

Changing UTC Time to Local Time using scalar-valued function with Select statements SQL

I've been trying to get this work over two days and still stuck. Any assistance or tips would be greatly appreciated. Creating a function for the date conversion: CREATE FUNCTION LocalDateFromUTCTime ( @UTCDateTime datetime ) RETURNS…
user3571153
  • 129
  • 1
  • 9
0
votes
0 answers

SSRS 2008 Values on X and Y axis

I have a report in ms excel that needs to be converted to SSRS report. the data below was used from CHECKIN_TBL CheckINDate CheckInTime MinsWaitKid MinsWaitAdult 17/10/2016 00:54:21 3261 1620 19/10/2016 00:52:32 3152 1617 21/10/2016 …
JonWay
  • 1,585
  • 17
  • 37
0
votes
1 answer

SSRS Correcting #Error

I have an SSRS expression where sometimes the denominator is 0, and I get a #DIV error so I added a +.0001 to eliminate the #DIV error, but when I add a FLOOR syntax I get an #ERROR, and I can't figure out to remove the #ERROR. The result should be…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

SSRS Action Inserting Hyperlink to Open an Application

I've done enough research to insert Hyperlinks into SSRS Data fields but so far no luck on trying to insert a url protocol to open up a third party application. I'm doing the steps below to add an action to insert the hyperlink using VS2012. 1.In…
user3571153
  • 129
  • 1
  • 9
0
votes
1 answer

SSRS how to add groups to a detail row

I am re-writting this because I didn't communicate my problem correctly. Given these sample tables of data: STUDENT: Name, DOB, Council, ClassId CLASS: ClassId, Teacher, StudentGradeId GRADE: StudentId, ClassId, Grade I have made a report that looks…
BattlFrog
  • 3,370
  • 8
  • 56
  • 86
0
votes
1 answer

How do I find all reports in SSRS where a field is mentioned in the SQL

How do I find the column/field EpiHRG where it is referenced in the SQL code of an SSRS report other than manually going through 100's.
Simon
  • 391
  • 4
  • 16
0
votes
1 answer

Displaying data based on condition in SSRS

I am developing a report in SSRS and need help with displaying the data based on a few conditions. 2 CONDITIONS: (Please refer the image below) 1) 3 days in the Current Full Week with % above the 2% bench mark It means that if a Restaurant R2 and R5…
Shivang
  • 231
  • 1
  • 5
  • 17
0
votes
1 answer

SSRS Subscription Paramter for Second dataset not updating

I'm running into an issue with an SSRS subscription report that I built. Basically I have 2 datasets and 1 parameter that gets fed to both of them called @ReportDate. @ReportDate has a default value =Today(). When the report runs every morning…
BrandedSwordsMan
  • 11
  • 3
0
votes
1 answer

Get 1 value of each date SSRS

Ussing SSRS, I have data with duplicate values in Field1. I need to get only 1 value of each month. Field1 | Date | ---------------------------------- 30 | 01.01.1990 | 30 | 01.01.1990 | …
Dmitry
  • 305
  • 5
  • 21
1 2 3
…
99 100