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 Parameter Date Expression

I am looking for a default Date Parameter Expression which i would like to SSRS Start Date Time field to a specific date i.e 25/01/2017 07:00:00:000 I currently have an expression which will only give me a date =DateValue("January 25,2017") Could…
satya
  • 313
  • 1
  • 7
  • 15
0
votes
2 answers

Attemted to divide by zero error in SSRS Expression

I have below Expression which I am using in my report =IIF((Sum(Fields!Starts.Value)-Sum(Fields!Withdrawn.Value))=0, Nothing, (Sum(Fields!Starts.Value)-Sum(Fields!Withdrawn.Value))/(Max(Fields!Year1Starts.Value))) When I run the report…
Aruna Raghunam
  • 903
  • 7
  • 22
  • 43
0
votes
1 answer

SSRS report for check printout

I need to build the following check printout in SSRS, and it works fine if I have up to 12 rows, as everything fits on one page. So the page is divided into 3 equal parts: own copy, beneficiary copy (same as own copy), and the check itself. When I…
Dimitar Dimitrov
  • 109
  • 1
  • 2
  • 8
0
votes
1 answer

SSRS Static image in report Page irrespective of no of Pages not in header and footer

First, There is no header and footer in Page i have a requirement to show a image of length exact of a page and width 1in and That image should repeat in every page as it irrespective of data that comes Ex: if i run that report on one record the…
Prasanth
  • 3
  • 5
0
votes
0 answers

ssrs report returns no data and there is no error

I am trying to access report via reporting server in internet explorer. after i give the credentials and parameters it shows nothing. And it doesn't shows any error. When i try to access report via website it doesn't shows any data. I am using…
Anupa Sankar
  • 491
  • 2
  • 7
  • 17
0
votes
1 answer

Selecting either one or ALL the values in a parameter in SSRS 2008 R2

I am working on a reporting project in SSRS. I have a parameter called 'customer'. The values for this parameter are now populated with the sql query. I want to restrict this parameter such that the user should be able to select either one customer…
Arockia Nirmal
  • 737
  • 1
  • 6
  • 20
0
votes
1 answer

SSRS Network/Working days, using date parameter

im using the below function to get network days between the submission date and the day i run the report; at the same time i am using a date parameter in my SSRS to get the tickets between these dates , my problem is i need the end date of the…
Mustafa El-Gamal
  • 31
  • 1
  • 4
0
votes
1 answer

Expression to find total time in minutes not working when amended to include DateDiff

I have 2 tablix in my report. I need to find the total time in hours and minutes ignoring any day counts. In the appointments tablix I am using expression =FLOOR(Sum(Fields!actualdurationminutes.Value) / 60) & ":" & RIGHT("0" &…
Caroline Allen
  • 183
  • 14
0
votes
1 answer

SSRS Report Generate by using selected columns

How to do this report using SSRS?
Ajit Kumar
  • 65
  • 1
  • 1
  • 3
0
votes
0 answers

why returning data from #temptable instead of @tempTable giving timeout error in ssrs 2008

I got a report in SSRS 2008, which is including a table, called Results. This table is connected to a Stored Procedure, called MyResults. The SP returns the output like: ... select Name,Group,Amount from @tabledata where Amount > 50 END where…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

SSRS Report Row Hide issue

I am new to SSRS Reports, I am facing following problem : I need to show some data and its total. But total must be in different formats like Date wise Total, Employee Wise Total, Area Wise Total . So, I added these groups like Parent Group : Area,…
Azhar
  • 13
  • 3
0
votes
1 answer

Different "IF" statement for different outcomes in field - SSRS

Good day, I am creating a report where I want to assign a unique "IF"statement depending on the variables in a field. For example, in a column, if a row displays "MCAD", I want it to calculate this formula in the column next to it:…
MarioS
  • 262
  • 1
  • 3
  • 12
0
votes
1 answer

SSRS 2008 row visibility issue

I am facing following scenario : I have two values A and B and I need to Hide and show it based on ssrs expression. My Conditions : If A = 1 and B = 1 show row If A = 1 and B = 0 Show row If A = 0 and B = 1 Show row If A = 0 and B = 0 Hide Row (I…
Azhar
  • 13
  • 3
0
votes
1 answer

SSRS Total count error

I have a weird problem with SSRS and have studied countless Post/material for this unique problem with SSRS. Need some clarification. I have a matrix to calculate the total of employees who has done survey in dataset. In my database, for every…
Avinash Kumar
  • 41
  • 1
  • 11
0
votes
1 answer

SSRS Finishes but does not return to the caller

We have ssrs service with executiontimeout set as 2.5 hr. We also have timeout setting set to 12 hr before calling the ReportExecutionService render() method. The problem is that everytime any ssrs run for more than 1 hr, fails to return the call to…
Zeus
  • 3,091
  • 6
  • 47
  • 60
1 2 3
…
99 100