Hello, I am calling a report like http://localhost/reportserver?/myreportanme in my asp.net application. I have a textbox on my asp.net application and I need to use the value of this textbox as a where clause in the query of the report. So I need to pass parameter to the query of the report,...more >>

Hello, We have been using Reporting Services for a few months doing some prototyping and it has gone well enough that we are now being tasked with rolling out an implementation to the enterprise. Here is the hardware that I have to work with: 3 Web Server Cluster managed via Application Cente...more >>

Hi, I have a report which has a table inside a rectangle. In the designer, the report renders correctly with the table displayed within the rectangle. when I deploy the report, the table renders underneath the rectangle. Is this a bug or is there something I need to do to avoid this? tha...more >>

I am looking to purchase a book or books on Reporting Services. Any opinions on the best book or books to buy? -- Darrell...more >>

Hi, There are two problems during I tested the Cube in RS: 1. If I choice a Member is the Top Level of the Dimension, as following, the "All" this Member. The All Member is the name of "All Caption" of the AS Advanced Property and it's the sum of the Department Dimension. When I us...more >>

Hi Want to know how to get kerberos to work 3 workstations involved User computer with Windows 2000 runs I.E 6.0 and accesses a web page on Reporting services server (Web Portion-IIS) running windows 2003. USer is running a report that runs an mdx statement on a data server which is also windo...more >>

Hello, I created a few reports by using RS2000, now I want to call these reports in my asp.net web application through a selection box. What is the best and easiest way to handle this. Thanks, Jim. ...more >>

I started getting the error CryptographicException "the parameter is incorrect" whilst designing a report. Interestingly, I removed everything from the report so there is nothing in the report, including the dataset and I still get this error. I guess it must be corruption in the RDL. Can any...more >>

hello, i have a percentage field which returns 0.50 i want to report to show it as 50% is there any way to do this appreciate any help...more >>

I have a multi-tier application that does a lot of business processing of data. I am looking for a way to use SQL Report Server to render reports based upon this data. I have looked at several examples of extensions and built one using a serialized XML file. What I am looking for though is ...more >>

How could I do real drilldown in RS? By real I mean that I load only one level of data at a time. I tried to do it with using parameter that defines level in mdx (dynamic query) but I couldn't make it work because the names change with level. Can I define name in the layout with expression or ...more >>

Hello I installed RS2000 and create and report application. When I run my report it tells me “No report server found at http://localhost/reportserver “ What is problem? Thanks, Jim. ...more >>

Hello. I'm fairly new to Reporting Services, so my question might seem really simple to you guys. But what is the difference between a matrix and a table? When should I use what? Are there any articles on the web that explain this? The best I've found is in this article: http://www.ftponline....more >>

We are a hospice facility. We have a description field that tells under what circumstances a patient left our care (most are death under certain insurance coverages) Our descriptions may read "death at home"; "Death at hospice house"; etc. However some of them might read "discharged to sel...more >>

I want let the end user decide on which type of graphic(via a report parameter) is used for displaying the data (Bar, Column, 2D, 3D, etc.) I couldn't find any option to define the chart type e.g. with the aid of an expression. Do I have to place any possible chart type in my report layout a...more >>

I’m a Crystal developer who has been unsuspectingly thrust into SQL Server Reporting Services. I am at a loss as to how I can access report services object to export it to a file (.PDF, .XLS, etc.) from a Windows application. (With Crystal, ActriveReports, etc. this would be 4 or 5 lines...more >>

I works fine when I run from our lan by a IIS virtual directory. But using reportmanager from a IIS application outside the lan as a true webapplication, the reportmanager produce wrong paths for controls. E.x. http://images/48folderopen.jpg There should have been a domain in front of /image...more >>

Is there some easy way to prevent a report from generating once the last non-defaulted parameter is selected. This behavior is driving everyone nuts. I have a whole series of reports where a user will select a company, and then select a month, which is defaulted to the previous month but can...more >>

Hi: I was wondering if there is anyway of using a web service as a data source to a report in Reporting Services. I have a legacy app that can be accesed thorugh a web service. It returns an xml. I wanted to use reporting services to render a report based in this data but was tryin g to avoid ...more >>

Has anyone developed a custom toolbar in lieu of using the html viewer that comes standard with SRS? Specifically, toolbars accessed through URL Access to the report server. If so, can you direct me to some knowledge bases articles or examples of how they've been developed or deployed? T...more >>

Make the "Scale" properties of graphs accept a formula. Now we have many graphs one next to the other but scales vary. I want to put something like =max(Fields!MyValue, MyOuterList) That way the graphs would still adapt to the data and have a common scale. Oh, and clearly indicate which f...more >>

Hi all, In my report (which im building in Visual studio) I have two sets of dates. The first is called required date - thats the date an employee of the company was required to perform a certain task. the second is completed date. thats when he or she actually completed the task. what...more >>

Hi, Can anybody please convert the following C# code into VB.Net Code.I tried but its saying Object Reference not set to an instance of an object. Or give me VB.NET(Web Application, CodeBehind:VB.Net) code to programmatically render reports into PDF format. // Prepare report parameter. ...more >>

Hello all, however, this is my first question to this news. I am working with RS SP1, and have question. I have example procedure: CREATE PROCEDURE GEGE_test_a @ord SQL_VARIANT AS SET NOCOUNT ON CREATE TABLE #table (ID SQL_VARIANT) INSERT INTO #table(ID) VALUES (@ord) SELECT * FROM #tab...more >>

hi all, would anyone know how to display data alternately from two tables? thanks in advance...more >>

I have an asp.net web application using reportviewer that is causing me immense headaches trying to get to work for all users on our intranet. I do not need the whole reporting services management section etc to work for them - just the reportviewer control itself - users can choose parameters f...more >>

Is it possible to pass variables/parameters to a report other thank through a url using ASP, as this will compromise our security ? Thanks in advance ...more >>