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
0 answers

SSRS 2008 r2 report freezes at loading

I am using SQL Server 2008 R2 Service Pack 1. The problem is that some reports freeze at loading stage when executed in IE 11. The same reports run with no problem when we use IE9 on another workstation. So I believe the problem has to do with IE11…
Bonzay
  • 740
  • 2
  • 10
  • 29
0
votes
1 answer

SSRS Pivot with Dynamic Columns

My Query is like below for Table..., Create Table t_raw ( Month nvarchar(255), Name nvarchar(255), Clear nvarchar(255), Contact nvarchar(255), Viewed nvarchar(255), Clicks float ) Insert Into t_raw…
Pandu
  • 3
  • 5
0
votes
1 answer

Repeat entire Table data on multiple pages - SSRS

I currently building one report in which the same data has to be repeated on multiple pages. - So, I have a field (Quantity) based on which I have to decide the times' data has to be displayed. For example, if the quantity is 5, the report has to…
user2320387
  • 19
  • 1
0
votes
1 answer

SSRS add group to existing rdl file

For an SSRS report (Visual Studio 2015), how does one add a group (for visual effect) to an existing rdl file? I already have "group by" in my .SQL query, but I am referring to a tablix group? [My underlying SQL system that the SSRS gets data from…
JosephDoggie
  • 1,514
  • 4
  • 27
  • 57
0
votes
1 answer

Add a Drill down to secondary report in Report Builder

I have written two reports in Report Builder. both reports use data from a property table so have unique identifiers eg Property ID. I am trying to create a drill down from report A so that when you click on a row, it will open up a sub report…
Freddie
  • 51
  • 1
  • 2
  • 12
0
votes
2 answers

Sharepoint SSRS blank report with no errors

I have an SSRS (2008 R2) instance running in SharePoint (2010) integrated mode running on IIS (7.5.7600.16385), and I have several reports that run for around 10 minutes then the report loading spinner goes away and we're left with a blank white…
MAW74656
  • 3,449
  • 21
  • 71
  • 118
0
votes
3 answers

SSRS 'where clause'

I've got a table that contains sales information for several companies. Each sales transaction the company makes is stored in the table, and the week of the year (1-52) that the sale took place within is stored also. Here's a small example of the…
Aaron
  • 75
  • 7
0
votes
0 answers

SSRS 2008 Lookup prior dataset row

I am using Microsoft SQL Server Report Builder 2008 and I am dealing with a report that shows the user various bit of information about a student enrolled in a class. A user requested a new feature to show the date that the pre-requisite class was…
J Gil
  • 1
  • 1
0
votes
2 answers

SSRS in VS2017 - query runs in Query Designer but doesn't display in report

I'm developing an ssrs report in VS2017. I changed the query, in Query Designer using the same data set with the same field names. When I run the query, I get the data I expect but when I run the report, it doesn't. The data in query designer is: …
user2284341
  • 661
  • 4
  • 17
  • 38
0
votes
1 answer

Intermittent errors while loading SSRS 2008 R2 report from client machine

Below are the errors which I am getting in different versions of the browser while loading SSRS report from the client machine. The reports are working fine on the server without any error. In…
RahulGo8u
  • 148
  • 2
  • 19
0
votes
1 answer

How to display data in vertically in different columns in SSRS Report

I have an ssrs report which display data in a table just like image1. image1 (Vertical) abcd efgh ijkl mnop qrst uvwx I need to display data vertically in one table with different columns to avoid extra pages. Just like image2. image2 abcd IJKL…
maddy
  • 50
  • 1
  • 1
  • 10
0
votes
1 answer

SSRS - Use the result from one textbox to populate a field from a dataset

I am writing a report in SSRS. Can i use the text result from a textbox to pull a Field from one of my datasets? For example: In Textbox1, i have the formula =First(Fields!Metric1.Value, "Dataset2") which produces the text result: "BikeSales" in…
Keyes Kennard
  • 1
  • 1
0
votes
1 answer

How to change the position of on of the Grouped columns in SSRS

I was creating an SSRS report show customer ledger. I wanted to merge the cells of Date, Mode and Balance columns for same dates. I did it using the row grouping. Screenshots are given below. Design View Report Preview But I couldn't change the…
Hamzathussadique Mankarathodi
  • 13
  • 1
  • 6
0
votes
1 answer

Day add in SSRS for weekday

i want to achieve the following I want to set the default date to the following business day. That would add one day for all weekdays unless it is Friday, if day is Friday than it add 3 days for Friday. I am using the statement below but it is not…
A.Goutam
  • 3,422
  • 9
  • 42
  • 90
0
votes
2 answers

SSRS How to Start tablix at the same position of every page

I have a tablix that starts at the .87 on the y-axis of the first page. It will print a number of rows and columns before going to the next page. When printing on subsequent pages, it will print at the very top of the page (y-axis 0). Is there a…
C Henry
  • 148
  • 12
1 2 3
…
99 100