OK, I've tried various ways in order to get your attention (MSFT team). Every attempt failed, unfortunately. Here is your bug report file. Take it or ignore it, your decision. Found at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_4iid.asp The...more >>

Hi, if I open the report manager and click on a report to open it, under which credentials is the report genererated? I have a developement computer on which I create my reports. Reporting service is installed on a developmentserver. I use an AS2k cube as a source and runs on another server. A...more >>

Hello all, With the new chart palette features in SP1 I'm trying to create a dynamic switch expression of colors that is passed from a database, but I can't get the chart to render correctly based on the expression I pass through. Can this be done? What I've done so far is create a db table o...more >>

Hi all.. I've got a chart with a 3month time series over the X axis and at the moment each day is printed on the graph and it is not really legible..I really need to have the graph shrink to fit an A4 page and only print the first day of each week, hope that makes sense. Any help woul...more >>

Is Microsoft intending to release SP1a for Reporting Services? Given the issues I've read in this group, my firm is reluctant to deploy SP1. The PC we have trialled it on has had DLL and functionality issues like other people have described. SP1 has been a disaster - we await SP1a to smooth over ...more >>

Hi, I am breaking my head on one problem related to Microsoft Reporting Services and I would be very very thankful if you could point me to the right place. I had my MRS running properly but not anymore ..:( now I can not load the Report Manager page any more and I get this error: ....CON...more >>

I have an Analysis Services OLAP cube with about 40,000 rows in the fact table, and a dimension with four levels- Office, Employee, Client, and Matter. Browsing the cube is instant, but RS reports created with the cube take about 30 seconds to render, and I'm using a parameter so am only deal...more >>

I am trying to build a report with grouping and I am not having success. I use a stored procedure to return these fields: PromptBnkMID (UniqueID of a group of questions) PromptBankTitle (Title of a group of questions) PromptID (UniqueID of a question or prompt) PromptText (The question) ...more >>

I am trying to install Reporting Services on an Windows 2003 and get the follwing error message: "SQL Setup failed to execute a command for server configuration. The error was: Windows NT user or group 'webserv\webserv_anon' not found. Check the name again. Refer to the Server error logs ...more >>

I have many reports which are currently run from stored procedures which take multiple parameters, but all reports include Client and User parameters to limit the data returned to only that viewable by the User and only data the for those Clients (string list of integers (i.e., '1,2,5,7')). ...more >>

I would like to use the Report Wizard Template in combination with data coming from a stored procedure, but cannot seem to find a way to get it to work yet. If I define a new report and add the data source and define the stored procedure and its parameters to RS, then I cannot find a way...more >>

We are contemplating moving about 200 existing reports into SQL Server Reporting Services and need to know the best way to do some basic setup tasks. We will have up to 5 Report Developers working on this project and need to know the best way to set up the Solution / Project / Report envir...more >>

We would like to move all our reports to Reporting Services...however, some of our current reports call the objects in our in-house developed assemblies rather than the calling the database directly (to use the associated business logic). Is it possible to use these objects (.Net assemblies writt...more >>

I have this number 1556.2310 and I want to format it to this $1,556.2310. Any suggestions? Thanks! ...more >>

We installed Reporting Services on a machine that also houses the SQL server and IIS originally without an SSL certificate. (RS SP1 is applied) We have now added the SSL Certificate and when we try to deploy a report from VS.NET we get the following error: The underlying connection was ...more >>

hello how would i embed a format function inside a cell equation? by itself the format function is: format(total,"#,#") but in an equation, i'd like to use: "Total Value is: " & format(total,"#,#") but the dbl quotes generate compilation errors. as do single quotes. so... how to do it?...more >>

Do Subscription Support Distribution list? I tried to send e-mail to a group called "help desk" , but the error message says the one or more email address is not correct. all the e-mail address are valid with in the group. Thanks Vijay Tripathi....more >>

I have placed various images in my page header. I am finding that on the first page, my image is shifting about an inch to the left, but on the second page, it is placed correctly. Has anyone found this to be true or know how to fix it? Thanks, Lisa ...more >>

Is there some sort of calculation to make a matrix export to pdf without page breaks? I have 2 dynamic rows 1 dynamic column 1 value field Please help thanks ...more >>

Dear MSFT-Team, I believe it's hard to follow this dynamic group: Too many problems, indeed... Despite that would you mind to comment on this? Thanks in advance. Roland <snip> I refer to my posting news:uVSl98SXEHA.1888@TK2MSFTNGP11.phx.gbl Q: Is there a need to have the policy "Manage a...more >>

Hi all, I'm populating a dropdown to let users select a report parameter. I want to be able display in the report what the user selected. More specifically the label of the selected item from the drop down. How can I do this? thanks, Justin...more >>

The Deliver method in the sample returns false if the delivery is successful and never sets the Notification.Retry flag. Both seem to contradict the documentation. Please confirm that the sample is wrong and the documentation is right. Thanks, - Steve ...more >>

Have installed Reporting Services on Windows 2000 Server with SP4, SQL 2000 Standard with SP3a, and Reporting Services Enterprise edition. Reporting Services is running using a domain account. We haven't had any problems with reports running in the browser, however Scheduled Reports aren't ...more >>

We are a small ISV that would like to incorporate simple reporting into our SQL Server based WinForms app. We have no need for the enterprise features of Reporting Services (scheduling, etc.) and only wish to preview and/or print reports real-time. Up until a few days ago, we were under the i...more >>

Sorry to ask this again, but I didn't get an answer and I am hoping someone out there might know... 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 inch...more >>

Is it possible to put a "Printer icon" on the top of every report. Then whenever readers want to print report, this printer icon can reduce the report size and print out the report in one page? Or this printer icon can set the printer layout to be landscape or portrait? ...more >>

Hi Ng, i have some problems with Rs Sp 1. I installed Sp 1 on the server and on the pc where vs.net is installed. Now I got the following Problem: I design a report and go to the preview mode. If an error is found, for example a syntax problem in an expression, the report isn't displayed. No ...more >>

When I hit the Report Manager website on one of my installations and log-in (With a user name that has System Administrator and System User roles) I am presented with the Report Manager screen but am missing most of the controls: I have the Home|My Subscriptions, ... in the upper right, but the ...more >>

Am getting the message "Unable to find Reporting Services WMI namespace = on <machinename>. Reporting Services may not be installed." when = attempting activation of a newly-installed instance of Report Server = from the existing Report Server. Installing RS and pointing it to a = new databas...more >>

When calling a report, in the URL i'm using rs:Format=PDF to render the report directly to PDF. I'd like the PDF to automatically format the report in landscape mode. Is this possible? Thanks, Brian ...more >>

Server: SQL Server 2000 Ent running on Win2k AS, Ent Edition of Reporting Services + SP1 my workstation: Win2k SP4, Microsoft Development Environment v7.1.3088, Reporting Services Ent Ed + SP1. I am trying to export 55,804 rows to Excel. The table that I am exporting from has 11 columns. ...more >>

I'm trying to restore a sql7 database on a NT4 Entreprise SQL server. I rebuild the master database with Rebuildm.exe and I start the single user mode with d:\mssql7 \binn\sqlservr.exe -m When I start the restore with Brighstore ArcServe, I have this error: Error: 605. Severity: 21, ...more >>

IT support won't consider giving Excel XP or 2003 to users at this stage. Other than letting them choose CSV as export format for the report and loading the CSV into Excel 2000, does anybody have an idea how I could easily deliver Reports to Excel 2000?...more >>

Hi! Will RS render SVG images in a future release? I think this would be great! Thx!...more >>

Hi! I'm working with Reporting Services (Spanish) with SP1 (Spanish). I'm trying to pass the parameter Zoom with the option "Page Width" in the URL, but RS always renders the report in 100%. It seems like it doesn't catch this option for the parameter Zoom. I'm following the example in htt...more >>

Suppose : I have a dimension in a Cube, called DepRec. DepRec is a Parent-Child dimension with extra member properties(descr, type). I build a report with an mdx-query. Now, in that report I need to access the descr member value instead of the code(value), to show on my report. Any ideas ? Thank...more >>

I have a matrix report which has a row total at the end e.g. col1 col2 total 80.1 60.4 140.5 Is there a way in which I can make the total column wider than the data cells in the matrix or alternatively can I change the total format to have no decimal places? At the moment its width seems...more >>

Hi, I'm gettting this error when exporting 1 particular report to excel: Microsoft.ReportingServices.ExcelRendering Specified cast is not valid. What is the possible causes for this error? Is it to do with how the fields were constructed/typed? Thanks, Albert. ...more >>

I am pretty impressed with the export format, it looks just like the HTML/PDF. I have a simple report, it has a list and below it a table. There are two data sets, the one for the list always returns one record, and the other for the table returns a bunch (currently three). The problem is with ...more >>

Microsoft® SQL Server™ Reporting Services provides a single entry point to the full functionality of the report server: the Reporting Services Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the re...more >>

Does anybody know how to create a filter expression where the row is NOT BottomN 1? Cheers...more >>

Hi, Export to PDF of the sample Reporting Services Report, with Euro sign is ok for the chart but for the table it is cripted. Any idea if this is caused by the euro sign ? Marco...more >>

What is the equivalent for Crystal Report Global Variables in Report Services? -- -Kevin...more >>

is there a way to set blank values in a Matrix so it defaults to 0, so it won't appear blank? ...more >>

I have some reports(.rdl) files in a solution. It is on MyServer1. And I can see using Internet Explorer; entering Location as http://MyServer1/Reports Is there a way I can deploy it to other Computer MyServer2 in particular location and then run using http://MyServer2/Reports Any suggest...more >>

Anyone come across this one: I have a report that has to print out its figures in Euros or Dollars - I pass in the locale code as a parameter (DE-DE or EN-US) respectively and change the language of the report to one of those values via an expression. The report runs, looks fine on any PC ov...more >>

i'm having trouble accessing oracle data (gee... what a shock) i get the very *helpful* error message: "MinimumCapacity must be non-negative". no idea what it means. i'm running a sql statement which calls a stored proc. it runs fine, gets the data fine (i can't use the wizard because of the a...more >>

I need to pass a parameter to determine the visibility of a remark. If the parameter defines it to be visible, I also need to toggle the visibility of the remark when the user expands or collapses the containing group. I do not want the visibility turned on when the parameter wants it always i...more >>

Hi all, I'm new to Reporting Sevices, and we're currently in the early stages of designing a Data Warehouse / Data Mart. Initially, the DW will only be used as a data source for reports developed with Reporting Services. My question is twofold: first, is it possible to use Analysis Service...more >>

I've tried the suggestions in the article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q297989 I've made sure dts is running. SQL server 2000 windows 2000 server non domain controller AD domain. <Func Name='Do_rsManagerShortcut'> <EndFunc Name='Do_rsManagerShortcut' Return='0'...more >>