HI, when I export to excel that consist of hierarchy(five leavels), the exported excel show me only two levels. I want to make whole levels of Web form leavels in exported excel. as same as I can see the Web form. (hierarchy!!) what can I do? what's the problem? ...more >>

I've installed Reporting Services and customized the authentication ( Forms Authentication Sample ) with SSL. Everything works fine in intranet environment. Now I'm trying to publish this server in internet, but it doesn't work: when I call the server url I can see the login form, but when I pr...more >>

guys, I got this error when i try to export my report in excel. I already installed SP1. This doesn't happen without SP1. Has anybody have the fix. Reporting Services Error ---------------------------------------------------------------------------- ---- a.. Exception of type Microsof...more >>

Hello, I am using sql server rerpoting services for generating reports for one of my application created in ASP.NET , and i want to connect diffrent data sousce at run time. where as i found that it can be possible by using IDbCommandAnalysis, i need help as to how to implement this interface wi...more >>

Hi There, I'm at my wit's end on this one and any help would be GREATLY appreciated. To start, I've got a stored procedure that takes three parameters. By the way, it also is made up of dynamic sql. When I create the dataset and run it, after it prompts me for the parameters, I get data b...more >>

I'm working on a Financial Report which contains a column "XYZ" , its value is calculated from a formula by passing the row's record id and commission rate. (the formula is inside a custom dll). The values are correctly computed. Now, the footer should display the total of all the rows in the gr...more >>

I want to automatically run a report every day of the week. This isn't a problem. However I want the users to be able to run the report whenever they feel like too. Can I put expressions in the default value entry? They don't seem to generate anything... Here is the value I want to put in.. ...more >>

Hello, After installing SP1 (on the server & client) I cannot seem to get RS to export to Excel correctly. The Excel file shows all the fields in the reports, not just the fields conditionally displayed in the browser. For example based on certain parameters a table with price or a table w/o pr...more >>

Hi I have a report which requires 48 parameters (yes, 48). The problem is that the entire screen is filled with all the parameters when the report is displayed within Report Manager. I am unable to scroll down to see the actual report output, as the scroll bars do not allow me to scroll that l...more >>

Hi, We have been working with some lrge PDF reports (200-400 pages) and have been anxiously awaiting SP1 because of performance problems we have been having. Our initial tests show that the performance is better: Given about 3000 records from SQL Server, we generated a 272 page report. Pre...more >>

I have a report that shows VFP data. Here is an error I am getting trying to run it: An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'UserPermissions'. (rsErrorOpeningConnection) Get Online Help The 'VFPOLEDB.1' pro...more >>

Is there a way to auto-size the height of the page header depending on it's contents? For example, I have created a page header with a logo that appears on the first page (1 inch x 1 1/2 inches) as well as my report title. But on consecutive pages only the title shows and the image gets surpr...more >>

I would like to render a report without having to deploy it to the report server database. URL might be something like: http://servername/reportserver?http://servername/SomeApp/SomeReport&rs:Command=Render&rs:format=HTML4.0 This might not be possible so any suggestions would be appreciated. ...more >>

What should the ReportPath property be set to in a ReportViewer Control? What files (rdl?) and where should they be located?...more >>

Sorry for still living in the stone age, but can anyone point me to some examples of using SQL Server Reporting Services via SOAP from VB6? Specifically I'm trying to recreate the functionality of the "FindRenderSave" sample application that is supplied with the application. I want to be able ...more >>

My report has a parameter that is used for a filter in one of my data set. What I ‘d like to do is to say if that parameter is not blank then use it To filter data otherwise show everything. Is that possible? ...more >>

Is there a way to change the look and feel of the reports in the bit where the parameters selection is? And what about the top section? Im thinking of changing background etc. Jonas ...more >>

This is an interesting one. We have implemented a custom security extension that we call from within an application. We pass in a userid and password into the LogonUser method, which is then checked against our database. However, we have a Master database, and then a few other small databases...more >>

I can see (and have read a little about it here) in Report Manager where you can hide parameters. Why isn't this exposed in the API? Why can't I set them to be hidden in VS? Did my service pack maybe not install okay. Thanks ...more >>

Hi, I installed the Reporting Services on Win2000 server (SP4). when I try to access the reports manager through browser I am getting following error. The XML file c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not be loaded. Attempted to access an unloaded AppDomain...more >>

I can access Report Manager from IE on the server that Report Services is installed on but cannot access it from another machine on the network. I type http://<machinename>/reports and receive an error (see below) when trying to access from another machine on the network (i don't even get to the lo...more >>

Hello, Is it possible to change Reports Manager's language ? It is actually set to "English" and i would like to put it in French. Thanx in advance. ...more >>

To get the UI we required, we built a custom .NET front end that communicates directly with the MSRS web service. Paging (e.g. a break in the data at a certain point with some indicator for the "next" page) does not seem to work once you take this approach. Anyone figured this out? ...more >>

I have a very basic html page I am using for test. It has a few text boxes on it and I am passing the values in a URL to the RS report. It's working fine. What I was wondering is when the reporting services report is displayed, the very top of the report shows the 2 required parameters,...more >>

I have reporting services installed. It is going to expire soon. I need to have a non-eval version of Reporting service. How can I get it? Is there any other method so that the reporting service doesn't get expired? Thanks in advance ...more >>

I have now received my CD with the correct version of reporting services on it. I have been running the 120 Day trial version. What is the best way to update/replace the 120 version with the proper version? ...more >>

Hi, I have created a number of reports and deployed it in my machine and have accessed it from asp page.Everything works perfect. I now need to move it to the Production server which has .net framework and we installed sql reporting services.(The database which I access from the reports is ano...more >>

I have designed some reports using MS Reporting Services. I want to make those available to some of my clients. What that procedure is called and how would I do that. Thank you in advance. ...more >>

Hi I received the error message pasted below, when I tried to delete a folder through Report Manager. There have been no problems deleting folders, until now. (SP1 has not, as of yet, been applied) Does anyone know what could cause this error and what the best solution is in the event it ha...more >>

Hi I need to embed Reports into an aspx page. So I need to send parameters to the Report from the UI (aspx page). I can do this using parameterized reports but I want to pass the parameters from the aspx page and not the report body . Can anyone suggest how to do that. Moreover in my appli...more >>

Hi All, Does anyone has some information regarding the kind of server you need for getting better performance from the Reporting Services (both for Database and IIS portion of RS? Thanks in advance, Suhaib ...more >>

I'm trying to deploy a report to the report server from VS.Net but I cannot. It says that: The permissions granted to user '<Domain User>' are insufficient for performing this operation. Note that the same domain user has administrative rights on the reporting services web application site...more >>

I've got a visual studio solution containing an ASP.Net (C#) project and a Reporting Services projcet for SOAP communications (copied from the samples that come with RS). The SOAP calls work fine locally (XP), but when I deploy my solution to the server (Win2k Server) I get the following error...more >>