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

How do I make wildcards work in a like operator in SQL Server reporting services?

I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it to act like %@test% so I can pass '' to get all…
David Silva Smith
  • 11,498
  • 11
  • 67
  • 91
12
votes
4 answers

Access Page number in report body In SSRS

I want to use Globals!PageNumber in Report body part. How can I access inside Report body? I am using SQL Server Reporting Service 2008 R2.
Mike
  • 317
  • 3
  • 7
  • 17
12
votes
2 answers

Convert Varchar to Ascii

I'm trying to convert the contents of a VARCHAR field to be unique number that can be easily referenced by a 3rd party. How can I convert a varchar to the ascii string equivalent? In TSQL? The ASCII() function converts a single character but what…
Bolt_Head
  • 1,453
  • 5
  • 17
  • 26
12
votes
5 answers

SSRS Reports Versioning

I'm looking for a way to get versioning informations out of my SSRS reports. I have several environments and would like to be able to compare which report version is deployed on these environments. In SSIS this is very easy because each SSIS package…
nojetlag
  • 753
  • 2
  • 14
  • 27
12
votes
4 answers

Overlapping Labels in Pie-Chart

Are there any Settings to avoid having overlapping labels in a Pie Chart in SSRS? I have several Charts with the same Problem, if the Slices are too small the Text will overlap. Here is a Picture of my Problem and a possible way as how i want it to…
superschaf
  • 229
  • 1
  • 3
  • 13
12
votes
9 answers

The request failed with HTTP status 401: Unauthorized IN SSRS

My Application is in Asp.Net MVC3 coded in C#, i have a SSRS solution in SQL Server Business Intelligence Developement Studio in Visual Studio 2008 , I'm calling the SSRS report through my Asp.Net MVC3 application. My application was running fine a…
Sam M
  • 1,077
  • 2
  • 20
  • 42
12
votes
1 answer

Using a shared data source for dynamically generated and deployed reports

I'm dynamically generating RDL files for SSRS 2008, assembling my reports from "building blocks" which I defined as reports on Report Server, and which I use as subreports on my generated report. On my Report Server, I have a single, shared data…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
12
votes
2 answers

Total Row Count for Grouped Values in SSRS 2008

I have a report that displays names of all accounts and activities performed under each of them. AccountName: ABC Corp Activity: Installation I want to group the AccountName and get the total number of Activities performed for each account. ABC…
user2287143
  • 231
  • 2
  • 4
  • 11
12
votes
4 answers

SSRS can't properly render *some* images within PDF

I have a report that renders images (jpg) that have been collected from various sources. This works fine within the report viewer, and when exporting via Excel. However, when exporting to PDF, about 5% of the images are rendered incorrectly as…
Stafford Williams
  • 9,696
  • 8
  • 50
  • 101
12
votes
5 answers

how to set SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005

Please help me to set the SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005.
Dhana
  • 1,618
  • 4
  • 23
  • 39
12
votes
4 answers

SSRS date-picker is invisible in Google Chrome, not working in Opera/IE?

I'm integrating SSRS reports(developed in VS 2008 vs. 9.0 ), and when I load it into the browser with Chrome, I get this: There's no date-icon! In Opera it shows, but doesn't work: How do I figure out how to 1.) get it to work correct . 2) Make…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
12
votes
1 answer

Optional multi-valued parameters in SSRS

I have 3 multivalued parameters in my report.Out of them 2 are optional. Is there any way to get the results in the report with out selecting any from the 2 optional parameters. My stored proc checks the mulivalued parameters as (States IN (SELECT…
user1046415
  • 779
  • 4
  • 23
  • 43
12
votes
6 answers

In SSRS is there a way to copy formatting between cells?

I am developing several dozen reports in SSRS 2008 R2. I am finding the formatting of cells to be the most tedious and error prone part of the task. I know how to individually format each cell. Is there a way to copy the format of one cell to many…
gnackenson
  • 707
  • 3
  • 9
  • 23
11
votes
3 answers

How do I enforce SSRS page breaks with empty tables?

I'm working on an SSRS 2008 report. I have a very simple report with three tables, a different data set/tablix (with the same fields displayed) for each. I have PageBreak.BreakLocation set to End for the first two - I'd like the three to be…
John Straka
  • 1,874
  • 5
  • 28
  • 49
11
votes
2 answers

SSRS 2008 Hidden Columns Should NOT Export to CSV

When I hide columns in SSRS they still appear in the CSV export. I have to hide columns, not the entire tablix. This is what I have tried already: The filters in the tablix hide rows not columns. The DataElementOutput per column can not be set…
Internet Engineer
  • 2,514
  • 8
  • 41
  • 54
1 2 3
…
99 100