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
23
votes
5 answers

Hide row (and remove whitespace placeholder) of tablix in Reporting Services 2008

I have a row in a tablex that I want to hide based on a condition. I can do this with the visibility property and also using CanShrink as well is an option. I've tried both of these and the best I can do is hide the row (make it invisible), but…
Dan
  • 905
  • 4
  • 10
  • 16
22
votes
3 answers

SSRS - Determine report permissions via ReportServer database tables?

How can one programmatically determine logins/users that have permission to access specific SSRS reports? I want to create a datamart in order to populate reports for managers who want to see who has access to specific reports. We currently assign…
Emre Motan
  • 271
  • 1
  • 2
  • 4
22
votes
5 answers

I want to Repeat Page Header on each Page for reports.Repeat on NewPage is not appearing in properties of Tablix member in SSRS 2008

How to Repeat Page Header on each Page. Repeat on NewPage Property is not appearing in ssrs 2008 tablix memeber property
grace
  • 221
  • 1
  • 2
  • 4
22
votes
7 answers

How do I get the last day on the month using SQL Reporting Services

In SQL Server Reporting Services, how would I calculate the last day of the current month?
Cory
  • 12,404
  • 7
  • 33
  • 28
22
votes
18 answers

SSRS Dataset Field Refresh not updating for Tablix

I have updated the SP for the attached dataset that the tablix is using. The refresh worked fine and I can see my new fields in the shared data set when I look in the Fields tab. My problem is the tablix itself is not giving me access to the new…
Tony
  • 3,269
  • 1
  • 27
  • 48
22
votes
3 answers

SSRS Subscriptions - How to view ALL report recipients

I've written an SSRS report to help me keep track of SSRS subscriptions. I've repurposed a script that will use Reportserver.dbo.Subscriptions.LastStatus to view email recipients, however, it will only list the first 520 characters of LastStatus. …
Wendy
  • 277
  • 2
  • 5
  • 14
22
votes
7 answers

How to check if SSRS Textbox is empty

How do you check if a textbox is empty in SSRS 2008? I've tried this code and it doesn't work. IIF(ReportItems!txtCountVolunter.Value = "", false, true)
Link
  • 531
  • 4
  • 10
  • 18
22
votes
1 answer

How to edit SSRS 2008R2 Reports in Visual Studio 2012?

I'm a report writer who's been able to edit/update reports in Visual Studio 2008 (we use SSRS2008R2). I've just installed Visual Studio 2012 and when I go to convert my reports project it's not working as I appear to be missing a…
Michael A
  • 9,480
  • 22
  • 70
  • 114
21
votes
4 answers

Passing Credentials to Sql Report Server 2008

I am pretty new in C# and my English is not so good - sorry in advance if I miss a point. I tried to build an ASP.NET web site with a ReportService control. As you might already know, SSRS 2008 does not allow anonymous login. So, I tried to pass…
adopilot
  • 4,340
  • 12
  • 65
  • 92
21
votes
3 answers

Make hidden table column take no space in SSRS 2008 R2

Has anyone figured out a good way to make a hidden table/matrix column take no horizontal space? I could use some crazy conditionals to dynamically determine the contents of the columns (effectively sliding them leftward as far as possible), but…
ErikE
  • 48,881
  • 23
  • 151
  • 196
21
votes
4 answers

What is the difference between matrix and a tablix?

In Reporting Services. When I drag in a matrix, am I effectively dragging in a tablix? A tablix is a hybrid of table, list, and matrix. I understand (at least I think I do) the difference between a table and tablix, but not matrix and tablix.
James
  • 211
  • 1
  • 2
  • 3
20
votes
2 answers

SSRS Report Manager javascript fails in non-IE browsers for Drop Down Menus

I've been debugging the ReportingServices.js file using Firefox and Firebug. I've found that the reason SSRS (SQL Server Reporting Services) Report Manager (web front end for Reports) doesn't work in Firefox (v7.0.1) is that it's using javascript…
Chris Snowden
  • 4,982
  • 1
  • 25
  • 34
20
votes
3 answers

Vertical merge in SSRS Tablix

Is there any chance to do vertical merge of fields in tablix? I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.
veljasije
  • 6,722
  • 12
  • 48
  • 79
20
votes
10 answers

How do I display todays date on SSRS report?

I want to show up Todays date as report generated date on SSRS report. How can i do that ? should I use any variable ? please help me I'm newbie to SSRS. For example refer this image:
Neo
  • 15,491
  • 59
  • 215
  • 405
20
votes
8 answers

SSRS - Disabling export options (eg. PDF) for individual reports

We have many reports which we use on the website. While exporting some reports as PDF, the file size gets huge and the server crashes due to load. So it would be great if I can disable export to PDF option only for certain problematic reports. So…
user1449265
  • 357
  • 1
  • 2
  • 11
1 2 3
…
99 100