reportingservices-2008

How do you create a SSRS 2008 R2 versioned Report?

I'm using VS 2008 with SQL Server 2008 R2 BIDS installed. My target Server version is SQL Server 2008 R2 I was looking at the RDL files today and noticed I have a mix of schemas. Some of my reports have: <Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserve...

How to use ReportViewer 2010 in MVC.NET 2

Basically I want to know how to embed a report into MVC.Net 2. ...

Reporting Services 2008 Chart DynamicHeight Property Creates Extra Space

I have a bar chart with horizontal bars. I used this article to setup the dynamic height property: http://blogs.msdn.com/b/robertbruckner/archive/2008/10/27/charts-with-dynamic-size-based-on-categories-or-data.aspx Everything looks fine in the viewer, but as soon as you go to print layout, pdf, et.al there is about 50% more blank space...

Reporting Services - Can I apply XSLT to the DataSource?

I'm looking for a clean approach to using SSRS 2008 to provide our customers with common reporting functions: Standard Visual presentation for the report, with strong aesthetics, drill downs, graphs etc. Only one visual format will be provided for all customers. Customers will also want to access the raw data to the report in a variety...

SSRS R2 Deployment issue with lookup built in function

I have a SSRS R2 report built and it works fine on the preview tab but when I try to deploy the report to the report server I get the following error: Error 1 The Value expression for the text box ‘Textbox23’ refers to the field ‘Bats’. Report item expressions can only refer to fields within the current dataset scope or, if i...

SSRS - Custom assembly in location other than server bin directory

Is it possible to deploy a custom assembly to a location other than the Reporting Service's bin directory? I know that deploying to the GAC would likely work, but I'm more curious about using an arbitrary directory on the server dedicated to deploying custom assemblies. I'm not opposed to altering any rs config files, if a possible so...

Reporting Services 2008: "HTTP status 401: Unauthorized" Issue

I'm getting the error "The request failed with HTTP status 401: Unauthorized" whenever I try to list the reports on my reporting server. The weird thing is, it works when I run the asp.net application on my dev machine hitting the server reporting services web service url (http://www.example.com/reports/reportservice2005.asmx?wsdl) but w...

SSRS chart image not displaying (showing Red x) in dashboard, But only matrix controls are displaying

Hi We are facing a strange problem. We have developed a dashboard using Sharepoint 2007, Custom report viewer and SSRS 2008. Due to unknown reason the custom report viewer was not able to show reports from reporting service through default authentication. I mean with the credential of the logged-in user in sharepoint site. So we hard ...

SQL Server Reporting Services: how to print reports automatically without preview from a web application

I'm using SQL Server Reporting Services and viewing the reports in a web application in ASP.NET. To display the reports, I'm using Report viewer Web control which brings funcionalities of exporting the report and/or printing it, but requires to display a preview of the report before printing it. I need to print a report without doing a ...

ASP.NET session expired error when viewing a report

Hi, I am getting "ASP.NET session has expired" error when viewing a (SQL server reporting services) report using report viewer control. sometimes it works fine and sometimes I get this error, it works fine in Dev, but not in test environment. Please let me know if you have any clues. thanks in advance. here is the code for the report vie...

Can i generate a Microsoft SQL Server Report Builder 2.0 output directly without storing in DB

Hi, I have a Windows form in .NET 3.5 (using Sharp Develop). Now on clicking 'Save', i just want to print the data on an A4 sheet without saving it to DB. Can i create a dataset and pass it to a pre-designed 'MS SQL Server Report Builder 2.0' report, to generate the report ? The data will not go to a database since it is redundant. So ...

SQL Server Reporting Services - Functions Problem

Hi. I´m developing a app in ASPX .NET2008. And I have a big problem with the SQL Server Reporting Services. The button "Print" and the zoom option only is showed in IE browser but I need it showing in Chrome and FireFox too. I think it is a ACTIVEX problem, but I´m not correctly this. ...

Pass Value from one DataSet to another DataSet to filter row in Reporting Services 2008

I have 2 table stacked at a single page,one for filtering previous year and 2nd table for the current year and i pass in the same value from the DataSet to these two table , the only difference is that i need to filter it with the year using the Tablix Properties. Right now i am filtering the Year with the hardcoded value like 2008,2009 ...