Hi, when I switch my reportserver virtual folder to the ASp.net2.0 I receive this error: "Failed to load expression host assembly" this error appears only when I try to render a report, I can list reports or I can access the webservice without any error. any solution? thanks. Jer...more >>

I'm trying to create some reports based on an OLAP cube. Creating a simple MDX based report is a breeze with the new report builder, but I haven't figured out how to optimize things. Like using descendants instead of where etc. If I just add a pre-made MDX statement, I loose the Fields in the ...more >>

First, let me say that I am trying to use Server Reports with the Winform Report Viewer. This is a technique I used heavily in Crystal. It allowed me to build the reports against the development servers (Web & SQL), and copy the report files to one or more production servers, where the con...more >>

Has anyone used Reporting Services with a map of USA with the States outlined? Here's what I am trying to do ... I have data that counts inventory at each Store across the USA. I want to sum the Store data by State. And then display that information in a USA States map .... changing the color...more >>

Hello, I'm new to Reporting Services 2005, so I'm not sure if what I'm asking is possible. What I need to do is replace a certain value in a report with an image. For example, the values in a given column will either be -1, 0 or 1. What I need to do is replace that value with a specific gra...more >>

When I open reports from the ReportManager, the parameter list and the reporting toolbar seem to be missing the normal style, and I get an "unable to connect to the remote server The attempted operation is not supported for the type of object referenced" error. I can successfully execute ...more >>

Hi, i want to publish some reports with Reporting Services for my customers, but RS need windows authentication and my customers dont will be in the active directory, how can i use impersonate with RS? Thanks...more >>

Hello, I'm having trouble finding a site with basic introduction to SQL Reporting Services. I'm using the VS.nET reporting services IDE to build some reports and I have a few questions. How do I SUM two "report items" on my report? Like textbox12.value + textbox13.value. I know how to do...more >>

Hello: I have a report successfully running on SQL RS 2000. This report uses a custom assembly developed using VS 2003 to evaluate a report expression. The assembly has references to Microsoft.ReportingServices.Processing.dll in SQL RS 2000. Now I am trying to migrate this report to SQL RS ...more >>

I have a query that returns 71,000 rows. When I run it in query analyzer it takes 11 seconds to execute and return all records. In reporting services I came up with a report designed just to have the data eported to excel. It seems to just take forever and then time out. Has anyone exper...more >>

how can i format a phone number to be displayed as follows in the report (678) 444-4444 Thanks! ...more >>

Hi, I'm trying to reference a custom assembly from an RDLC in a web application and, eventually, managed to get it to work. It required signing the assembly and deploying it to the GAC before the ReportViewer control could find and load the assembly, with ExecuteReportInCurrentAppDomain() a...more >>

I have a report with only two parameters input by user @startdate and @enddate. On my Subreport I use the same parameters. How can I make the subreport run by taking the user input on the main report and passing it to the subreport so it can run too. Any help is appreciated. Thanks...more >>

I'm using VS2003 + Sql Server 2000 Reporting Service +IE6. I have created a report using RS. Now I want to click any row to hyperlink a new report in a new window. In URL address I wrote:=Globals!ReportServerUrl+ "?%2fyclsfybbfltotal&rs:Command=Render&rc:Format=HTML4.0&rc:LinkTarget=_blank". I...more >>

I seem to remember reading that in Reporting Services 2005 it would be possible to create column charts with dual axes, in particular with a dual y axis. I've been playing around with the charts but I can't seem to find a way to do this. Did this functionality find its way into the product ...more >>

Hi, I put a logo image as external source and it works fine on reports server. The image is in the same folder as report file. However, when I use reporting service web service to get report as HTML format, I keep getting logon window and red cross for the image even after I logon. I alread...more >>

The subscription is returning the following error message. How should I resolve this issue? However, according to the Job executed, the process was successful. ERROR: Failure sending mail: The report server has encountered a configuration error. See the report server log files for more ...more >>

After setting up and running the report subscription, the following Job error message is returned? 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK SERVER'. The step failed ...more >>