Hello, I wanted to customize the document map to remove the report name from the top of the tree. Anyone know how to do that? I also wanted to add links to other reports. Is this possible? If so how do I interface with the doc map? Thanks, Patrick -- Message posted via http://www.sq...more >>

The language for browsing the report manager has suddenly switched from french to english. Is there any way to switch it back to french? ...more >>

Hi, I am trying to display a text field in a table region. Value is set to =IiF(Fields!CompanyName.IsMissing, Fields!UserName.Value, Fields! CompanyName.Value) But for some reason the text is not getting displayed, but shows a blank in the text box. I tested using individual...more >>

I have a report that I need to create a parameter of Territories which I can do with the following Data set... Territories>>> Select Name From dbo.territory and Contacts>>> SELECT TER.Name AS Territory, CAST(CON.ContactId AS varchar(36)) AS ContactID, CON.FirstName, CON.LastName, ...more >>

We have a report with a number of external images. When the report is run and exported to pdf, the resulting document is over 2mb (regardless of whether the report is run in VS or the ReportManager). When the images are changed from external to embedded, the resulting pdf document is around ...more >>

Hi, I am working with SQL Reporting services 2000.... The report is unable to connect to a remote datasource as I try to preview it. The database uses both SQL and Windows Auth. 1. Created a shared datasource in my project 2. Deployed it on the server. Used OverwriteDataSource = false 3. ...more >>

The data cell contains '=iif( Fields!dt.Value < #11/1/2004#,"*",Sum(Fields!MyValue.Value))' which is causing the subtotals (row & column) to show an * whenever the row or column shows an *. How do I get the subtotal to ignore the *'s and subtotal on just those cells that contain a value....more >>

Is there any way to shrink the file size of the PDF? When I resave the file with Acrobat it is much smaller. I can create the same report with crystal reports and have a much smaller PDF.. Maybe it is a DPI setting or something? 2Meg 1 page PDFs are just not cutting it for me. There mu...more >>

Anyone: Is it possible to install the SQL Server 2000 Reporting Services design component for Visual Studio 2003 into Visual Studio 2005 Express to design reports that will be deployed to Reporting Services running on SQL Server 2000? Thank you in advance for your time. ...more >>

I have a dataset query that contains the expression: Cost * (1 - ABS(SIGN(DATEPART(mm, OrderDate) - DATEPART(mm, DATEADD(DateInterval.Month, - 11, { fn NOW() }))))) I have had no luck replacing the { fn NOW() } with a parameter and was wondering if it was at all possible. ...more >>

Who knows how to change the size of the markers in the legend area of the chart? I can change the size of the markers on the line chart itself by going to chart data values appearance tab in chart properties. But this change does not affect the size of the markers in the legend. When I have ...more >>

Hi I have tried to implement Forms Authentication for Reporting Services. Everything works fine now except the Report Manager. Whenever I try to enter the report manager I get the following error: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. ...more >>

Has anyone tried this and if so what degree of success have you had. I've tried with both April and June CTP and cannot get anything of any use to return. This begs the question, is the only way to get data from SSAS 2000 into reporting services is to use a flattened dataset through OLEDB. In...more >>

The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation I am getting this error when I have installed my asp.net application on the server, it runs fine on my development box, here is the code that is running: Dim rService As Re...more >>

Hi, I am trying to open a report by url and one of the paramaters in the report url can contain the "&" character. This causes a problem with the url and the report will not open. Obviously if the parameter does not contain the "&" character the report works fine. How do you handle this ...more >>

Hi All, We have a Quote report which gets sent to our clients via subscription. The subscription creates the filename "Quote.pdf". Ideally, we'd like to be able to include the Quote number in the file name sent to the client. So if for instance the Quote number is 1579, the file the client...more >>

I hope someone with a bit of knowledge about Analysis Services and Reporting Services can give me some help here, please. A client has the following setup: One Windows 2000 server running SQL Server 2000 sp 3, Reporting Services sp 2 and IIS 5. One Windows 2003 server running Analysis S...more >>

Hi All, I have a matrix grid I need to put the subtotal on the left - is there a way to do this - whenever I add it - it puts it on the right i.e. Date Total Category Group1 Group2 Group3 However I want it like this ...more >>

Hi I have followed the aritcle http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk to a tee, but when i run the new web site i get a page not found for http://localhost/reports/home.aspx If i run it on the default web server everything is fine. I tried testing it...more >>

Hi, All! Recently I came across an interesting problem Preface: one of the fields in the report has 'jump to url' property set. when report is generated this link is transformed to url. However if you want to add custom url e.g. google.com, reporting server replaces that url with the url li...more >>