Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2008. More info in the tag.

This tag is for questions specific to SSRS 2008.

6153 questions
8
votes
1 answer

Grouping in SSRS?

i am new to the SSRS and Have data as below RCnt Jobnumber NJCT JD pmt flag cnt1 cnt2 2 001008 0 PRESSURE SEAL PSI Y 0 0 2 2 001008 0 PRESSURE SEAL PSI Y 0 0 10 2…
user2553512
8
votes
4 answers

use two different datasets in single report

I have two different-2 datasets with different fileds which are getting populated through two stored procedures with same input parameters.each datsets have different colums and no of columns around 180,my concern is how will i use these two…
Gurpreet Singh
  • 197
  • 3
  • 6
  • 14
8
votes
4 answers

SSRS Report Content Blank

I am having a problem running reports in Sql Server Reporting Services (SSRS) 2008 R2. After setting up the site, creating a few users, and uploading a few reports, I select a report to run, enter my parameters, and wait for the report to…
jtlovetteiii
  • 285
  • 1
  • 3
  • 8
8
votes
1 answer

How Do I Resolve Report Deployment Error When Referencing System.Core (4.0) under SSRS 2008R2

Preface: Development Environment: Visual Studio 2010 with BIDS + MSSQL 2012 on local box Production Environment: MSSQL 2008 R2 For Live Report Server I am having a problem with deploying a report when referencing System.Core in my report. The…
Hardrada
  • 728
  • 8
  • 19
8
votes
1 answer

Programmatically Export SSRS report from sharepoint using ReportService2010.asmx

I have to programmatically export ssrs reports to excel, added service refernce to http:/siteurl/_vti_bin/ReportServer/ReportService2010.asmx http:/siteurl/_vti_bin/ReportServer/ReportExecution2005.asmx Can somebody provide a working blog
vikas mehta
  • 440
  • 8
  • 22
8
votes
2 answers

Interactive sorting in tablix with column and row groupings

I'm trying to define interactive sorting in a tablix. The sorting should affect the row order. Attaching image of the tablix in order to explain what I'm trying to get: I already tried to define the column header with interactive sorting and get…
Gil Peretz
  • 2,399
  • 6
  • 28
  • 44
8
votes
1 answer

SSRS Reports - Hiding a Tablix doesn't shrink the space and move content after it up

I have a tablix with another tablix beneath it with 0 space between the bottom of the first tablix and the top of the second. When I change the Hidden property of the first tablix to true, it hides the tablix with empty space but doesn't move the…
pkr
  • 1,723
  • 5
  • 25
  • 43
8
votes
4 answers

how to fit content of reports so that we can print it on A4 size

I have created a report in ssrs 2008 r2.It is larger then the normal A4 size .So when i export the report in word i see it clearly but when i see print preview of the report in to the word its contents get cut from the right end.I think it is due to…
Sunil
  • 165
  • 1
  • 1
  • 9
8
votes
2 answers

How to create a report with sections and page breaks using SSRS

I'm trying to create a report that looks like this: using a select from this table: (fiddler here for query and data) CREATE TABLE StudentData ( id int PRIMARY KEY IDENTITY, name varchar(30), subject varchar(30), currentGrade…
Danny Cullen
  • 1,782
  • 5
  • 30
  • 47
8
votes
2 answers

SSRS check if user in group using Custom Assembly

I have created a Custom Assembly for my SSRS Project. The Custom Assembly has got 2 functions, IsInGroup and MyTest: using System; using System.Collections.Generic; using System.Text; using System.Security.Principal; namespace…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
8
votes
2 answers

Reporting services: Join all field on a dataset

In a report, I've a dataset with a filter(based on a MultiValue parameter). This dataset contains two field: Id and Name. I need to display somewhere the concatenation of all names: Name1 / Name2 / Name3 The problem is that the join method works…
J4N
  • 19,480
  • 39
  • 187
  • 340
8
votes
5 answers

How to list fields from dynamic SQL query in SSRS dataset

I'm running the following query in SSRS. If I add declarations for the two parameters, it runs fine in SQL Management Console. declare @EMRQuery varchar(max) declare @CPSQuery varchar(max) set @EMRQuery = 'select Person.ExternalId …
SarekOfVulcan
  • 1,348
  • 4
  • 16
  • 35
8
votes
3 answers

How to create totals row for grouped columns

If have an rdlc-report with grouped columns within a tablix (table). I want to add a footer row that spans all dynamically created columns and shows a total for all columns together. How can I tell to a cell that it should span all created columns…
HCL
  • 36,053
  • 27
  • 163
  • 213
7
votes
6 answers

Hide duplicate row SSRS 2008 R2

Duplicated data is coming in my report because source table has duplicate data. Without creating group, I want to hide duplicate data writing expression. So what I did: I select table row and put a expression for hidden property of table row. The…
Thomas
  • 33,544
  • 126
  • 357
  • 626
7
votes
5 answers

Stop empty reports from being sent in SSRS 2008 R2 Data-Driven Subscription

I am scheduling some reports by using data driven subscription in SSRS 2008 R2. Regardless of whether the generated report is empty or not, reports are still sent to recipients. This has been a common problem for long time, and honestly, the…
AnarchistGeek
  • 3,049
  • 6
  • 32
  • 47
1 2 3
…
99 100