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 report display blank on browser for 2997 rows of data and stored procedure timing is 42 secounds

all data displayed in stored procedure but not in SSRS report on internet explorer,2997 rows of data and stored procedure timing is 42 secounds. if filter is applied then working properly but if by default all is selected then can't display.
user7413238
  • 1
  • 4
0
votes
1 answer

SSRS Row Comparing and highlighting differences

I'm using the following iif statement to compare 2 different rows using the conditional format to change the color to Red if the field is different. I've been using this method on the same report and some fields it works and some fields it doesn't…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
0
votes
1 answer

SSRS Range charts series positon

I have created a gantt chart using range bar but the series is never positioning at 0. Although intervals and duration is dynamic but I want the series to start from axis. Which property needs to be modified for this. In the below image the series…
Shivan Bhatia
  • 38
  • 2
  • 10
0
votes
0 answers

SSRS "flatten" sql query

I have data coming into a report (from a stored procedure I can't edit) in the following form: RecordID | Label | Value 1 Name Alice Arnold 1 Addr 123 Main St 1 City Hometown 1 State US 2 …
D.R.
  • 1,199
  • 5
  • 19
  • 42
0
votes
1 answer

SSRS 2008R2 Grouped bar graph with aggregate line graph

I have a set of n product quantities vs dates and I want to display in category groups for the products and the series is the date as a bar graph. I then want to place an aggregated total quantity as a line graph so 1 line graph and n bar graphs on…
Shiv
  • 1,274
  • 1
  • 19
  • 23
0
votes
1 answer

SSRS Dynamic Datasource selection based on server

This is one of those "is it possible?" questions. I'm looking to create a report that will be deployed to 3 different servers (all sql2008R2) each has its own shared data-source with different credentials. When run against each server is it possible…
Mr.B
  • 397
  • 5
  • 16
0
votes
1 answer

get total from two different datasets into a third different tablix ssrs

Here I am, again with another doubt. Here is my problem: I have a report where I show ALL the incomes and expenses of the company for the last two days, which i managed by placing a column group grouping the columns by the date Originally, the…
Rodrigo Jimenez
  • 37
  • 8
0
votes
2 answers

Lookupset with duplicate records SUM not working SSRS 2008

I have the below data in a dataset called Questions and all IDs in another dataset called Dataset1 ID Answer 1 Yes 2 Yes 2 No 2 Yes 3 No My expected output should be as below ID Yes No 1 1 0 2 2 1 3 0 …
sparc
  • 345
  • 1
  • 2
  • 13
0
votes
2 answers

Remove Hyperlink format in SSRS

I'm currently working on a report in which one of the textboxes has the action property of launching another report. I would love to now how to remove the hyperlink like format to the text. I already setted the text decorations to None. Texbotx and…
Rodrigo Jimenez
  • 37
  • 8
0
votes
1 answer

Calculate growth percentage inside a group column in SSRS

I'm currently bulding a report than includes a table with column group with the group on value for Month, so it would dinamically create the month column according to the range selected by my user. table design What is needed is that, along every…
Rodrigo Jimenez
  • 37
  • 8
0
votes
1 answer

ssrs order by case isnull - query works, ssrs errors

Query works and sorts as it should. But query errors when part of ssrs dataset. Errors narrowed down to order by case expressions as shown. Syntax is accepted. First error message during run: "An error has occurred during report processing. …
Gary Thomann
  • 576
  • 6
  • 17
0
votes
2 answers

Pivot column in SSRS

I have report where I am using that stored procedure to create a report using SSRS. The report currently show data like below (it has more additional columns) : What I want is at the backend (stored procedure level or in SSRS) want the filter the…
deep
  • 41
  • 1
  • 12
0
votes
1 answer

SSRS How to replicate Column Total in each row

Team Sales TotalSales A 10 70 B 25 70 C 30 70 D 5 70 I have a dataset for an example please refer the above. The total sales for all 4 teams are 70. I wanted to replicate Grandtotal e.g.70 for each…
DataMan
  • 139
  • 1
  • 2
  • 14
0
votes
1 answer

SSRS How to calculate Moving Range

Year Sales Moving Range 2000 6461 2001 3459 -3002 2002 4595 1136 2003 9726 5131 2004 7109 -2617 2005 8576 1467 2006 2962 -5614 2007 7203 4241 I have a dataset similar to the above and need to…
DataMan
  • 139
  • 1
  • 2
  • 14
0
votes
2 answers

Drill down a column in SSRS Report base on a value

I have reports that have drill downs. Currently, there are some columns with zero values and users are still able to click on that empty or zero cell and access a blank report. We want to take off this ability so that when a cell or column is zero…
UpwardD
  • 739
  • 4
  • 12
  • 36
1 2 3
…
99 100