i have the following data in the database: hk a aa aaa hk b bb bbb hk c cc ccc uk d dd ddd uk e ee eee us f ff fff and they are displayed in a matrix like below hk a aa aaa b bb bbb c cc ccc uk d dd ddd e ee...more >>

Hi. We are doing quite a bit of work with Analysis Server and Report Services. I understand the next version of Rept Svcs will support Analysis Server and MDX queries quite a bit better. So before we put a lot of effort in building better support for creating MDX based reports, I would like...more >>

I have sql server 2005 beta 2 and Visual Studio .Net 2003 installed. I do not have the project type "Business Intelligence" in Visual Studio. I have tried everything I could think of. it is supposed to be there correct? ...more >>

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 >>

Hi. I would like to know if someone tried to call a custom assembly function from inside a matrix and have it worked...coz i tried and it didn't On the other hand, i called the same function from a field outside the matrix and it worked. is there a way to solve this issue? i need it urgently...more >>

I have Sql Server Personal Edition SP3 installed on my PC. I get an error message when trying to install the reporting services trial package. Does the reporting services not work with a personal edition of Sql Server? The error message is "The edition of the report server database is not s...more >>

Hi, I have a DataSet which I want to pass to the DPE, how i pass the DataSet as a parameter to the DPE Please Help! Thanks Girish Kumar...more >>

I created a summaryreport.rdl, with a dataset that runs a stored procedure. The stored procedure takes an Input Parameter, creates a summary and a detail table in the SQL Server, and at the end outputs a the summary table as the resultset. The summaryreport.rdl has a jump action to a detailre...more >>

I use URL to pass parameter to a report of Reporting Service It is ok when the parameter is a number or English characters But the parameter result into ??? when the parameter is a Chinese word. How can I do? ...more >>

I've got a report that can have about 50 possible parameter combinations. The underlying query is fairly expensive, so I want to cache the dataset every morning after I expire yesterday's cache. So I set up a data-driven subscription to run every morning and execute all the parameter combinati...more >>

i would like to ask how to execute the email delivery setting? can it be done in the report server homepage??it is a must to get it work through web service programming? thanks in advance...more >>

I am trying to populate the object ParameterValue from the Reporting Services class provided by Microsoft. I keep getting the following error. I thought I was instanciating the object correctly. Can someone tell me what I am doing wrong? "System.NullReferenceException: Object reference not ...more >>

I have a report that has different layers of resolution: Global, Region, State, Facility and Issue. For different each level chosen I want to display a different set of parameters and execute a different SP for my dataset (which will return the same rows). I've seen posts where I can do the dy...more >>

I need to run a report ON DEMAND from a stored procedure (which was supposed to be a feature of the new reporting system) and then send the output to a file on the network. I can attend to the SQL Server part by creating a VB.net program that I can call from the stored procedure. Now, if I can...more >>

Hi I am trying to create a custom data processing extension that queries a Sybase database (ie odbc), then on the basis of this data queries a SQL Server database. However, when I get to querying the Sybase database, the method instantly crashed with a SecurityException "Request Failed." excepti...more >>

Any help would be helpful: (1) Report Server is inside firewall (2) RS Server query another sql server hosting database I render a report on ASP.net pages in a web server outside the firewall. everything os OK on my local test pc, but trying to render report in the outsite web server, s...more >>

Hi, I've got a few reports that have subreports built in. These sub reports take a parameter which is the index of a particular item to return in the dataset. The problem is our database is considerably large and has a lot of records, consequently when generating the reports, occasionally t...more >>

When the IIS port for the Report Services site is set to something other than 80, the following error returns: [ The underlying connection was closed: Unable to connect to the remote server. ] This looks like a custom error from RS. When the port is set to 80. There is no problem. What...more >>

I think I am getting this error because it cant interpet the Dataset option? Is this a bug or am I doing somthing wrong? Statment: =IIF (ReportItems!JobPriceS.Value / (Fields!Pieces.Value + Fields!SetupPieces.Value) > (Fields!TrussPrices.Value, "DataSet1") / (Fields!Pieces.Value + Fields!Se...more >>

Hi, We have an App Serive Provider model, where we have one server hosting multiple sites(clients). Each client has a separate web site/URL and a separate DB for their data. Ideally I would like to publish the Report Definiton once, but depending on the URL show clients their respective ...more >>

we are aware of KB84245 Titled: "How to move a Reporting Servides database from a computer that is running Reporting Services to another computer". this seems rather clear. But I have I a question. Does this article assume the original DB is on the web server machine, and if so would these...more >>

I would like the output of a particular report to be able to specify that the grid lines in MS Excel be turned on. I do not find any property values that would specify this. How can I accomplish this? Specifically, in Excel, if you goto Tools->Options->View Tab, there is a checkbox under ...more >>

Hi All, I accidentally deleted .sln file and now I can't deploy my report to the Report Manager. Does anyone know how I can recreate a new '.sln' for my report's RDL? Please help, anyone? -Ch...more >>

Hi all, RS first did work for me after installation on my notebook, but some silly changes of our network admin ruined everything: RS does not run any more, gave me some access denied errors. Complete RS Re-Installation told me at the end that it could not initialize RS: "Setup could not in...more >>